+1I have the below two columns. I want to extract the portion of the string matching the value in the ‘Seq’ column. Example, for the first row, the seq value is 400. In BIND column, I want to extract the strings that match the value the 400.Till the semicolon. using PQL.
+11Hi!
I would use PATINDEX for this.
Something like
PATINDEX(<bind>, <seq>), with the right syntax for these columns. With that, you get the index where each seq starts in the BIND column.
Combining this with a SUBSTRING function, you can get the right string part.
SUBSTRING ( table.column, start, size ), where the start will be your PATINDEX and size will be the LENGTH of the SEQ + 17 ( “-” character + the timestamp).
One thing to mention is that PATINDEX can find, for example, the “400” in the date, so I would adjust the PATINDEX formula to search for “400-” by adding “SEQ”||”-” to the PATINDEX formula.
I hope this helps.
Balázs
+2
+1
+2
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.