NEED URGENT HELP Separating 1 column into multiple column.

[Sivory18]

Hi guys, I need to go from Table A > Table B. Pleaee help

[KGT]

I don't normally like suggesting REGEX straight up, but it's the easiest way.

REGEX TOOL: Parse

(.{5})(.{5})(.{3})(.{9})(.{5})(.{6})(.{5})(.{5})(.{3})(.*)

This will create a field of the length specified for each group.

[Sivory18]

Hi KGT, the values come out as null. Is there a way to fix that

[alexnajm]

Can you show us @Sivory18 ? That statement looks accurate!

[Sivory18]

Here the document if you want to try @alexnajm. 

[KGT]

I didn't look at the field and as there was no data had to recreate something small. I looked at the created fields not the original field where it actually comes from 2 different fields and so that previous formula would have worked if F3 and F4 were concatenated.

• First Parse: ON F3: 
  • (.{5})(.{5})(.{3})(.{9})(.{5})(.{6})(.*)
• Second Parse: ON F4: 
  • (.{5})(.{5})(.{3})(.*)