RegEx Parsing Columns with Null or String

[nuclearpz86]

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

[fmvizcaino]

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

[nuclearpz86]

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

[echuong1]

You can also achieve this using the text to columns tool and the dynamic rename. 

Essentially, you'd import the file without field names and then use th

e text to columns to parse by comma. From there you can change the field names using dynamic rename. 

[fmvizcaino · Accepted solution]

With text to columns tool, its the same.

For the regex formula, it would need a small change for ([^,]*),([^,]*),([^,]*)

Best,

Fernando Vizcaino

[nuclearpz86]

Thank you so much @fmvizcaino  and @echuong1 for all your help!