removing special chars in string

[#1]

Hi, I have data like this '290' and '9/454' and my output should be 290  and 9/454 INPUT '290' '9/454' OUTPUT 290 9/454 I tried using PURGE, KEEP CHAR functions but it seems not working. Pls let me know what is the right formula. Thanks,

[bumin]

can you provide your qvw?

[its_anandrjs]

use subfield function

[#4]

Pls find the same. I am using personal edition

Thanks,

[its_anandrjs]

Use this script

=mid(INPUT,2,len(INPUT)-2)

[its_anandrjs]

Use this script for new list box

=mid(Text,2,len(Text)-2)

[its_anandrjs]

Load your table like this

T:

LOAD * INLINE [

    Text

    "'290'"

    "'9/454'"

];

A:

LOAD

Text,

Mid(Text,2,len(Text)-2) as NewText // You get this new field

Resident T;

[anbu1984]

To remove single quotes try this

Replace(Input_Field,Chr(39),'')

[jagan]

Hi,

Try like this

LOAD * ,

Text(Replace(Text, chr(39), '')) as modified

INLINE [

    Text

    "'290'"

    "'9/454'"

];

Regards,

Jagan.

[#10]

Please find attachment.