to trim 1th char

sathishmca · Post by **sathishmca** » Mon Sep 29, 2008 12:29 am

Hi to all,

I have a data with 7 characters.i need to remove 1st character if it is 0.

Ex:

0123456 ---> 123456
0012345 ---> 012345

Could you please suggest me some tips?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 29, 2008 12:38 am

Code: Select all

If Left(InLink.TheString,1) = "0" Then Right(InLink.TheString,6) Else InLink.TheString

What is to happen if the first character is non-zero? You did not include this in your specification.

sathishmca · Post by **sathishmca** » Mon Sep 29, 2008 12:44 am

ray.wurlod wrote:
Code: Select all
If Left(InLink.TheString,1) = "0" Then Right(InLink.TheString,6) Else InLink.TheString
What is to happen if the first character is non-zero? You did not includ ...

Thaks ray.wurlod..What you have written is correct.If its non zero means can move same as the source.

sathishmca · Post by **sathishmca** » Mon Sep 29, 2008 12:53 am

Hi ray,

Any other functions to achive this quit easier than what u gave before?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 29, 2008 2:38 am

Not from me.

You want to write your own function then go ahead, it will encapsulate the expression logic I gave.

Whether or not U has any other ideas remains to be seen: U does not log in all that often.

DSXchange

to trim 1th char

to trim 1th char

Thanks

Re: Thanks