I have this variable 1874;#Bob Williams. I tried this and it should give me 1874 but it's giving me the entire variable. Any idea?
(?<=\w+;)
Whatever tool/engine you're using is removing what it matches and returns what remains after removal, so this should work for you: ;.+