How to Remove a Single quote in a String

[#1]

Hi All,

I have a requirement to do a Wildmatch on the string 'Reg'is' ,but as the string has a single quote after the letter g,its not taking the field value,have used Purgechar() function but unable to remove the single quote.

Please help me out on the function to be used.

Thanks,

Neha

[maxgro]

this seems to work

load replace(col1, chr(39), '');

LOAD * INLINE [

col1Reg'is

aa''aa''aa

];

[rustyfishbones]

Try REPLACE

REPLACE(YourField,CHR(39),'') as NewField

See the attached file

[#4]

While loading the data from source, remove the single quote with Replace function.

LOAD Replace(FieldName , chr(39) ,'') AS FieldName

.

.

.

;

SELECT * FROM TABLENAME ;

[#5]

Hey Neha,

Use

PurgeChar(Name,Chr(39)) as NewVAlue.

Here Chr(39) will give you '

Attached is a sample

Thanks

AJ

[#6]

Instead of Pulling it as a new value,can't we do it on the front end,cause I need to remove the single quote only from this single String value 'Reg'is'

Thanks,

Neha

[santharubban]

YOU CAN TRY THIS

load PurgeChar(col1, '');

LOAD * INLINE [

col1Reg'is

aa'aa'aa

];

[maxgro]

in listbox use an expression

=replace(col1, chr(39), '')

in chart a calculated dimension (=replace(col1, chr(39), ''))

[#9 · Accepted solution]

In that case you can do something like if(Name='Reg'&Chr(39)&'is','Regis',Name)

You can do this in a list box expression or in the backend. This will replace

Reg'is with Regis

[rustyfishbones]

Yes you can use the same as a List Box Expression

REPLACE(YourField,CHR(39),'')