Grouping 1

[bnsSteve]

Hi there,

I'm wondering if there is a way/formula to group entries that have the same city name but have different country codes for the same country. Some have for example,
"*ABC 123 JM" or
"*ABC 123 J JM" or
"ABC 123 JM JM".
I would like these entries to be combined into one group.

Any help is greatly appreciated, thank you.

 

[lbass]

We would have to have a better idea of the variation in country names, but you could try something like this for the results above:

left(replace({table.country},"*",""),9)

-LB

 

[bnsSteve]

Thanks LB. It was a lot simplier than I had originally thought, but I used your idea of truncating the field then grouped it. Worked great.

thanks again.