removing the comma in qlikview

[#1]

Hi All ,

i Have  an text format Like the  "nam , gpa , 11 "

i want to Remove the commas  convert that text format into normal form Like            nam pga 11 

[sunny_talwar]

May be this:

PurgeChar(FieldName, ',')

[marcus_sommer]

Try: Replace(Field, ', ', '')

- Marcus

[Chanty4u]

use purgchar(name,',')

or

   Subfield( Mid( MyField, Len(MyField) ), ',' )

[#5]

I want to Remove the Double Quotes also  ... this one   " " 

[sunny_talwar]

Try this:

PurgeChar(FieldName, Chr(34) & ',')

[#7]

give one Example     

[sunny_talwar]

Here is one:

Table:

LOAD Field,

  PurgeChar(Field, Chr(34)&',') as NewField;

LOAD * Inline [

Field

'"nam , gpa , 11 "'

];

[avinashelite]

if you want to remove both the " &,

purgechar(' "nam , gpa , 11" ','," ')

[Kushal_Chawda]

try this one also

keepchar(Fieldname,'abcdefghijklmnopqrstuvwxyz0123456789') as NewField