This'll be a bit complicated I think. Hopefully the geniuses here can advise
I've got thousands of strings. Here's one example:
Computer-H000097050-LEXMARK INTERNATIONAL INC-Outside Processing [Shipping fee]-Nov
Hyphens separate what should be columns for the most part but not always.
So Computer should be a category, that belongs in one column.
H000097050-LEXMARK INTERNATIONAL INC should be the Vendor Name, that belongs in the next column. As you can see that has a hyphen in the name so that complicates things.
Outside Processing [Shipping fee] is the Desc, which goes in another column. In this case that looks clean enough but in some cases the Desc has a bloody hyphen, which kinda sucks.
And then there's the month which is self-explanatory.
So I think to start I'd like to pull out the Category and Month from this, and be left with a string of Vendor and Desc, from which I can try to figure things out further.
Can someone help with this please? I'd appreciate it.
I've got thousands of strings. Here's one example:
Computer-H000097050-LEXMARK INTERNATIONAL INC-Outside Processing [Shipping fee]-Nov
Hyphens separate what should be columns for the most part but not always.
So Computer should be a category, that belongs in one column.
H000097050-LEXMARK INTERNATIONAL INC should be the Vendor Name, that belongs in the next column. As you can see that has a hyphen in the name so that complicates things.
Outside Processing [Shipping fee] is the Desc, which goes in another column. In this case that looks clean enough but in some cases the Desc has a bloody hyphen, which kinda sucks.
And then there's the month which is self-explanatory.
So I think to start I'd like to pull out the Category and Month from this, and be left with a string of Vendor and Desc, from which I can try to figure things out further.
Can someone help with this please? I'd appreciate it.