RE:selection

[Chanty4u]

hi guys

need help

i have address and i want to pic state city frm that adress as a field for that wat cn i do?

thanks

[sunny_talwar]

Can you provide sample? Also are you trying to do this in the front end or script??

[maxgro]

you can post some example

or you can look at string functions (subfield, left, right, mid, index) in the help; I suppose you have some delimiter you can use to split the address in city, etc....

[sinanozdemir]

Following @maxgro‌'s suggestion, you can use Subfield as shown below:

[Chanty4u]

Tanq sinan,

Actually data in server sry fr am nt attchng the file.

in abve example u want to look for PA address then how would you do..?

thanks.

[sinanozdemir]

I use Where clause in another preceding load statement: