issue opening txt file in qlikview

[#1]

I have a txt file and trying to open it in Qlikview. Delimiting the file using tab but unfortunately one of the field contains text information and also it contains Quotes, semicolon and tab within it. So when i use the TAB as delimiter value is moved to other columns. could anyone help me to overcome this issue.

Regards,

Narayanan.

[nagaiank]

Can you try some other delimiter such as pipe (|) or tilde (~) ?

[#3]

Hi Nagaian,

I tried using pipe and tilde but then it consider all the values in one column. But I wanted it as an individual column.

Thanks and Regards,

Narayanan C P

GA - Hewlett-Packard Company

Marketing BI Team

narayanan.cp@hp.com<mailto:narayanan.cp@hp.com> / Email

Little Wood Block- 8th to 12th Floor

TRIL Info Park, Ramanujan IT SEZ Park

Rajiv Gandhi Salai- OMR Road Taramani- Chennai

Please consider the environment before printing this email.

This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are hereby notified that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake, and delete this material from any computer. Hewlett-Packard accepts no liability for errors or omissions in the contents of this message, which arise as a result of e-mail transmission.

[nagaiank]

Please post a few lines of your text data file having problem characters.

[DavidFoster1]

You will need to filter out those records that do not conform to the file standard (i.e. by having more field separators than allowed).

I would suggest loading the whole record into a single field then calculating the number of tabs in the data and storing only those records with the correct number of tabs into an intermediate QVD ready for processing while you pass the other data back for checking.