How to split a field value into 2 fields in the output file

[mnkumar]

Hi,

Could anyone please let me know how to split a field value into 2 field fields in the output file.

My Input Table looks like this:
ID md srcode zip
01GB 50001
23DFH 50234
14CVB 50015
XXX0 04KI 50452
XXX1 03TT 50033

The output should be like:
ID md srcode1 srcode2 zip
01 GB 50001
23 DFH 50234
14 CVB 50015
XXX0 04 KI 50452
XXX1 03 TT 50033

The field ‘srcode’ in the input table is splitted into 2 fields ‘srcode1’ and ‘srcode2’ in the output table. Thanks in advance.

Thanks,
mnkumar

[avackova]

Hello,
it can be done in many ways., eg. read with one metadata (mixed) and write with another (delimited) or use Reformat for splitting the field.