trim function is not working.Somebody please help me.

[#1]

I have an account number like 098765432

I want to trim the 0 and want to show 98765432.

I tried , ltrim([Account Number],0)

and also tried         

replace(ltrim(replace([Account Number],'0',' ')),' ','0'))

It is not working.

Which function can I use ?Can u please help me

[preminqlik · Accepted solution]

num(num#([Acount Number]))

[rbecher]

Hi,

trim is for blanks only. If the account number has no alpha characters you can just use:

Num([Account Number])

- Ralf

[#4]

I am not sure if you have noticed, you have an extra closing bracket

replace(ltrim(replace([Account Number],'0',' ')),' ','0')

[rbecher]

However, replace is dangerous! Because it's not just replacing leading zeros!!

[#6]

I have a wildmatch before this.That is the extra closing bracket here.

[#7]

This is not working.Is there any other way ?

Here is my actual statement

  if(wildmatch([ITEM ID],'L_P_*','BS_*') and if(wildmatch([Account Number],'0*'),num(num#t([Account Number],9))),
  [Account Number]) as InSite_Acct

[rbecher]

..several typos here.

[VishalWaghole]

Hi aptha0115,

Hi try this function,

= right(098765432,8)

Hope it will help you.

- Regards,

Vishal Waghole