[SOLVED] How to 'split' second half of phrase?

Need help Database
1

Hi all,

I have this name white_9003_aruba1 and I want to display this; aruba1. I am using the split function to ‘extract’ only the required text but if I split by white_9003_ I am finding that the result is white_9003_, not aruba1

2

I am using the split function to ‘extract’ only the required text but if I split by white_9003_

try split by aruba1

3

Hi there, @darren.james7518… I might be missing something because this seems too easy, but if you split by an underscore and grab the last item (i.e., add the :last item operator to the end of the expression), you should get the desired result.

Best…
Mike

3 Likes
4

When you split by, it generates a list of texts. You need item #2

1 Like
5

:split by _ last item

1 Like
6

Thanks guys!

:split by _ last item was the solution. I have no idea why I didn’t try that. DOH!