I am attempting to extract the bold value from this example string.
I used Split("/“c)(0) and then Split(” ") to separate the string up but I can’t seem to navigate any further than that.
Unsure how to display the second to last value from that string, as the address "Montague Lloyd can vary the number of spaces present.
> M100002 SAMPLES Montague Lloyd, United Kingdom 27.00 Active 22.50 30/10/2020 1 ***** TRAINING - Unico Limited ***** 128 - ML Telesales - Calls
Anyone got a god approach to this sort of string split activity
Regular expression is the recommended way to extract information from a text. But if you prefer to use Split(), you can get the second last value by reversing the array and then selecting the second value: