This is an annoying problem. I have to import data into a program as a .txt file. The program has a bug and does not recognize quotes that protect values with commas from real quotes within values. So any value with a comma comes in with quotes and any value with quotes goes in with double quotes. They have acknowledged that this is a bug in their import utility and it may or may not get fixed in the next version
So in the meantime, I have to import several files containing information that may or may not have quotes and or commas that would cause "tricky" quotes. Is there a VB script I can run on the .txt file or any other ideas you may have for removing quotes that have soley been put in to preserve values containing commas? Here is an example of my data:
Primary Key Description
100 Man with dog, Mt. Tamalpais in background
101 "Titanic"
102 Originial, "Man with head dress, Inuit"
In the .txt file it appears (as it should)
Primary Key Description
100 "Man with dog, Mt. Tamalpais in background
101 ""Titanic""
102 "Original, ""Man with head dress, Inuit"""
So basically, I want to be able to save this file as a .txt file without the embedded delimited quotes but keep the original quotes originally in the values.
Any help or ideas would be greatly appreciated.
Thanks,
Chris
Bookmarks