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:
dUEwKHwgfTrGc0rHfbdl9jy97uznhqYytestaff
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?
Hey @Sunny_Singla - hope you are keeping safe and well
This is a very simple, elegant but powerful solution to this problem. I was scratching my head when I read this. I hadn’t thought of looking for the value and “replacing” it with ‘blank’ leaving the remaining characters.
A really clever solution with some simple text formula using the replace function. I was thinking how to ‘split’ the string, but this is not an operator
