{"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":{"@type":"WebPage","@id":"/x/community/1cql5p75rly7/is-it-possible-to-split-this-into-city-and-state-c"},"headline":"is it possible to split this into City and State Columns?","text":"

is it possible to split this into City and State Columns?

","image":{"@type":"ImageObject","url":"https://pthsiwxwiiowghdtkwlv.supabase.co/storage/v1/object/public/slack_files/T025KRP981M/e1fc7d40-0b04-457b-8856-e78595923034/F08K7K1FWP9/Screenshot%202025-03-27%20at%2012.40.03.png","contentUrl":"https://pthsiwxwiiowghdtkwlv.supabase.co/storage/v1/object/public/slack_files/T025KRP981M/e1fc7d40-0b04-457b-8856-e78595923034/F08K7K1FWP9/Screenshot%202025-03-27%20at%2012.40.03.png"},"url":"/x/community/1cql5p75rly7/is-it-possible-to-split-this-into-city-and-state-c","author":{"@type":"Person","name":"Landon S.","url":"/user/e1fc7d40-0b04-457b-8856-e78595923034"},"datePublished":"2025-03-27T16:41:43.931169+00:00","dateModified":"2025-04-03T22:21:15.801585+00:00","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},"comment":[{"@type":"Comment","text":"

Use these two formulas:

1- Get the city from /location
2- Get the state from /location

","author":{"@type":"Person","name":"Faheem G.","url":"/user/d8a61b8e-d883-4af5-bb39-c082f4fc4171"},"datePublished":"2025-03-27T16:44:00.693641+00:00","dateModified":"2025-04-03T22:22:30.321558+00:00","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0}},{"@type":"Comment","text":"

thank you

","author":{"@type":"Person","name":"Landon S.","url":"/user/e1fc7d40-0b04-457b-8856-e78595923034"},"datePublished":"2025-03-27T16:47:34.65388+00:00","dateModified":"2025-04-03T22:22:30.321558+00:00","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0}},{"@type":"Comment","text":"

No problem, mate!

","author":{"@type":"Person","name":"Faheem G.","url":"/user/d8a61b8e-d883-4af5-bb39-c082f4fc4171"},"datePublished":"2025-03-27T16:50:12.659073+00:00","dateModified":"2025-04-03T22:22:30.321558+00:00","interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0}}]}

3 comments