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

mnkumar

• November 01, 2010 00:00

• Answered

Follow

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

  • November 01, 2010 13:35

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.