i’d like to be able to determine if a variable is number value or not prior to importing to a DB. i perform a parseFloat on that variable but I see it coming back as NaN and have tried multiple things to filter it out without success. does anyone know the best technique in snaplogic?
Did you look at this?
Always search snapLogic docs for help.
Returns a string indicating the object type.
The possible return values are: “boolean”, “number”, “string”, “object”, and “array”.
i actually stumbled upon the isNaN function on the string methods documentation. i was looking in the numbers documentation which is why i couldnt find it. this seemed to work for me: