Log In
Register
Home
Eliminate lasts characters from field by list loop criteria
pepito pepito
New Member
Members
Forum Posts: 1
Member Since:
December 22, 2020
December 22, 2020
Offline1
December 22, 2020 - 2:21 am
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 )
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 advance
**List of colors in very short for sample purposes
See Answer
Philip Treacy
Admin
Forum Posts: 1549
Member Since:
October 5, 2010
October 5, 2010
Offline2
December 22, 2020 - 3:09 pm
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
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Lakisha Hall, QSolutions Group
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Lisa Myers
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594
Member Stats:
Guest Posters: 49
Members: 32818
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —