Hi, I am trying to replace each occurence of these items:
{city_name}, {state_name}, {state_abbreviation}
with its corresponding city, state and state abbreviation in these columns (the first three):
city_name state_name state_abreviation
So, for example, column D, Row 2 would read: "Atlanta Widgets - See Widgets in Atlanta, Georgia"
All cities and states need to be in title case except the slug needs to be in lowercase.
The attached file is only a sample of the thousands of rows.
I hope this is clear. Thanks in advance.
Bookmarks