I have a value that is coming to me in the form of two digit number, semicolon, #, string of text. example being:
"03;#Red is a great color!"
I need to capture that two digit number. I was attempting subString(STRING,0,2) but if the STRING has a leading 0, it's being dropped and I wind up capturing "4;" instead of "04".
What's a good way around this?