topic SV:Delimiter ¦ ? in QlikView

Delimiter ¦ ?

Marc_Kaiser — Wed, 09 Mar 2011 13:48:00 GMT

Hi there

I'm trying to read a .txt file with Qlikview with the following delimiter: ¦

Reason why ¦ is used as delimiter: The data to be analyzed in Qlikview consists of free text. ¦ is the only value that is (most likely) not present in the source data.

Any idea how I could make use of ¦ as delimiter in Qlikview?

Thanks, Marc

SV:Delimiter ¦ ?

gandalfgray — Wed, 09 Mar 2011 13:56:38 GMT

use "delimiter is '|'

Example:

LOAD @1
FROM
file.txt
(txt, codepage is 1252, embedded labels, delimiter is '|', msq);

SV:Delimiter ¦ ?

Marc_Kaiser — Wed, 09 Mar 2011 16:19:25 GMT

I can't use delimiter is '|', as | is used in the free text (deliberately or not...)...

Delimiter ¦ ?

Anonymous — Wed, 09 Mar 2011 16:32:22 GMT

We use tilda as the delimiter as we find that that is the least used character. Would using tilda as a delimiter be an option for you?

Dinesh.

Delimiter ¦ ?

Marc_Kaiser — Wed, 09 Mar 2011 16:37:49 GMT

The IT department analyzed the data in detail. And apparently, ¦ is the only character that is not present in any of the text fields.