Hello everyone! I really need help. I have a field with complete url from where lead is create. I need a formula to cut it. For example, the field contains: https://derco-blend.test-1.dercochile.soho.cl/busqueda?brands=Renault&carClasses=all&fuel=all&transmission=all&terms=36&priceRange=1000000,60000000&campaing=D%C3%ADas%200Km&utm_source=renault.cl&utm_medium=referral&utm_campaign=dias0km_banner
I neet to extraict utm_source exlusively. In this case is "Renault.cl". is there any formula to extraict just a text from the field with some conditions.
Not sure what exactly the formula will be. But you will have to use the following formula functions to get the desired result.
FIND
LEN
RIGHT
LEFT
I am sharing some useful links
https://www.shellblack.com/administration/parsing-text-using-formulas/
https://developer.salesforce.com/forums/?id=9062I000000Xqg3QAC
