I am building a check and i selected the field adress, when I preview it give the result below.
it gives me the whole address ( street name , city , postal code, province and Country code) , is there a formula that i can use to remove the country code , on my client model the country code is not required.
In cases like this you could use substring-before() and substring-after() Xpath functions. The important thing to know when using them is that substring-before() returns a part of the string that occurs before the first occurrence of supplied argument i.e. the part of the string we are using to split it. Similarly, the substring-after() function will return a part of the string that occurs after the first occurrence of supplied argument.