I am having hardtime writing the most eficient SQL for the following use case.
I need to write an SQL to extract the digit code which is bolded above from a huge dataset .
Any help would be appreciated.
Use a regular expression, look for the string '&source=' and return the following digits:
Thanks for the solution.
When I apply the above solution I get the following output.
There's a '?' instead of a '&', you might simply remove the first character from the regex:
Thanks a lot Dieter for the help.
Is there a documentation for the REGEXP_SUBSTR In teradata ??