Hi,
How can I extract values with a specific format from a field that has a lot of pipe "|" symbols?
For example:
Testing|some text here|AB-17-1234567|...|...|...
The value I want is AB-17-1234567 where the first two characters (which won't always be the same) will always be a letter and the rest after that will always be some numbers. I want to say it should be 2 numbers followed by 7 numbers consistently but is there a way to return that value and stop at the next pipe symbol? I only want those characters returned between the two pipes.
Using MS SQL Server Management Studio v11.x to do this.
Thanks.
How can I extract values with a specific format from a field that has a lot of pipe "|" symbols?
For example:
Testing|some text here|AB-17-1234567|...|...|...
The value I want is AB-17-1234567 where the first two characters (which won't always be the same) will always be a letter and the rest after that will always be some numbers. I want to say it should be 2 numbers followed by 7 numbers consistently but is there a way to return that value and stop at the next pipe symbol? I only want those characters returned between the two pipes.
Using MS SQL Server Management Studio v11.x to do this.
Thanks.