Extracting the data after zero

saj · Post by **saj** » Mon Dec 24, 2012 5:30 am

Hi All ,

I have a requirment to extract the data that comes after 0 .

ex: EM0000000000000592176

Need to fetch 592176

The number of zeros may vary

ex:EM00789892

Output :789892

When we try with Field(Arg1,"0",1) this will provide EM .
Please let me know how to get data after 0

ArndW · Post by **ArndW** » Mon Dec 24, 2012 8:35 am

Assuming that the string will always have at least one zero:

Code: Select all

Trim(Field(Arg1,'0',2,999),'0','L')

chulett · Post by **chulett** » Mon Dec 24, 2012 9:27 am

Is the target column a string?

Hmmm... I think the leading "EM" is going to negate your approach, Arnd.

I was thinking you could find the first '0' starting from the back and then substring from there but zeroes in the number itself would hork that up. Seems you might need to find the first zero, then start from there to find the first non-zero and take from there to the end.

Or remove all of the non-numerics (the 'double convert' comes to mind) and then strip the leading zeroes. I'm sure there are other ways to skin this cat.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 24, 2012 1:55 pm

Arnd's approach is totally valid.

This is a server job, so data type conversion will be automatic.

Another solution is DIGITS(InLink.TheString) + 0 (performing any arithmetic removes leading zeroes).

chulett · Post by **chulett** » Mon Dec 24, 2012 4:00 pm

ray.wurlod wrote:Arnd's approach is totally valid.

Ah, true. Was reading it kind of... bass ackwards. Just to amend it slightly, I would say "Assuming that the string will always have at least one leading zero".