Forum

Eliminate lasts cha...
 
Notifications
Clear all

Eliminate lasts characters from field by list loop criteria

2 Posts
2 Users
0 Reactions
152 Views
(@pepito)
Posts: 1
New Member
Topic starter
 

Hi guys, hope you're doing fine:

I have a table in Excel with many products, these products may have a color id by the end of the product code chain or not. 

I have another table with colors ( let's say a color list )

Sample.JPG

How can I do a loop to eliminate color id by row in Products based in color list? I have tried to go with last occurrence of delimitator '-' but my rows may have other numbers than color ids by the end 

Thank you very much in advanceCool

**List of colors in very short for sample purposes

 
Posted : 22/12/2020 12:21 pm
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Pepito,

No need for loops, you can do this by splitting the column then searching the resultant list for the colors.  Remove any matches, then recombine the split text back into the original Products text, minus the color code.

Regards

Phil

 
Posted : 23/12/2020 1:09 am
Share: