Parsing Data to Their Specific Columns

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:

Parse Output.PNG

Datasets

Parse

Accepted answers

@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.

All comments

Try this Regex out:

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

Regex to parse.png

Parse regex.yxmd

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.

Parsing Data to Their Specific Columns.yxmd

@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.

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

michael_weaver 335

Hollingsworth 335