Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Data in the field " United States" is like given below:
I need to remove the dot from the front, comma from the centre and need just the left value of the comma.
For eg:
Autuaga County
Bullock County
Butler County and so on..
Thanks
Maybe per textbetween(FIELD, '.', ',', 1)
Hi Marcus,
Thanks for your reply.
I found the answer.
This time, I need the right hand side value..
Means, I need to remove comma, county name and dot and just need the State name..
Thanks
Just: subfield(FIELD, ',', 2)
Thanks for your reply once again Marcus..
I found the answer for this one too. And yes, I use the subfield function...
Cheerzzz..
Thanks