Mapper- string to int

Question

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 string to int and the blanks to NULL and map.
Thanks

cjhoward18 · Answer

@vsuresh
I am not exactly sure what you mean by a string that contains numbers and some empty strings.
Can you give a specific example (input/output pair) of the data you have and are trying to get?

vsuresh · Answer

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 · Answer

@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]}

Forum Discussion

Mapper- string to int

Recent Discussions

401 error with HTTP Client and NTLM

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working