What I would like is a tool to extract particular columns and merge customer address (in shipable format) from Ebay csv sales history file. I have sample files for both. The final file can be in excel or any format that be user friendly.
# There are many columns that come as default in ebay sales history file
# I need a selected few columns only ([url removed, login to view]) and remaining to be deleted
# Customer address from ebay is in format
Buyer Fullname|Buyer Address 1|Buyer Address 2|Buyer City|Buyer State|Buyer Zip|Buyer Country
# We want the format to be when exported
Buyer Address 1
Buyer Address 2
Buyer City Buyer State Buyer Zip
Note: If Buyer Address 2 is empty then it should not be included.
I will take suggestions on the procedure of import. If you need more clarification then email me.
Very simple project, it can be done in two days. I'll give you a program which will read the csv file, modify it, and write a new excel file. I will be able to send you an example program too, if you want. I'm really l Daha Fazla