Uploaded BP Master Data Card with excess character such as "

[former_member660624]

Hello,

I successfully uploaded the BP master data for the new company I created. However, as I checked the BP Master Data form some of the Vendor Name I uploaded have an extra character (double quote) - "

for ex.:

In my template its only - ACETECH, INC.

and the uploaded data is - "ACETECH, INC."

Pls. help how to upload the BP w/o this extra character because it might affect in filtering our data.

Thanks,

Cathy

[Former Member · Accepted solution]

Hello Cathy,

To get rid of those characters, you would be better save your file as Tab Delimited Text format. Before DTW, using any text editor like Notepad to replace all those characters with nothing. Then, you are good.

Thanks,

Gordon

[former_member660624]

Hello,

Thank you for the advise. I always use the Tab delimited format as my source data type in importing data using DTW.

However, I did some experiment and tested one field CardName having an "," in the name (ex. AQUINO,ALLAN). There is no double quote in my template and after I uploaded my template the system puts the extra double quote character to the Card Name field. I therefore realized that the system detects the "," comma character in the field and put " double quote to it.

So I delete all the "," comma character in the CardName column.

Thanks again.

-cathy