Splitting a string into multiple values

[MorneViljoen]

Hi 

I am looking for something to assist me in changing the following type of text:

15-080 3 000 2,868,938,288 5,984,479,335 -52

Into

2,868,938,288

5,984,479,335

So basically a formula or something to only keep the two string values where they contain commas.

Note that the initial string can be longer, but will always have 2 strings which have commas in.

Thanks in advance

[Emil_Kos]

Hi @MorneViljoen,

Text to columns will help you with this task. After you create a row for each position you can simply filter out rows that you don't need. 

The output:

[MorneViljoen]

@Emil_Kos  Thanks, this could work, but one thing I forgot to mention is that I have multiple rows like that (see attached) which would need to be changed. Also added how I think the output should look which I forgot to mention previously.

[Emil_Kos]

Hi @MorneViljoen,

I have prepared a workflow for you:

The output:

[mpennington · Accepted solution]

I think this RegEx would work:

(\d{1,3},.*)\s(\d{1,3},.*)\s|$

[MorneViljoen]

Thanks this is working great

[MorneViljoen]

@Emil_Kos I tried this one but the column did not format like it should.

But the regex one worked great.