First of all I have to say that I’m amazed about this group and the level of competence you guys have.
I just got the time to work on this project and here what I have found.
@astrosofista said in Replacing word between commas not included in a list of words:
Hi @fred-zept
Please, try the following regex, based in the expressions provided yesterday:
Search: ^((([^,]*),){22}(?!bianco|nero|rosso|giallo|blu|verde|arancione|grigio|viola|marrone|mimetico|beige|bordeaux))([^,]+)
Replace: ${1}altri
Have fun!
Thanks, this seems to work on most of the lines. In some other line seems to change the value on the 21st comma rather than 22nd.
It works on the first line, although on the second line change the word Topman, which is the brand and not the colour, rather than Pietra
https://www.awin1.com/pclick.php?p=27397554539&a=357849&m=9606,"adidas Originals - Smanicato con 3 strisce nero",27397554539,9963546,https://images.asos-media.com/products/adidas-originals-smanicato-con-3-strisce-nero/20192202-1-black?$XXL$,"Gilet di Adidas Originals Il prossimo dei tuoi prodotti salvati Modello imbottito Collo a imbuto Logo Adidas Chiusura con zip Tasche laterali 3 strisce laterali Vestibilità classica Veste perfettamente la taglia indicata","Uomo > Giacche e cappotti > Gilet",74.95,"Asos.com IT",9606,"Men's Outerwear",171,https://images2.productserve.com/?w=200&h=200&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.asos-media.com%2Fproducts%2Fadidas-originals-smanicato-con-3-strisce-nero%2F20192202-1-black%3F%24XXL%24&feedId=36675&k=1f40920a1b687eb73ed4ce4da992ec98bfaf0279,EUR,,0.00,https://www.asos.com/it/adidas-originals/adidas-originals-smanicato-con-3-strisce-nero/prd/20192202?browseCountry=IT&browseCurrency=EUR,,,EUR74.95,36675,"adidas Originals",Porpora,,25479,,,,,"74.95 €","0.00 €",,,
https://www.awin1.com/pclick.php?p=27250398127&a=357849&m=9606,"Topman - Piumino smanicato riciclato color pietra",27250398127,10155883,https://images.asos-media.com/products/topman-piumino-smanicato-riciclato-color-pietra/20571492-1-stone?$XXL$,"Giacca di Topman Non oggi, per quando fa freddo Collo a imbuto Senza maniche Chiusura con zip Tasca con zip sul petto Tasche laterali Vestibilità classica Veste perfettamente la taglia indicata","Uomo > Giacche e Cappotti > Gilet",55.99,"Asos.com IT",9606,"Men's Outerwear",171,https://images2.productserve.com/?w=200&h=200&bg=white&trim=5&t=letterbox&url=ssl%3Aimages.asos-media.com%2Fproducts%2Ftopman-piumino-smanicato-riciclato-color-pietra%2F20571492-1-stone%3F%24XXL%24&feedId=36675&k=2bd6e17c0634ad74c710a431ab947d5e483b4d4c,EUR,,0.00,https://www.asos.com/it/topman/topman-piumino-smanicato-riciclato-color-pietra/prd/20571492?browseCountry=IT&browseCurrency=EUR,,,EUR55.99,36675,Topman,Pietra,,25487,,,,,"55.99 €","0.00 €",,,
@guy038 your solution seems to work perfectly.
@Terry-R I guess I’m in the middle of the good ones since I live in in Europe. And you are a good one for sure Terry, I’m still using your way to delete near duplicate lines.
Thanks again.
Thanks everyone for your help!