Hello, I have some data and need to extract the first 9 numbers from this pattern across multiple rows of data. I would think that using something like this:
might work but am unaware of how to find the first 9 digits in this sequence:
I am looking to find '01J416781', each row of data starts with this pattern. I would greatly appreciate any help.