String to Integer

[kumar66]

Hi All,


I need to convert a string to integer and to compare the converted integer value with a integer .

If the values are same i need to update the status file as 'Y'Else 'N'

i am using the follwoing:

If DSLink71.DETAILROWCOUNT= AsInteger(StringToDecimal(Trim(DSLink71.VALUE,0,'L'))) Then 'Y' Else 'N'

The value of DSLink71.DETAILROWCOUNT is 1000 (integer) and the vlaue of DSLink71.VALUE is 000001000 (String).

The output of the file is 'N'. Please help me in solve this.

Thanks & Regards,
Kumar66

[karthikdsexchange]

Try with the following code.
It works fine for me.
If DSLink3.count = AsInteger(StringToDecimal(TrimLeadingTrailing(DSLink3.value))) Then "Y" Else "N"

[ray.wurlod]

Alternately do the test first (using IsValid() function) and only attempt the conversion if the validity test succeeds.

[srinivas.g]

use this stmt in stage varaible

If (DSLink4.number = AsInteger(StringToDecimal(DSLink4.number1)))Then 'Y' Else 'N'

[Marley777]

Hi, in this thread of post I noticed the formula

If DSLink71.DETAILROWCOUNT= AsInteger(StringToDecimal(Trim(DSLink71.VALUE,0,'L'))) Then 'Y' Else 'N'

Why is StringToDecimal and AsInteger needed? How do they work together when converting a string to an integer.