✅ Split string on list of strings and on whathever number

alkasel#159 · 2022-12-15T10:07:34.198Z

Hi, I need to split a string in substrings, splitting every time I find some specific strings (e.g. ">>>") and everytime I find a number of whathever length. I can successfully split on any of the specified string, but I cannot do it with numbers. My C# code is the following: ``` string value = "545: hello world: >>"; string[] separators = new string[] {|| " >>", ":" } string[] substrings = value.Split(separators, StringSplitOptions.TrimEntries); ``` I've tried with Regex.split as well but it includes all kind of characters, so I think it's not supposed to be used like that (https://learn.microsoft.com/en-us/dotnet/api/system.text.regularexpressions.regex.split?view=net-7.0).

E

ero•12/15/22, 10:08 AM

Can you show what you've tried?

E

ero•12/15/22, 10:08 AM

And the desired outcome?

Eero And the desired outcome?

A

alkasel#159OP•12/15/22, 10:33 AM

Ok. Let's assume I have the string "0: standby" (it is generated by an external program and I need to translate only the relevant parts of it).
I'm trying the following approach:

string[] separators = new string[] {
    @"} SPACEFILL DP",
    @"} ZEROFILL DP",
    @":",
    @"'\%s'", 
    @"\%s'", 
    @"<<<<", 
    @"<<<", 
    @"<<", 
    @"<",
    @">>>>", 
    @">>>",
    @">>",
    @">",
    @"system\\User", 
    @"{S_NomeRicetta}",  
    @"\*\*REF", 
    @"\*\*",
    @"/\*", 
    @"\*/",
    @"____",
    @"___",
    @"[", 
    @"]",
    @"(",
    @")",
    @":",
    @"-",
    @"/",
    @",",
    @";",
    @".",
    @"\\r\\n"
};

string regEx = "\\d";
foreach (string separator in separators) {
    regEx = string.Concat(regEx, "|", separator);
}

string value = "0: standby";
string[] symbols =  Regex.Split(value, regEx);

string[] separators = new string[] {
    @"} SPACEFILL DP",
    @"} ZEROFILL DP",
    @":",
    @"'\%s'", 
    @"\%s'", 
    @"<<<<", 
    @"<<<", 
    @"<<", 
    @"<",
    @">>>>", 
    @">>>",
    @">>",
    @">",
    @"system\\User", 
    @"{S_NomeRicetta}",  
    @"\*\*REF", 
    @"\*\*",
    @"/\*", 
    @"\*/",
    @"____",
    @"___",
    @"[", 
    @"]",
    @"(",
    @")",
    @":",
    @"-",
    @"/",
    @",",
    @";",
    @".",
    @"\\r\\n"
};

string regEx = "\\d";
foreach (string separator in separators) {
    regEx = string.Concat(regEx, "|", separator);
}

string value = "0: standby";
string[] symbols =  Regex.Split(value, regEx);

string[] separators = new string[] {
    @"} SPACEFILL DP",
    @"} ZEROFILL DP",
    @":",
    @"'\%s'", 
    @"\%s'", 
    @"<<<<", 
    @"<<<", 
    @"<<", 
    @"<",
    @">>>>", 
    @">>>",
    @">>",
    @">",
    @"system\\User", 
    @"{S_NomeRicetta}",  
    @"\*\*REF", 
    @"\*\*",
    @"/\*", 
    @"\*/",
    @"____",
    @"___",
    @"[", 
    @"]",
    @"(",
    @")",
    @":",
    @"-",
    @"/",
    @",",
    @";",
    @".",
    @"\\r\\n"
};

string regEx = "\\d";
foreach (string separator in separators) {
    regEx = string.Concat(regEx, "|", separator);
}

string value = "0: standby";
string[] symbols =  Regex.Split(value, regEx);

string[] separators = new string[] {
    @"} SPACEFILL DP",
    @"} ZEROFILL DP",
    @":",
    @"'\%s'", 
    @"\%s'", 
    @"<<<<", 
    @"<<<", 
    @"<<", 
    @"<",
    @">>>>", 
    @">>>",
    @">>",
    @">",
    @"system\\User", 
    @"{S_NomeRicetta}",  
    @"\*\*REF", 
    @"\*\*",
    @"/\*", 
    @"\*/",
    @"____",
    @"___",
    @"[", 
    @"]",
    @"(",
    @")",
    @":",
    @"-",
    @"/",
    @",",
    @";",
    @".",
    @"\\r\\n"
};

string regEx = "\\d";
foreach (string separator in separators) {
    regEx = string.Concat(regEx, "|", separator);
}

string value = "0: standby";
string[] symbols =  Regex.Split(value, regEx);

The result I expect is an array containing the string " standby" and probably some empty string too (e.g. between 0 and :). Instead, what I got is the following array:

[0]    ""    string
[1]    ""    string
[2]    ""    string
[3]    ""    string
[4]    ""    string
[5]    ""    string
[6]    ""    string
[7]    ""    string
[8]    "S"    string
[9]    ""    string
[10]    "t"    string
[11]    ""    string
[12]    "a"    string
[13]    ""    string
[14]    "n"    string
[15]    ""    string
[16]    "d"    string
[17]    ""    string
[18]    "b"    string
[19]    ""    string
[20]    "y"    string
[21]    ""    string
[22]    ""    string

[0]    ""    string
[1]    ""    string
[2]    ""    string
[3]    ""    string
[4]    ""    string
[5]    ""    string
[6]    ""    string
[7]    ""    string
[8]    "S"    string
[9]    ""    string
[10]    "t"    string
[11]    ""    string
[12]    "a"    string
[13]    ""    string
[14]    "n"    string
[15]    ""    string
[16]    "d"    string
[17]    ""    string
[18]    "b"    string
[19]    ""    string
[20]    "y"    string
[21]    ""    string
[22]    ""    string

[0]    ""    string
[1]    ""    string
[2]    ""    string
[3]    ""    string
[4]    ""    string
[5]    ""    string
[6]    ""    string
[7]    ""    string
[8]    "S"    string
[9]    ""    string
[10]    "t"    string
[11]    ""    string
[12]    "a"    string
[13]    ""    string
[14]    "n"    string
[15]    ""    string
[16]    "d"    string
[17]    ""    string
[18]    "b"    string
[19]    ""    string
[20]    "y"    string
[21]    ""    string
[22]    ""    string

[0]    ""    string
[1]    ""    string
[2]    ""    string
[3]    ""    string
[4]    ""    string
[5]    ""    string
[6]    ""    string
[7]    ""    string
[8]    "S"    string
[9]    ""    string
[10]    "t"    string
[11]    ""    string
[12]    "a"    string
[13]    ""    string
[14]    "n"    string
[15]    ""    string
[16]    "d"    string
[17]    ""    string
[18]    "b"    string
[19]    ""    string
[20]    "y"    string
[21]    ""    string
[22]    ""    string

A

alkasel#159OP•12/15/22, 10:34 AM

While I was testing for giving the example to you, I realized that probably there is something wrong with the regular expression

E

ero•12/15/22, 10:38 AM

Very

Aalkasel#159 Ok. Let's assume I have the string "0: standby" (it is generated by an external ...

E

ero•12/15/22, 10:42 AM

I'm not really sure if you're meaning to escape some stuff in your separators?

E

ero•12/15/22, 10:42 AM

Like what's

system\\User

system\\User

system\\User

system\\User?

E

ero•12/15/22, 10:43 AM

Or

\*\*REF

\*\*REF

\*\*REF

\*\*REF?

\%s

\%s

\%s

\%s?

E

ero•12/15/22, 10:43 AM

What do you expect those to match?

A

alkasel#159OP•12/15/22, 10:44 AM

For **REF, since asterisk is a regex keyword, I need to escape it in order to let regex know that I want to match exactly **REF

E

ero•12/15/22, 10:45 AM

Asterisk is not a regex "keyword"

A

alkasel#159OP•12/15/22, 10:46 AM

I thought it was from here

A

alkasel#159OP•12/15/22, 10:46 AM

https://stackoverflow.com/questions/2801549/how-do-i-replace-an-actual-asterisk-character-in-a-regex-expression

Stack Overflow

How do I replace an actual asterisk character (*) in a Regex expres...

I have a statement:

I have a string such as

content = "* test "
I want to search and replace it with so when I am done the string contains this:

content = "() test (*)"
My code is:

A

alkasel#159OP•12/15/22, 10:47 AM

This one is on C# specifically

A

alkasel#159OP•12/15/22, 10:47 AM

https://stackoverflow.com/questions/23488512/find-and-replace-asterisk-from-a-string-using-regex

Stack Overflow

Find and replace Asterisk (*) from a string using Regex

I have a string like this:
Durham * versus Yorkshire
and I have used a regex in C# to replace that asterisk in the string with some text, as:

string aString = "Durham * versus Yorkshire";
string

E

ero•12/15/22, 10:51 AM

You're absolutely right, I'm sorry. I fully blanked on that one somehow

M

MODiX•12/15/22, 10:51 AM

Ero#1111

REPL Result: Success

string[] separators =
{
    @"\} SPACEFILL DP",
    @"\} ZEROFILL DP",
    @":",
    @"'%s'", 
    @"%s'", 
    @"<<<<", 
    @"<<<", 
    @"<<", 
    @"<",
    @">>>>", 
    @">>>",
    @">>",
    @">",
    @"system\\User", 
    @"{S_NomeRicetta}",  
    @"\*\*REF", 
    @"\*\*",
    @"/\*", 
    @"\*/",
    @"____",
    @"___",
    @"\[", 
    @"\]",
    @"\(",
    @"\)",
    @":",
    @"-",
    @"/",
    @",",
    @";",
    @"\.",
    @"\r\n"
};

string pattern = @"\d";
foreach (string separator in separators) {
    pattern += $"|{separator}";
}

string value = "0: standby";
string[] symbols =  Regex.Split(value, pattern);

symbols

string[] separators =
{
    @"\} SPACEFILL DP",
    @"\} ZEROFILL DP",
    @":",
    @"'%s'", 
    @"%s'", 
    @"<<<<", 
    @"<<<", 
    @"<<", 
    @"<",
    @">>>>", 
    @">>>",
    @">>",
    @">",
    @"system\\User", 
    @"{S_NomeRicetta}",  
    @"\*\*REF", 
    @"\*\*",
    @"/\*", 
    @"\*/",
    @"____",
    @"___",
    @"\[", 
    @"\]",
    @"\(",
    @"\)",
    @":",
    @"-",
    @"/",
    @",",
    @";",
    @"\.",
    @"\r\n"
};

string pattern = @"\d";
foreach (string separator in separators) {
    pattern += $"|{separator}";
}

string value = "0: standby";
string[] symbols =  Regex.Split(value, pattern);

symbols

string[] separators =
{
    @"\} SPACEFILL DP",
    @"\} ZEROFILL DP",
    @":",
    @"'%s'", 
    @"%s'", 
    @"<<<<", 
    @"<<<", 
    @"<<", 
    @"<",
    @">>>>", 
    @">>>",
    @">>",
    @">",
    @"system\\User", 
    @"{S_NomeRicetta}",  
    @"\*\*REF", 
    @"\*\*",
    @"/\*", 
    @"\*/",
    @"____",
    @"___",
    @"\[", 
    @"\]",
    @"\(",
    @"\)",
    @":",
    @"-",
    @"/",
    @",",
    @";",
    @"\.",
    @"\r\n"
};

string pattern = @"\d";
foreach (string separator in separators) {
    pattern += $"|{separator}";
}

string value = "0: standby";
string[] symbols =  Regex.Split(value, pattern);

symbols

string[] separators =
{
    @"\} SPACEFILL DP",
    @"\} ZEROFILL DP",
    @":",
    @"'%s'", 
    @"%s'", 
    @"<<<<", 
    @"<<<", 
    @"<<", 
    @"<",
    @">>>>", 
    @">>>",
    @">>",
    @">",
    @"system\\User", 
    @"{S_NomeRicetta}",  
    @"\*\*REF", 
    @"\*\*",
    @"/\*", 
    @"\*/",
    @"____",
    @"___",
    @"\[", 
    @"\]",
    @"\(",
    @"\)",
    @":",
    @"-",
    @"/",
    @",",
    @";",
    @"\.",
    @"\r\n"
};

string pattern = @"\d";
foreach (string separator in separators) {
    pattern += $"|{separator}";
}

string value = "0: standby";
string[] symbols =  Regex.Split(value, pattern);

symbols

Result: string[]