Hi guys, I need to go from Table A > Table B. Pleaee help
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.
Hi KGT, the values come out as null. Is there a way to fix that
Can you show us @Sivory18 ? That statement looks accurate!
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.