# How to split a field value into 2 fields in the output file **URL:** \ **Category:** CloverDX Platform\ **Created:** [November 1, 2010, 12:00am UTC](https://forum.cloverdx.com/t/how-to-split-a-field-value-into-2-fields-in-the-output-file/771 "2010-11-01T00:00:00Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![mnkumar](https://avatars.discourse-cdn.com/v4/letter/m/a9adbd/32.png) [@mnkumar](https://forum.cloverdx.com/u/mnkumar)\ **Post date:** [November 1, 2010, 12:00am UTC](https://forum.cloverdx.com/t/how-to-split-a-field-value-into-2-fields-in-the-output-file/771/1 "2010-11-01T00:00:00Z")
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 ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [November 1, 2010, 1:35pm UTC](https://forum.cloverdx.com/t/how-to-split-a-field-value-into-2-fields-in-the-output-file/771/2 "2010-11-01T13:35:56Z")
Hello, it can be done in many ways., eg. read with one metadata (mixed) and write with another (delimited) or use [Reformat](http://www.cloveretl.com/documentation/UserGuide/topic/com.cloveretl.gui.docs/docs/reformat.html) for splitting the field.