DSXchange

Posted: **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

Posted: **Mon Oct 11, 2010 9:12 am**

Field()

Posted: **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.

Posted: **Mon Oct 11, 2010 10:15 am**

That worked!!

Thank you

DSXchange

Dividing a field into two fields

Dividing a field into two fields