If I had this:
NAME EYES==ID==HAIR Jon Brown==F9182==Red May Blue==F10100==Brown Bill Hazel/Green==F123==Brown
...and I wanted to create a new ID column with the ID alone, and I know that everyone's ID starts with an 'F' and will end at the '=' how would I select a substring from the compact column and take JUST the ID out?
ex. I want this as the end product
NAME EYES==ID==HAIR ID Jon Brown==F9182==Red F9182 May Blue==F10100==Brown F10100 Bill Hazel/Green==F123==Brown F123
If I can't make it end at '=' is there any way to trim the rest of the content that isn't part of the ID after selecting it?