Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
alejortizp
Contributor III
Contributor III

How to remove the text qualifier

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);

Labels (1)
1 Solution

Accepted Solutions
andrey_krylov
Specialist
Specialist

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);

View solution in original post

2 Replies
andrey_krylov
Specialist
Specialist

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
Contributor III
Contributor III
Author

Hi Andrey,

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

Calificador de texto.PNG

Prueba.PNG