I have a colum of product names in which data is like this:
Nestle Nesquik Strawberry 300g
|
|
I have a colum of product names in which data is like this:
Nestle Nesquik Strawberry 300g
|
|
From what you describe, you should use the Cell Splitter and add the delimeter character. For your first example you use "space" for the second you use "(". That automatically saves the info in a new column, but it does split up the whole Product name. YOu can easily fix that and concatenate/merge again the split prodeuct name columns and you will have the weight left over too.
Is this something that helps you ?
It should, let me try. thanks :)
There's a problem. Every product have different number of spaces in them.For eg: "Nestle Nesquik Strawberry 300g)" has 3 spaces so the name will split into 4 parts but "Red Bull 250 ml" has total 2 spaces means 3 splits.
At the end which columns should be merged?
Try a regular expression:
\d+\s?(?:g|ml)
(would match digits followed by optional space, folled by either 'g' or 'ml').
-- Philipp
Which would help you only sofar as the stuff comes in g or ml.
There might be l, litre, gallon, kg, kilo, mg, milligram, sixpacks, bushels, tons, barrels, pallets, ....
First replacing ( with a space and ) with nothing, and then splitting on the last number using a regex makes more sense, but you will still have to check that it does what you think it should.
You might find out that there is for example one instance where it says something like "Product x 6 bottles of 500ml"
Textual information has a tendency to be funny like that.