Welcome to the community, @Bryan_Delmee! :grinning_face_with_big_eyes: There are a couple of ways to go about this. One is to use a combination of the FIND() and MID() functions to locate that equals sign in the URL, then grab all of the characters after it. The FIND() part would look like this:
FIND("=", {Referral URL})
That will give you a number representing the character position of the equals sign in the string.
The MID() function extracts a specific number of characters from a string starting at a specific position. In this case, you need to begin one position after the equals sign, and then grab six characters (assuming it’s always going to be six; if not, you can always grab more and the function is smart enough to know where the string ends).
To make this work, you’ll nest the FIND() function inside the MID() function where you want to insert the position of the equals sign, adding one to start one character past it. The final formula would be this:
MID({Referral URL}, FIND("=", {Referral URL}) + 1, 6)
Another way to do this would be to use one of the relatively-new regular expression functions, REGEX_EXTRACT(). This formula below effectively does the same thing as the one above: finding and ignoring the equals sign, then extracting everything after it.
REGEX_EXTRACT({Referral URL}, "(?:=)(.*)")
Regular expressions can do more complex matching and extraction than what’s possible with other functions, and often do it in a more compact way, as you can see here. It’s all about recognizing patterns and learning to represent those patterns with the regular expression tokens. They take some time to get used to, but I recommend investing that time. It’s well worth it!
