Split the string using regex

[RichardAlt]

Hi guys,

How can I delimit this string using Regex Tool?

sample Total discount amount RM 14.77
sample Total discount amount RM 61.62
sample Total discount amount RM 1,380.00
sample Total discount amount RM 5.19
sample Total discount amount RM 48.73

My desired output is something like this.

Column 1                                   Column 2     Column 3

sample Total discount amount   RM               14.77

sample Total discount amount   RM               61.62

sample Total discount amount   RM               1,380.00

sample Total discount amount   RM               5.19

sample Total discount amount   RM               48.73

Thanks!

[fmvizcaino · Accepted solution]

Hi @RichardAlt ,

You can use the parse regex method and the following expression.

(.*)\s(\w+)\s(.*)

Here is an example for you.

Best,

Fernando Vizcaino

[Qiu]

Would it be acceptable not using Regex?
Tried with Formula Tool and RegEx.

(\w*\s\w*\s\w*\s\w*)\s(\w*)\s(\d*.\d*)