Hi
I'm new to RegEx, and I'm hoping to get some help parsing column that maybe Null or a String (word). As well as parsing for decimals, and negative numbers.
Original
ID,Completion_Status,new_cx_flag, |
-2, ,1.0000 |
-2, ,.0000 |
146920,Yes,1.0000 |
133734,No,.0000 |
Desired Outcome
ID | Completion_Status | new_cx_flag |
-2 | 1.0000 | |
-2 | 0.0000 | |
146920 | Yes | 1.0000 |
133734 | No | 0.0000 |
Thanks in advance
Solved! Go to Solution.
Hi @nuclearpz86 ,
Attached is a example showing how to get that done with text to column tools and regex tool.
Let me know if that works for you.
Best,
Fernando Vizcaino
Would the solution be different if for the second column is NULL instead of of a space
ID,Completion_Status,new_cx_flag, |
-2,,1.0000 |
-2,,.0000 |
146920,Yes,1.0000 |
133734,No,.0000 |
With text to columns tool, its the same.
For the regex formula, it would need a small change for ([^,]*),([^,]*),([^,]*)
Best,
Fernando Vizcaino
Thank you so much @fmvizcaino and @echuong1 for all your help!