Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Sasidhar1
Contributor
Contributor

Pipeline Delimiter between data.

My data is having pipeline between data with double quotes.

and delimiter is also pipeline.

I am trying of using only tFileInputDelimiter > tFileOutputDelimiter 0683p000009M9rk.pngINPUT- containing Pipeline between data0683p000009M9fC.pngOUTPUT- last field is missing for the same row.In output the last field is missing for the row containing pipeline between data.

 

I tried CSV options (escape char & Text Enclosure) in many ways in both the components but i failed.

 

Requirement -

1) I want the output to be "same" as in input (Don't want output with all the fields having double quotes or in any other way). and if possible the pipeline between the data having double quotes should be removed.  0683p000009M9lY.pngAll fileds having Double Quotes- Got some solutions here for getting this kind of output. but I dont want double quotes for all.

 

2) Is that possible to do by using only tFileInputDelimiter and tFileOutputDelimiter ?

3) Better if no other component is used.

 

so,can anyone please help me with this...

 

 

Labels (3)