The best way to split a string without a separator

Question

I have string:

MONEY-ID123456:MONEY-STAT43:MONEY-PAYetr-1232832938

From the string above you can see that it is separated by colon (:), but in the actual environment, it does not have a standard layout.

The standard is the fields name, example MONEY-ID, and MONEY-STAT.

How I can I split it the right way? And get the value from after the fields name?

TQ, I have tried with substring and split, difficult, how can regular expressions and does it correctly? — Alvin, Jul 30 '12 at 08:26
Just to be sure, you have 3 "parts": `MONEY-ID`, `MONEY-STAT` and `MONEY-PAY`, right? — Andre Calil, Jul 30 '12 at 08:27
As flexible as possible, because the columns fields can be remove and delete. — Alvin, Jul 30 '12 at 08:35

score 3 · Answer 1 · edited May 23 '17 at 11:48

3

As Andre said, I would personally go with regular expressions. Use groups of something like,

"MONEY-ID(?<moneyid>.*)MONEY-STAT(?<moneystat>.*)MONEY-PAYetr(?<moneypay>.*)"

See this post for how to extract the groups. Probably followed by a private method that trims off illegal characters in the matched group (e.g. : or -).

edited May 23 '17 at 11:48

Community

1
1

answered Jul 30 '12 at 08:28

M Afifi

4,645
2
28
48

Sorry all, I am trying the value after the fields name, like MONEY-ID123456, get the value 123456 – Alvin Jul 30 '12 at 08:40

alex.b · Accepted Answer · 2012-07-30T13:12:47.350

Something like that should work:

string s = "MONEY-ID123456:MONEY-STAT43:MONEY-PAYetr-1232832938";
            Regex regex = new Regex(@"MONEY-ID(?<moneyId>.*?)\:MONEY-STAT(?<moneyStat>.*?)\:MONEY-PAYetr-(?<moneyPaetr>.*?)$"); Match match = regex.Match(s);       
            if (match.Success)
            {
                Console.WriteLine("Money ID: " + match.Groups["moneyId"].Value);


                Console.WriteLine("Money Stat: " + match.Groups["moneyStat"].Value);
                Console.WriteLine("Money Paetr: " + match.Groups["moneyPaetr"].Value);

            }

            Console.WriteLine("hit <enter>");
            Console.ReadLine();

UPDATE Answering additional question, if we're not sure in format, then something like the following could be used:

string s = "MONEY-ID123456:MONEY-STAT43:MONEY-PAYetr-1232832938";
        var itemsToExtract = new List<string> { "MONEY-STAT", "MONEY-PAYetr-", "MONEY-ID", };

        string regexFormat = @"{0}(?<{1}>[\d]*?)[^\w]";//sample - MONEY-ID(?<moneyId>.*?)\:
        foreach (var item in itemsToExtract)
        {
            string input = s + ":";// quick barbarian fix of lack of my knowledge of regex. Sorry
            var match = Regex.Match(input, string.Format(regexFormat, item, "match"));
            if (match.Success)
            {
                Console.WriteLine("Value of {0} is:{1}", item, match.Groups["match"]);
            }
        }

        Console.WriteLine("hit <enter>");
        Console.ReadLine();

Sorry all, I am trying the value after the fields name, like MONEY-ID123456, get the value 123456. — Alvin, Jul 30 '12 at 08:40
This is good when the string is in that format, what if some of the fields are not there? — Alvin, Jul 30 '12 at 10:15

score 1 · Answer 3 · edited May 29 '19 at 16:30

Check this out:

string regex = @"^(?i:money-id)(?<moneyid>.*)(?i:money-stat)(?<moneystat>.*)(?i:money-pay)(?<moneypay>.*)$";
string input = "MONEY-ID123456:MONEY-STAT43:MONEY-PAYetr-1232832938";
Match regexMatch = Regex.Match(input, regex);

string moneyID = regexMatch.Groups["moneyid"].Captures[0].Value.Trim();
string moneyStat = regexMatch.Groups["moneystat"].Captures[0].Value.Trim();
string moneyPay = regexMatch.Groups["moneypay"].Captures[0].Value.Trim();

score 0 · Answer 4 · edited May 29 '19 at 16:30

0

For example, using regular expressions,

(?<=MONEY-ID)(\d)*

It will extract

from your string.

edited May 29 '19 at 16:30

Peter Mortensen

30,738
21
105
131

answered Jul 30 '12 at 08:27

Shai

25,159
9
44
67

JohnnBlade · Answer 5 · 2012-07-30T08:39:38.563

Try

                    string data = "MONEY-ID123456:MONEY-STAT43:MONEY-PAYetr-1232832938";
                    data = data.Replace("MONEY-", ";");

                    string[] myArray = data.Split(';');
                    foreach (string s in myArray)
                    {
                        if (!string.IsNullOrEmpty(s))
                        {
                            if (s.StartsWith("ID"))
                            { 

                            }
                            else if (s.StartsWith("STAT"))
                            {

                            }
                            else if (s.StartsWith("PAYetr"))
                            { 

                            }
                        }
                    }

results in

ID123456:
STAT43:
PAYetr-1232832938

I would rather use Reg Ex, this is just a fast sample if you havent used Reg ex before — JohnnBlade, Jul 30 '12 at 08:30

The best way to split a string without a separator

5 Answers5

Linked