Splitting Row into multiple columns, Delimiter after a certain amount of spaces?

Question

Hi,

I have this in a row

Header123456 DUE FRM BROKER MY BANK ACCOUBT TODAY .00 .00 .00 3899008.26

But i want it split to

HeaderHeader 2Header 3Header 4Header 5Header 6123456 DUE FRM BROKER MY BANK ACCOUBT TODAY.00.00.003899008.26

Is there anyway to do this for an entire dataset?

Yoshiro_Fujimori · Answer

@wonka1234 ,

I would parse the string with RegEx Tool as below.

I hope this helps.

RegEx Tool Configuration

Output

RegExParse.yxmd

flying008 · Answer

Hi, @wonka1234

FYI.

griffinwelsh · Answer

@wonka1234 Have a look at this and see if it works from you. If your data is in the same format for all rows it will. If not please post a larger sample set.

Sample.yxmd