scheduled import job

[chercm]

i am using a walkup experience user badge table and a sql server with badge numbers and facility number . i will be using scheduled import job to import the user badge details to the user_badge table in servicenow . 

But the badge information from the sql data is having xxxx:xxxx , how can i extract the number after the colon during the import process to be place into the badge column in the user_badge table ?

[chercm]

seems that the transform is not taking the : (colon) properly . not splitting at all . it appearing as 002351234 instead of just the badge number:  1234

[Ankur Bawiskar]

@chercm 

it looks like the colon coming in source value and the 1 you are using from keyboard are not the same.

Did you try to copy the same character by printing the source value in logs and then use it in split?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[chercm]

@Ankur Bawiskar  how to use the substring method to get the information separated??

[Ankur Bawiskar]

@chercm 

you cannot use substring or split if both the characters i.e. colon (coming from source and from your keyboard) are different.

Did you check that?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[chercm]

@Ankur Bawiskar any suggestion to fix that?