Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want remove pre-fix of charecter value in my list box,
like i have data
G952211223
G9522103
G95208434556
G95208389
G952082234
G952081
could you please help on this.
Best Regards
Munna
If you're just removing "G", I would use purgechar for simplicity.
Syntax:
PurgeChar(<fieldname>, '[chars to remove]')
Your example: purgechar(G9522103,'G')
=Right(Data, Len(Data)-1)
Or,
=Mid(Data,2)
Mid(Fld,4)
Hi,
Try
=keepchar('G952082234','0123456789')
Regards
ASHFAQ
Have you tried KeepChar(), if you have to remove 'G'
keepchar ( 'C3g43','0123456789' ) returns '343'
Hi Tresesco,
i don't want to remove other values see below data, wherever started with 'G' Those values remove pre-fix of that particular character(G)...Remaining values should be same.
G952211223 ,
F98652,
S887643,
FALSE,
TRUE,
G9522103,
G95208434556 ,
G95208389 ,
G952082234,
G952081
Advance Thanks
Munna
If you're just removing "G", I would use purgechar for simplicity.
Syntax:
PurgeChar(<fieldname>, '[chars to remove]')
Your example: purgechar(G9522103,'G')
Purgechar removes all occurrences, not just prefix
=purgechar('G9522103G','G')
Mid(Name,If(Name Like 'G*',2,1))
Or
If(Field Like 'G*',Mid(Field,2),Field)