parse using regex

[umairah]

Hello,

I have data that I want parse and try to do the expression to get the result but it's only work in some field. Really appreciate anyone can point out what I do wrong here.  .

I will attached the sample data for your reference.

[seinchyiwoo · Accepted solution]

This should work:

(\d+.\d+\s*)(\(.*\))([\w*\s*\.*\,*]*)\s(\d{1,2})

and the output looks like this:

Cheers,

Seinchyi

[umairah]

Hi @seinchyiwoo ,

Thank you..It helps me alot.