Hi guys
There is a task I need to accomplish and not sure how can I do it:
I have an CSV like so:
;BrandType;column1;column2;
;//AE/AS;X;XX;
;//M/S/T;X;XX;
Now I need to copy and split those rows by the value of a BrandType text column and “/”
;BrandType;column1;column2;
;//AE;X;XX;
;/AS;X;XX;
;//M;X;XX;
;/S;X;XX;
;T;X;XX;
I’ve tried a number of ways but can’t figure it out. Any assistance at all much appreciated.
Can you explain that are the rules behind the slashes? When do you have a double slash and when do you have a single slash? Is that the BrandType always starts with a double slash?
And also, why does the last time ;T;X;XX; not have a slash like ;/T;X;XX;?
yesx, thank you
double // is only the first one, later single “/”
Maybe my mistake, X is a symbol for other data, not containing any special characters
My last question was not about the X. I understood that the X was other column, other data. The question was more about why did the brandtype T not start with a slash, like /S did in the previous row. I think that was a mistake.
In any case, I am assuming that it was supposed to be /T.
I put something together for you, that looks like this: