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