DTW - quotation marks around the data

[Former Member]

I am using DTW to import master data. I am using a tab delimeted file, but DTW is putting quotation marks around any data that has a comma in the text - BP names, Item Descriptions, etc. Prior versions of DTW did not do this. Does anyone know a work-around for this? Thanks!

[Former Member]

Thanks Gordon. I did find the solution - the only issue with replacing the quotes through text editor is that some of the quotes are valid ~ makes for some fun!

[Former Member]

Have you found your solution? You just need to reopen the text file in a text editor like Notepad and replace all " with blank.

Thanks,

Gordon

[Former Member]

Sorry - I found this to be an Excel issue.