How would you save the following attached XLS file in a text format so that the output does not contain double quotes around the values in column G for some rows?

How would you save the following attached XLS file in a text format so that the output does
not contain double quotes around the values in column G for some rows?

For example, here is the output for Column G for the 2 records in the XLS file:

"5,475M GILFORD, CT                 "
Wells Fargo  

Is there a way to save this column's values as:

5,475M GILFORD, CT                 (save the value in Column G without the double quotes)
Wells Fargo  



LIS.xls
zimmer9Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

StephenJRCommented:
Find and Replace?
0
Michael DyerSenior Systems Support AnalystCommented:
The quotes will come up anytime there is a comma in the field, this is keep the contents in the one field.  If you export without quotes, the comma will create two fields out of the data in Column G.

That said, if you want to do this, the simplest way is to do a post processing after the fact to remove the quotes.  You could open the file in Notepad and do a search and replace for ", replace with blank.  That will delete all Quotes.  

If you want it automated, you can use a simple program like Search'N'Replace by Tom Lundin.  This utility will search for any string and replace it within a file.  You can download a copy here:
http://www.cornerstonemag.com/sed/ under Console/command-line apps
0
TommySzalapskiCommented:
If you are saving it as a .txt then putting the quotes doesn't really make sense but they do it anyway. If you save the file as a space delimited .prn file, then it won't put the quotes in.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BadotzCommented:
Save the file as a TAB-delimited .CSV file - no quotes needed.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.