Hi, I'm trying to import data from a text file into Qlikview 10. The textfile uses the delimiter µ. I know how to import CSV's and other data sources, but this text file is different because it uses a different delimiter (µ). There's no way to change the file format to CSV (because the people at my project refuse to change the file format, since the file is updated daily). Is there a way you can import a 'µ' delimited text file into Qlikview 10 using the File Wizard? Thanks in advance
Hi Henric, your solutions seems to be working, but I'm having difficulties with the column names.
The first row of my text file contains my column names. If I use your solution, the column names are included in my data records. Any idea on how to filter out those column names by using your solution?
I'm not getting any errors with my small test file, but after a bit more investigation perhaps there is some difference in the use of ascii codes depending on location or user settings. My code for µ of 181 is from ISO 8859-1 Symbols (which is the default character set in most browsers according to W3Schools.com), although in the link I gave for theasciicode.com µ is designated as code 230.
I don't know why it works with the browser set and not the extended ascii set. Maybe my solution needs a bit more testing !
I also got the strange character at the end of the field names and at the end of the field values. As it turns out, my delimiter is 16 bits, not 8 bits. So the first 8 bits of the delimiter is taken off while the remaining 8 bits are the strange character which becomes a part of the field names and field values.
And since QlikView does not support utf16 or multiple characters as delimiter, I guess I am stuck with using subfield.