I would like to create a calculated field that pulls out part of the string of a URL, but only if the URL does not have an added string after the number. For example: I have these four values:
I want the calculated field to return 2073498 and 345977 ONLY. Can anyone help me with this? Thanks!
Try a calculation like:
This will capture everything after /borrower/ and then attempt to cast it as an integer. It will return the numeric value for number strings and NULL for any string that has anything other than numbers.