char to integer32

ds_is_fun · Post by **ds_is_fun** » Sun Jul 24, 2005 9:40 am

Char to numeric conversion. Any suggestions?

kumar_s · Post by **kumar_s** » Sun Jul 24, 2005 10:15 am

I could not understand your need clearly.....
it seems you need to conver char (source) to int (target) am i right.
int32 is againg the integer right.But it is just a long one.
so if the source is 0000 then it suppose to be reflected as 0 in the target right.

regards
deepak

ds_is_fun · Post by **ds_is_fun** » Sun Jul 24, 2005 5:20 pm

What could be done to avoid this transformation?
thanks

chulett · Post by **chulett** » Sun Jul 24, 2005 7:54 pm

Umm... nothing.

There's nothing wrong with what's happening. Any number of character zeroes sent to an integer field will become a numeric zero.

About the only way to 'avoid this transformation' would be to redefine your target field to be character as well.

ray.wurlod · Post by **ray.wurlod** » Sun Jul 24, 2005 10:00 pm

ds_is_fun wrote:Char to numeric conversion. Any suggestions?

int32_from_string in Modify stage. Just be very sure that every value can accurately be converted.

goosarikiran · Post by **goosarikiran** » Wed Jul 27, 2005 12:10 am

ds_is_fun wrote:Char to numeric conversion. Any suggestions?

char is left justified and int is right justified.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 27, 2005 1:23 am

So?

Trim trailing white space if that's necessary.

"12345" can be converted to an integer whether it's left- or right-justified.
Trim("12345 ") can also be happily converted to an integer.

DSXchange

char to integer32

char to integer32

Re: char to integer32

Re: char to integer32