How to fetch data from string using C#

Revathi Parvathi

I have one string

str="Sales Location: ROAD\nOrder Taker: DAWN RUSHIK Sales Rep: DAWN RUSHIK\nPhone: (570) 650-0155 Fax: (866) 937-3391\nEmail: [email protected]";

How to fetch sales rep name ?

Input: Sales Location: ROAD\nOrder Taker: DAWN RUSHIK Sales Rep: DAWN RUSHIK\nPhone: (570) 650-0155 Fax: (866) 937-3391\nEmail: [email protected]

output: DAWN RUSHIK

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel9y ago
Accepted answer
You should be good if you use below regex.

Also, try to enhance it, if possible.

I am using Multiline option for matching the string so that it will focus on start and end of the string (inside string- interpreting \n characters).
string pattern = @"Sales Rep: [A-Za-z]+\s[A-Za-z]+";
var result = Regex.Match(testString, pattern , RegexOptions.Multiline).ToString().Split(':')[1];
output:
+1
Revathi Parvathi9y ago
Hi Tapan Patel/Ankit Sharma
Both codes are working.thank you for your help.
0
Ankit Sharma9y ago
Hi Revathi,

Please use this code and let me know if it works
string test = str.Substring(str.IndexOf("Sales Rep"), (str.IndexOf("\nPhone") - str.IndexOf("Sales Rep"))).Split(':')[1];
Console.WriteLine(test);
+1
Naveen Bisht9y ago
string str = "Sales Location: ROAD\nOrder Taker: DAWN RUSHIK Sales Rep: DAWN RUSHIK\nPhone: (570) 650-0155 Fax: (866) 937-3391\nEmail: [email protected]";
string[] words = str.Split(':');
// use below to print all
foreach (string word in words)
{ Console.WriteLine(word); }
+1