PDA

View Full Version : Help needed to edit CSV files



savan28
06-09-2018, 06:24 PM
Hello everyone,
I have started a new eCommerce website and need some help to edit the csv.

Basically I get a new updated CSV file every 2 days with edits in more than 5000 products. I need a quick way to edit the CSV and update the products in the website.

To do this firstly, I need to remove the product code from the name of the cell. The product name is in the following format
8694 3 Piece Set Of Wall Paintings Without Glass,

I need to remove the first set of numbers and to be written as 3 Piece Set Of Wall Paintings Without Glass.
And secondly to optimise the site and for SEO reasons, i need to remove certain characters from the description like, the, is, and and so on,

For example, from the following sentence I need to remove the, are, very and in

The towers are very tall in the city. and the output is tower, tall, city.

Thanks for your help in advance, :)

mancubus
06-10-2018, 11:35 PM
welcome to the forum.

can you post your workbook?
(#2 in my signature)

savan28
06-11-2018, 06:43 AM
I have uploaded a example of how the data is

mancubus
06-11-2018, 07:53 AM
sample in A2
is it "5008Blue and Sea Green Straight Suit" or "5008 Blue and Sea Green Straight Suit"?
(no space / 1 space between 5008 and Blue)