Delimiter ¦ ?

[Marc_Kaiser]

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

[gandalfgray]

use "delimiter is '|'

Example:

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

[Marc_Kaiser]

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

[Anonymous]

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.

[Marc_Kaiser]

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