<aside> đź“– Properties required

  1. Text property called “Name” </aside>

Screen Shot 2022-01-17 at 2.56.11 PM.png

City

if(length(replaceAll(prop("Name"), "[^,]", "")) + 1 == 4, replaceAll(replace(prop("Name"), "(?:[^,]*, ){1}", ""), ",.*", ""), "")

Breakdown

Region

if(length(replaceAll(prop("Name"), "[^,]", "")) + 1 == 4, replaceAll(replace(prop("Name"), "(?:[^,]*, ){2}", ""), ",.*", ""), if(length(replaceAll(prop("Name"), "[^,]", "")) + 1 == 3, replaceAll(replace(prop("Name"), "(?:[^,]*, ){1}", ""), ",.*", ""), ""))

Breakdown

Country

replaceAll(prop("Name"), ".*, ", "")

Breakdown