How to remove the text qualifier

[alejortizp]

Hi good day,

I am loading a file that comes with a text qualifier in "and I want to be able to remove that character for the correct reading of the variables, which command I should use from the load to be able to remove that character.

autorizacionesanual:

LOAD

          *

FROM [lib://fuente_salud (integrasavia_svcqlik)/reporte_prueba.csv]

(txt, codepage is 28591, embedded labels, delimiter is ',', no quotes, no eof);

[andrey_krylov · Accepted solution]

Hi Alejandro, try this

PurgeChar('Some sting', '"') 

autorizacionesanual:

LOAD PurgeChar(AСO_AUTORIZACION, '"') as AСO_AUTORIZACION

FROM [lib://fuente_salud (integrasavia_svcqlik)/reporte_prueba.csv]

(txt, codepage is 28591, embedded labels, delimiter is ',', no quotes, no eof);

[alejortizp]

Hi Andrey,

Its correct but i want a argument from the load for read my records without ' " ', like exist in excel: