As part of a partner integration, I’m getting a value that I need to split into 2 strings.
The first part is always 32 characters long (a user ID), and the second part is variable. So, it might be:
Where I want “dUEwKHwgfTrGc0rHfbdl9jy97uznhqYy” and “testaff”.
That’s coming in as one field, and I’d like to put the first 32 characters into a different field, and the remaining characters in a second field, like:
I could obviously use right(original_field, 32) to get the value for new_field_1. But any ideas on how I can get the value for new_field_2, since the number of characters will be variable?