โ06-13-2019 11:03 AM
i am getting the input value from the flat file. i am reading all the column values and have to load in the target table only if it is a number. Can i know is there any built-in function to validate or handle this.
โ06-13-2019 11:14 AM
Hi @Mari
The isNan() function can tell you if the value is a number or not. Usage is like this:
isNaN(โ4โ) = false
isNaN(โfooโ) = true
you can then use parseInt(โ4โ) to get the number 4 if needed
โ06-13-2019 11:14 AM
There are some parseInt() and isNaN() functions that you may find useful.
โ06-13-2019 11:32 AM
Thanks. It helps.