I have a field "Address" with the address format as "123 Something Rd, Somewhere, NSW 3456".
I would like to be able to extract the location name, which is between 2 comas, using the above example have the location name "Somewhere" copied the another field called "Location"
I have tried Mid, Left, Right expressions but to no avail
Thanks in advance
I would like to be able to extract the location name, which is between 2 comas, using the above example have the location name "Somewhere" copied the another field called "Location"
I have tried Mid, Left, Right expressions but to no avail
Thanks in advance