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

[wonka1234]

Hi,

I have this in a row

Header

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

But i want it split to

Header	Header 2	Header 3	Header 4	Header 5	Header 6
123456	DUE FRM BROKER MY BANK ACCOUBT TODAY	.00	.00	.00	3899008.26

Is there anyway to do this for an entire dataset?

[griffinwelsh]

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

[flying008]

Hi, @wonka1234 

FYI.

[Yoshiro_Fujimori]

@wonka1234 ,

I would parse the string with RegEx Tool as below.

I hope this helps.

RegEx Tool Configuration

Output