MQSeries.net :: View topic

artykito · Posted: Thu Jun 24, 2010 2:38 am Post subject:

Hi all I'm newbie in WMB, and I don't know if there is a function who allow you to find a character in a string or something like that. I am going to tell you my problem:

I have one field where I'll receive a lot of records with differents format (for this field) like these:
0000123456
0123456789
0000000-12
000-123456

I want to put them in an INTEGER variable (because I need to do a sum), and doing this, leading zeros are removed for 2 first cases, so there is no problem there.

But for the other 2 cases, if I try to put them directly into an INT variable, the flow fails. I think is because it expected the negative sign "-" before all these leading zeros.

I know I could do a function that find the negative sign and cut the string, but I have 2 loop nested and if I do that, I need another nested loop in order to go char per char finding the negative sign.

I tried to do a pattern with a CAST statement but I don't know how the pattern must be exactly and it fails.

I want to know if there is a way to store the negative fields with this format in an INT variable or do you know a function that could find the char "-" in a string? I know REPLACE but I don't want to remove it, because I need to know if the amount is negative or positive.

Thanks in advance for your help!