Hi,
Please let me know how can I convert string data to integer datatype.
Thanks,
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @tejashriw155148 ,
you must do a split after query selection to get two branches (one for INT and another for STRING).
After that you may convert to preferred type in Enrichment nodes in needed (per branch.)
If your data have only two characters you may adapt query in split:
Generally, with provided data all input values are string. Then you need to separate it with split (above) and do conversion of numbers to integer.
Regards,
Milan
Views
Replies
Total Likes
Hello @tejashriw155148
You can try ToInt64(<number>) or ToInteger(<number>) depending on your use case.
Thanks,
Manoj
Views
Replies
Total Likes
Hello @_Manoj_Kumar_ ,
I tried ToInt64(<number>) but its showing Error converting datatype varchar to bigint
and for ToInteger(<number>) Conversion failed while converting the varchar value 'LG' to data type int
Do you have any other solution?
Thanks.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
I have code field with string data type and data as below:
02
98
LG
Tr
09
I want to compare only integer data with other field which contain integer data.
Thanks,
Views
Replies
Total Likes
Looking at your data below, you cant convert an alpha-based string to an integer. It has to be a numeric string only.
Hard to know what your actual data looks like with that small sample, but if you can assume that the non-numeric data will always start with an alpha character, you can do something like this:
Iif(Ascii(Left(@yourColumn,1)) < 58 and Ascii(Left(@yourColumn,1)) > 47, ToInteger(@yourColumn) , -1 )
This checks the first character to see if it is between 0 and 9. If it is then convert the value to an Integer. Otherwise put "-1" in the data.
"This checks the first character to see if it is between 0 and 9. If it is then convert the value to an Integer. Otherwise put "-1" in the data."
How to make this work for decimal values? Like 5.5 or 12.5?
Views
Replies
Total Likes
Hi @tejashriw155148 ,
you must do a split after query selection to get two branches (one for INT and another for STRING).
After that you may convert to preferred type in Enrichment nodes in needed (per branch.)
If your data have only two characters you may adapt query in split:
Generally, with provided data all input values are string. Then you need to separate it with split (above) and do conversion of numbers to integer.
Regards,
Milan
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies