How to remove quotes ["] from a specific field in a.txt file 1

[awaria]

I have a integration utility that takes a tab delimited .txt file and imports the records (purchase Order line item data) into our ERP.

Issue is, the one field [Item Description], many of the records have quotes ["} in the description and
the import utility is fails on these records.

Is there a way to open the file, remove the quotes from the item Description field, and then save the file without the quotes,
then run the import utility?

I am not a programmer, so please take that into consideration when providing suggestions.

Thank you,

zaw

 

[zelgar]

A non-VBA way is to open the file in Word or other word processor, Find/Replace the " and save-as a text file.

 

[awaria]

This import process is automated so I am looking for a solution that I can automate.

Thanks for the reply.

zaw

 

[jges]

Do you want to remove all quotes from the file, or only those in this specific field?

Can you provide a sample of what this data looks like (fictional data is OK as long as the format it is in reflects the real data format).

 

[awaria]

File is attached. The issue has been discovered in the item description field, however, it could be a problem in any field.

Appreciate your help.

zaw

 

[awaria]

Not sure if I did the attachment correctly,I will try again.




 

[guitarzan]

You have to upload your file to someplace on the web and enter the URL in the "Attachment" field here. You cannot paste a local file...

Do you just want to delete all double-quotes?

Const ForReading = 1, ForWriting = 2
Set fso = CreateObject("Scripting.FileSystemObject")
sDataFile = "C:\trashandtemp\myfile.txt"
Set f = fso.OpenTextFile(sDataFile, ForReading)
sData = Replace(f.ReadAll, """", "")
Set f = fso.OpenTextFile(sDataFile, ForWriting, True)
f.Write sData

 

[jges]

You have to upload your file to someplace on the web and enter the URL in the "Attachment" field here. You cannot paste a local file...

Or just copy and paste a few lines into the reply box. We just need some representative data to see what you are dealing with and make appropriate suggestions.

 

[awaria]

yes, on deleting all double quotes.

There are 21 fields.
PONumber PODate POType VendorID Vendname ItemID ItemDescr Qty Price Freight Distribution SiteID UofM RequestorID Note Company Campus Address1 City State Zipcode

All will not have any quotes, other than, [Item description] and [Notes].

zaw