String to Integer

[subbuvp]

Hi All,
The input is string ( the format is in within double quote "2006") and i need an output in integer( example: 2006).
How can we do it in Datastage Designer?
Please do help me to solve this....


Thanks and regards
Subbu

[DSGuru79]

Hi All,
The input is string ( the format is in within double quote "2006") and i need an output in integer( example: 2006).
How can we do it in Datastage Designer?
Please do help me to solve this....


Thanks and regards
Subbu

Use basic functions, (check in transformer) to strip the quotes and then use stringtoDecimal fucntion

[umamahes]

First use Trim function to remove leading and trailing spaces and then apply String To Decimal function.

[BalageBaju]

Subbu,

What is your source, If it is Sequential file set the Field Default-->Quote as Double. Then Datastage only takes the data only within quotes(2006).

To convert the string in to Integer, you can use the function "AsInteger".
This function treats the given input as integer.

Hope this will help you.