Dividing a field into two fields

kennyapril · Post by **kennyapril** » Mon Oct 11, 2010 9:06 am

The source is a file coming to the server which has a field Name-UserID
this field should be divided as two separate fields as Name and UserID

The input is one field

Tom-101
Joseph-102
John-103

the output has to be like two fields separately divided
Tom 101
Joseph 102
John 103

please suggest me the function to be used in transformer

anbu · Post by **anbu** » Mon Oct 11, 2010 9:12 am

Field()

ArndW · Post by **ArndW** » Mon Oct 11, 2010 9:34 am

To be more specific, "FIELD(In.Column,"-",1)" is the name, "FIELD(In.Column,"-",2) is the user-id.

kennyapril · Post by **kennyapril** » Mon Oct 11, 2010 10:15 am

That worked!!

Thank you