Remove comma and dot from a record

[NiTo]

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

[marcus_sommer]

Maybe per textbetween(FIELD, '.', ',', 1)

[NiTo]

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

[marcus_sommer]

Just: subfield(FIELD, ',', 2)

[NiTo]

Thanks for your reply once again Marcus..

I found the answer for this one too. And yes, I use the subfield function...

Cheerzzz..

Thanks