Remove the character Pre-fix Values

[Srinivas]

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

[tresesco]

=Right(Data, Len(Data)-1)

Or,

=Mid(Data,2)

[anbu1984]

Mid(Fld,4)

[ashfaq_haseeb]

Hi,

Try

=keepchar('G952082234','0123456789')

Regards

ASHFAQ

[israrkhan]

Have you tried KeepChar(), if you have to remove 'G'

keepchar ( 'C3g43','0123456789' ) returns '343'

[Srinivas]

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

[jcampbell474 · Accepted solution]

If you're just removing "G", I would use purgechar for simplicity. 

Syntax:

PurgeChar(<fieldname>, '[chars to remove]')

Your example: purgechar(G9522103,'G')

[anbu1984]

Purgechar removes all occurrences, not just prefix

=purgechar('G9522103G','G')

[anbu1984]

Mid(Name,If(Name Like 'G*',2,1))

Or

If(Field Like 'G*',Mid(Field,2),Field)