Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
num(num#([Acount Number]))
num(num#([Acount Number]))
Hi,
trim is for blanks only. If the account number has no alpha characters you can just use:
Num([Account Number])
- Ralf
I am not sure if you have noticed, you have an extra closing bracket
replace(ltrim(replace([Account Number],'0',' ')),' ','0')
However, replace is dangerous! Because it's not just replacing leading zeros!!
I have a wildmatch before this.That is the extra closing bracket here.
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
..several typos here.
Hi aptha0115,
Hi try this function,
= right(098765432,8)
Hope it will help you.
- Regards,
Vishal Waghole