DTW updating items with quotation marks

[Former Member]

Hi Experts,

I am updating the item master data (OITM) using dtw. but i have some item codes with quotation marks (ex. ItemABC10"x20"), i am having an issue updating this kind of itemcodes, because the template automatically adds some quotation marks in the beginning and end of each item code ( ex. "ItemABC10"x20"")  that is why, dtw won't update this item code and instead would create a new one (when i choose to add and update). Is there a way to solve this issue?

Thanks in advance,

Malu

[kothandaraman_nagarajan]

Hi,

Please check thread

Thanks & Regards,

Nagarajan

[Former Member]

Hi Malu,

Try this:

1.Save as text tab delimited.

2. Remove the " in the text file then save.

     -The only problem that I can see is that you will need to do this manually since you have 10"x20" and you cannot use the replace all function in notepad.

Hope this helps.

Regards,
Darius