Extract part of the string [duplicate]

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. msdn.microsoft.com/en-us/library/tabh47cf%28v=vs.110%29.aspx — user1726343
– user1726343, Commented Apr 27, 2015 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
– Robert, Commented Apr 27, 2015 at 17:42
Split by the whitespace ' ' and take the .Last() result. — Pierre-Luc Pineault
– Pierre-Luc Pineault, Commented Apr 27, 2015 at 17:44

juharr · Accepted Answer · 2015-04-27 17:43:49Z

2

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

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

edited Apr 27, 2015 at 17:43

juharr

32.4k4 gold badges60 silver badges95 bronze badges

answered Apr 27, 2015 at 17:41

browndwarf75

945 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

browndwarf75 Over a year ago

Thanks @juharr - appreciate the correction as I get used to the UI.

ΩmegaMan · Accepted Answer · 2015-04-27 17:46:18Z

0

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

answered Apr 27, 2015 at 17:46

ΩmegaMan

32.2k13 gold badges110 silver badges138 bronze badges

Collectives™ on Stack Overflow

Extract part of the string [duplicate]

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related