Question 1: regex pattern that will replace multiple consecutive spaces with a single space
Question 2: regex that will ignore parentheses but NOT ignore everything inside the parentheses.
so it would see: Lil Wayne (feat. Kanye West), and see this: Lil Wayne feat. Kanye West, how do I do this? WITHOUT removing the parentheses (because some songs have stuff like Remix in parentheses, and I want that to stay, I ONLY want it to remove the parentheses if feat is in between the parentheses)
also, do you guys know of a good book about the regex system you use so I can learn this myself?
This action will replace multiple spaces with a single space and also remove any leading or trailing spaces.
Action type:Format value Field:ARTIST Format string:$regexp($trim(%artist%),\s+, ,1)
(Make sure you place a single space between the two commas.)
This action should do it. The text within the parentheses has to match"(feat. xxxxx)" exactly , including the period. It could be made more flexible if you like: for example to also match "feat" without the period, or to also match "featuring".
It is interactive and the crosswords are progressive. It took me about two weeks to complete all nine of the crosswords, and I didn't know any regex before. It's a fun way to learn. Highly recommend it.