Left of a string
30 views (last 30 days)
Hello, I have a column in my table array called key_value.
The array contains a string such as '1234567891234|XYZ|9999'.
How do I code for each of these cells extract the first 13 characters?
I have tried key_value(1:13) but this does not work and simply pulls out the first 13 rows of records.