Link to home
Start Free TrialLog in
Avatar of mbroad02
mbroad02Flag for United States of America

asked on

VBS How to remove double quotes from text file

I Have a text file which contains several fields which have " around each field.  I would like to be able to remove the quotes.  Sample:  "field1" "field2"  etc.

A short VBS script should take care of it.
Thanks.
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Yes, a short script could handle it, but be advised that that can introduce new problems.

For example, in a delimited text file, any field entries that themselves contain the delimiter character will typically have to be wrapped in a text qualifier (which is usually double quote).

You should post a smallish sample file here.
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mbroad02

ASKER

Works great!!
Thanks