Additional characters (" ") found in items/ bp nameswhen uploading thru DTW

[Former Member]

Hi Experts,

I usually encounter items names or bp names with double quotations ("xx ") after data is uploaded thru DTW. This will limit filtering of names during browsing.

Is there a way to avoid this additional special character? As of now, since many items/bp were already in the system, is there an sql query statement to delete the quote (") before the item & bp names?

Thanks.

[Former Member]

Hi, have you used tab delimited format for the import? All you need to do is run an update on the BP Names, but replace all " characters in the import file. Open the file, CTRL+H, and replace all " characters with nothing. Then run an Update Existing Object type import.