Parse Data with blank columns

JUUP

Hello,

I am trying to parse a dataset from 1 to 9 columns. The first five columns are always populated and the last four may or may not have data in them. The first five successfully parsed using Regex to look at spaces and digits since their format is always the same, but I'm not sure how to handle the last four. The data looks something like this:

End Column Header

Yes      XYZ            fulfilled

No                  No

ABC    Yes

And I need it to look like this:

Column 6	Column 7	Column 8	Column 9
Yes	XYZ		fulfilled
No		No
	ABC	Yes

I've been looking on the board but haven't found anything that seems like it would apply. I appreciate any advice you can share.

Thanks!

fmvizcaino

Hi @JUUP ,

I have adapted the regex to get that case as well.

Let me know if that works for you.

Best,

Fernando Vizcaino

2019-12-03 Parse Data with blank columns.yxmd