Load from a textfile with a 2 character delimiter?

[m_woolf]

I need to load a textfile into QlikView. The delimiter is 2 characters ":~". The customer insists that there is no single character delimiter that will work.

Is this possible in qlikView?

[rwunderlich]

I don't think you can do it with the 'delimiter is parm', but you can do it with subfield.

LOAD
subfield(X, ':~', 1) AS F1,
subfield(X, ':~', 2) AS F2
;
LOAD
@1 as X
FROM
[myfile,txt]
(txt, codepage is 1252, no labels, header is 1 line);

The "header is 1 line" is to skip over a header line if you have one.

[#3]

Hi,

If they say that there is no single-char separator , they migth have a point that all usual separators are used inside field values.

But if you find a non-alphanumeric character ,say with ASCII code bellow 31 decimal (BEL, Vertical space etc), that would be usable.

From command line , with command "tr" one can replace combination :~ with BEL . Of course, it will make the computer BEEP BEEP a lot 🙂

cat file.txt | tr :~ \041

You can get the Windows version of command line tools from GnuWin32

-Alex