Extract part of the string

Question

I have thousands of lines of string type data, and what I need is to extract the string after AS. For example this line:

CASE  END AS NoHearing,

What I want would be NoHearing,

This line:

 CASE 19083812 END AS NoRequset

What I need would be NoRequset

So far I have tried couple ways of doing it but no success. Can't use .split because AS is not Char type.

You can split by strings. https://msdn.microsoft.com/en-us/library/tabh47cf%28v=vs.110%29.aspx — Asad Saeeduddin, Apr 27 '15 at 17:40
Is it safe to assume that "AS" only appears once (and must happen, no rows without)? If not, what about "END AS"? — Robert, Apr 27 '15 at 17:42
Split by the whitespace `' '` and take the `.Last()` result. — Pierre-Luc Pineault, Apr 27 '15 at 17:44

score 2 · Answer 1 · edited Apr 27 '15 at 17:43

2

If this will be the only way that AS appears in the string:

noRequestString = myString.Substring(myString.IndexOf("AS") + 3);

edited Apr 27 '15 at 17:43

juharr

31,741
4
58
93

answered Apr 27 '15 at 17:41

browndwarf75

94
5

Thanks @juharr - appreciate the correction as I get used to the UI. – browndwarf75 Apr 27 '15 at 17:47

score 0 · Answer 2 · answered Apr 27 '15 at 17:46

Using Regex I extract all between the AS and a comma:

string data = @"
CASE  END AS NoHearing,
CASE 19083812 END AS NoRequset
";

var items = Regex.Matches(data, @"(?:AS\s+)(?<AsWhat>[^\s,]+)")
                 .OfType<Match>()
                 .Select (mt => mt.Groups["AsWhat"])
                 .ToList();


Console.WriteLine (string.Join(" ", items)); // NoHearing NoRequset

Extract part of the string

2 Answers2