Correct the character format

[sureshbn21]

Hi,I am having Customer name listbox.Here customer name field values are getting *,? symbols. how to transformation and symbols (replace) or removing. can you please help me on this.PFB.

Thanks,

BNSuresh.

[MayilVahanan]

HI @sureshbn21 

Try with PurgeChar() or KeepChar() functon

In script, Like 

PurgeChar(Customer , '*?') as Customer 

or

KeepChar(Customer , 'abcdefghijklmnopqrstuvwxyz ') as Customer

[sureshbn21]

Hi all,
I have already write the above expersion in list box properties but Before
the loading regarding this how to write the script.
Thanks,
Bnsuresh

[MayilVahanan]

Hi 

Try like this,

Load PurgeChar(Customer , '*?') as Customer , yourfields from yoursource;