topic Re: removing the comma in qlikview in QlikView

removing the comma in qlikview

Thu, 17 Mar 2016 10:43:16 GMT

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

Re: removing the comma in qlikview

sunny_talwar — Thu, 17 Mar 2016 10:47:09 GMT

May be this:

PurgeChar(FieldName, ',')

Re: removing the comma in qlikview

marcus_sommer — Thu, 17 Mar 2016 10:47:48 GMT

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

- Marcus

Re: removing the comma in qlikview

Chanty4u — Thu, 17 Mar 2016 10:48:46 GMT

use purgchar(name,',')

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

Re: removing the comma in qlikview

Thu, 17 Mar 2016 10:51:23 GMT

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

Re: removing the comma in qlikview

sunny_talwar — Thu, 17 Mar 2016 10:52:26 GMT

Try this:

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

Re: removing the comma in qlikview

Thu, 17 Mar 2016 11:17:45 GMT

give one Example

Re: removing the comma in qlikview

sunny_talwar — Thu, 17 Mar 2016 11:21:58 GMT

Here is one:

Table:

LOAD Field,

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

LOAD * Inline [

Field

'"nam , gpa , 11 "'

];

Re: removing the comma in qlikview

avinashelite — Thu, 17 Mar 2016 11:26:50 GMT

if you want to remove both the " &,

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

Re: removing the comma in qlikview

Kushal_Chawda — Thu, 17 Mar 2016 11:30:09 GMT

try this one also

keepchar(Fieldname,'abcdefghijklmnopqrstuvwxyz0123456789') as NewField

Re: removing the comma in qlikview

avinashelite — Fri, 18 Mar 2016 08:27:28 GMT

did your issue got resolved ??

Re: removing the comma in qlikview

Fri, 18 Mar 2016 09:36:33 GMT

yes i got it

Re: removing the comma in qlikview

Chanty4u — Fri, 18 Mar 2016 09:37:40 GMT

cool

close this thread as helpful and correct answers from above.

Re: removing the comma in qlikview

Chanty4u — Fri, 18 Mar 2016 10:10:59 GMT

hi,

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: removing the comma in qlikview

avinashelite — Fri, 18 Mar 2016 10:42:43 GMT

please mark the correct and helpful answers so that it will be helpful for others who are having similar question