topic CSV Delimiter not found in QlikView

CSV Delimiter not found

Fri, 02 Sep 2011 13:32:16 GMT

I'm trying to load in a batch of files that use the character "þ" as the delimiter, I'm having difficulties as the import wizard does not have this character available in the list of custom delimiters.

I've tried manually editing the script and setting "delimiter is ''þ" but this just throws up an error message saying that it can't find any of the fields.

I know that there is a workaround to load each file in and then use subfield to extract each column but this would be very time consuming with the number of files I have (that all have different columns). I see that SQL Server is able to cope with this delimeter character but I don't really want to have to load all of these files into SQL to be able to then load them into QlikView

Does anyone have any ideas of how I might be able to load these files in directly into QlikView?

Thanks

Dave

CSV Delimiter not found

harleen_singh — Sat, 03 Sep 2011 09:20:38 GMT

dave,

what is this character is?

is it P for puppy? or something else or symbol?

thanks
Lavi

CSV Delimiter not found

Mon, 05 Sep 2011 08:47:27 GMT

Hi Lavi

No it is the character symbol ''þ", which I think is an old english character http://en.wikipedia.org/wiki/Thorn_%28letter%29.

It's ASCII character code is 231 if that helps.

Thanks

Dave

CSV Delimiter not found

Mon, 12 Sep 2011 16:58:04 GMT

Hi,

I had a similar problem and the found the following resolution. Columns need to be load as column numbers and the delimeter is \xFE for 'þ'

e.g.

LOAD

@1,

@2,

FROM

[..\Downloads\test.txt]

(txt, codepage is 1252, no labels, delimiter is \xFE, msq, header is 1 lines);

CSV Delimiter not found

Thu, 17 Nov 2011 14:40:12 GMT

I tried your suggestion and it works great!

Thanks

Dave