The Advance Preview has a function called "contains" which only returns true/false currently. It should return -1 if not found, otherwise it should return the beginning character position (origin zero) in the original string. Then it can be used with "substring" to extract a string that skips the search string. For example, substring("3#;Melbourne",contains("3#;Melbourne",#;")+2,255) would return "Melbourne" (the +2 is to skip over the length of the substring being searched for). Without this feature, it would be very difficult to accomplish this capability

[ ref:00D90q6Cb.5002v2O1hcz:ref ]