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.
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.
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.