Forum Discussion

vsuresh's avatar
vsuresh
New Contributor
6 years ago

Mapper- string to int

Hello. I have a string value being returned. It contains numbers 0,1,2,3,4 and some empty strings. I need to insert this into a int datatype field which allows NULL values. How do I convert the str...
vsuresh's avatar
vsuresh
New Contributor
6 years ago
Copy LinkReport

I have an input value of string datatype. It has values 0,1,2,3,4 and blanks( empty values). I want to convert this to datatype int for the numbered values and the blanks I want to convert to NULL value since the field in the table takes NULL values. Please let me know if this makes sense.

Thanks

cjhoward18's avatar
cjhoward18
Employee
6 years ago
Copy LinkReport

@vsuresh

so the doc looks like this exactly?:
{values: “0, 1,2,3,4”}

or is there commas separating the empty values like this?:
{values: “0, ,1,2,3,4”}

and the desired result is this?:
{values: [0, Null. 1, 2, 3, 4]}