Transform script split source data into 2 target fields

[pvv1045330]

Hi,

i need to take a source field which has values with space separated and split them into 2 different target field , how can I resolve this issue and where can I write a script (field map script, transform map script)

we are getting the following data from excel

rowA =1234    city (this pin and city came as one row on excel), pin number have only 4number

           =3627   city1

           =2615   city3

Now I want split them after and put them into 2 different table field

pin=1233

city=city

[Ankur Bawiskar · Accepted solution]

@pvv1045330 

you can use onBefore transform script and handle it

what did you start and where are you stuck?

[pvv1045330]

Thanks for the replay 

For that I'm using run script, it's working as excepted