RegEx delimit

[lvprasad]

i've data like this format (-4 812.50 24 009.46). Please help to delimit this data into two columns like '-4 812.50'  and '24 009.46'

[Thableaus]

Hi @lvprasad 

Could you please provide more examples of your data?

Cheers,

[OllieClarke · Accepted solution]

Based on the one row you've given, tokenise to columns with this formula:

(.*?\.\d{2})

[neilgallen · Accepted solution]

assuming the parenthesis are a part of the data, then you could use 

(?:\()(-*\d+\s\S+)(?:\s+)(.*)(?:\)$)

It's a simple adjust if the parenthesis are not present in the data. This pattern also assumes there may or may not be a "-" on the first group.

[benakesh]

Hi @lvprasad ,

I tried with splitting  by space and combine by formula . 

[lvprasad]

Thank you @neilgallen. actually there are no parenthesis, but some times we may have negative sign and some times not. Thanks for your solution.

[lvprasad]

Thank you @OllieClarke. it worked.