How would I go about removing a substring whenever I find a specific pattern in a field in the load script.
If the string is http://www.internet.com/specificpage.cfm?id=12345
I would want to grab the '12345' everytime there is '/specificpage.cfm?id='
Even if the url was http://www.internet.com/specificpage.cfm?id=12345&other=stuff
So I am trying to find a specific pattern, note its place in the string, and then make a substring with the 5 characters after that position... I think
I have gotten this far before getting stumped:
IF(wildmatch(URL,'*/specificpage.cfm?id=*')=1,SUBSTRING STUFF HERE,0) as id_substring;