Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I really don' t know where to look at anymore.
I have a series of txt files (monthly orders line) that are loading fine.
This one instead, is loading only ~30k lines out of a total of ~147k lines.
Excel loads all the line, Access loads all the lines, QV not.
I really don't know what is wrong. I also checked in Excel if there were duplicated rows, but I could find only 200, so a negligible amount.
I know it is a long shot, but do you have any idea why this could possibly happen??
thank you so much!
Consider a comma separated file. If one of the fields contains a comma as data, the field is surrounded by quotes to escape the comma and keep it from being treated as delimiter. The MSQ parameter tells QV to look for this kind of quoting -- and to remove the quotes from the field.
-Rob
Thanks for your reply.
So, referring to your example above, if I am to REMOVE the MSQ parameter, I would get a field value surrounded by quotes in my final extracted data?
Yes, but only if the field was originally written with quotes.
-Rob