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

Thanks

3 Replies

  • cjhoward18's avatar
    cjhoward18
    Employee
    6 years ago
    Report

    @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's avatar
    vsuresh
    New Contributor
    6 years ago
    Report

    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
      Report

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