Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a variable in which I would like to make a selection using subfield function. I'm using the action Select in Field and in the search string I use subfield(variable name,',',variable number).
My variable is a list of field names within quotes. Example: 'name1','name2','name3', etc
The quotes create the issue. I can get the right name with the subfield but theSelect in Field wont work. Is there another function that would strip away the quotes?
Sorry everyone - just figured it out. The use of purgechar
purgechar(subfield(variable name,',',variable number),chr(39))
Sorry everyone - just figured it out. The use of purgechar
purgechar(subfield(variable name,',',variable number),chr(39))