Parsing Data to Their Specific Columns

[mohdhafiz]

Hi, I am using RegEx tool to parse the data so that it have their own column. However, my regular expression is not working. I have two excel files attached together below. Can anyone help me with this? I really appreciate it if you guys can help. Thank you.

Output needed: 

[JoeL]

Hi @mohdhafiz 

Try this Regex out:

(\d[\d\.]+).*?([^\d]+).*?(\d[\d\.]+).*?(\d[\d\.]+)

[vizAlter]

Hi @mohdhafiz — Try this solution... you need to use "RegEx" tool:

1st RegEx expression for "Parse" output method:

(It will create four new columns as per your desired output)

(\d+)\s([^\d]+)([\d.]+)[.\s]+([\d.]+)

2nd RegEx expression for "Replace" output method:

(It will remove extra spaces or "." from the end)

([\s.]+$)

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

[vizAlter · Accepted solution]

@mohdhafiz — Hope this post is solved now.

Can you please mark it "Solved" if given solution(s) resolved your query. This will help other users find the same answer/resolution.  Thank you.