Split string - C# - complicated

Question

I've the folllowing string and I want to split it:

"INSERT INTO test (test, test1, test2, test3) values (@test, @test1, @test2, @test3)";

The values that I want to get are the seperated @test @test1 @test2 @test3 So I can do something different with each one

This is what I currenly have so far.

string str = "INSERT INTO test (test, test1, test2, test3) values (@test, @test1, @test2, @test3)"
var pattern = @"(?<=@)[^@]*(?=>,)";
foreach (var m in System.Text.RegularExpressions.Regex.Split(str, pattern))
     {
        Console.WriteLine(m);
     }

This returns the whole string:

INSERT INTO test (test, test1, test2, test3) values (@test, @test1, @test2, @test3)

I hope some of you can help me because it's the last pin for my program to work.

The point is: how can you determine the boundaries where these values start from and end at? If you plan to use a regex, it should know where to start matching and where to end. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Sep 8, 2016 at 12:47
I can split it at @ and at , and at the @ later but still how do i do that. — Joey
– Joey, Commented Sep 8, 2016 at 12:50
Ok, try Regex.Matches(str, @"@\w+").Cast<Match>().Select(p => p.Value).ToList(). Although at this point, Kell's answer should work the same. Well, with the exception that the regex only matches word chars after @. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Sep 8, 2016 at 12:50
why not use a String.Format? .... or even better SQLParameters? — Caspar Kleijne
– Caspar Kleijne, Commented Sep 8, 2016 at 13:27
Yeah I used kells answer @WiktorStribiżew and it works perfectly Do you know where I can learn to regex like that ? — Joey
– Joey, Commented Sep 8, 2016 at 13:44

Kell · Accepted Answer · 2016-09-08 12:48:10Z

1

Well I'm not fond of regexes but a lot of people are, so I'll give you my answer as a good old string method:

var parameters = str.Split('@').Skip(1).Select(var=>"@" + var.Trim(new[] {',',')', ' '}));

answered Sep 8, 2016 at 12:48

Kell

3,33724 silver badges22 bronze badges

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

2 Comments

Ian of Oz Over a year ago

And my variation: str.Split(' ', '(', ')', ' ').Where(s => s.StartsWith("@")) Split takes a params array, so you don't need to bother creating an array

Joey Over a year ago

works perfectly and I even understand why thank you !

Zay Lau · Accepted Answer · 2016-09-08 12:42:37Z

1

Had you try string pattern = @"@[a-zA-Z0-9]+";?

answered Sep 8, 2016 at 12:42

Zay Lau

1,8641 gold badge12 silver badges17 bronze badges

4 Comments

Joey Over a year ago

In the first line it returns INSERT INTO test (test, test1, test2, test3) values( second , third , 4th , 5th ) sorry it places everything on same line you need to read it like number of the row with what it returns

Kamalesh Wankhede Over a year ago

This seems to be working. Check here

Wiktor Stribiżew Over a year ago

@krw12572: Yeah, but not with Regex.Split (see Split List here).

Zay Lau Over a year ago

@WiktorStribiżew Although the website didn't high light the @test, but I found it gets the @test when I browser the table tab. Too lazy to test on C#

Collectives™ on Stack Overflow

Split string - C# - complicated

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related