Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
Please help me to create proper string with values that I need to select in field. I set several location names and separate them with comma s and apostrophes , but selection doesn't works.
Here these values:
'Arizona Avenue', 'Paula's New Avenue', 'High Road Center'
Try instead e.g.
='(Arizona Avenue|Paula''s New Avenue|High Road Center)'
Note that your middle value will be tricky due to the use of a single quote within the text, so it needs to be replaced with two single quotes or otherwise dealt with.
Try instead e.g.
='(Arizona Avenue|Paula''s New Avenue|High Road Center)'
Note that your middle value will be tricky due to the use of a single quote within the text, so it needs to be replaced with two single quotes or otherwise dealt with.
Brilliant! It works for me! Thank you much!