And in what form is that drop down menu text? Do you have multiple values separated by returns in a single field of your imported data?
What exactly are you trying to do with Replace Field Contents? Replace a given value in that list with a different value?
example of what I am getting back would be "Collate| Saddle Stitch| Fold| Inserting|" I only get back the selections that are checked, so this could be anywhere from one selection to five selections. The separator value is "|" (not a small case L the character above the "\". I am trying to build an IF statement which would say something like: text field = "Score"; "X" ; "". In other words I have separate text fields in my data base for each selection. Put an "X" in the "Score" text field otherwise leave that field blank.
IsEmpty ( FilterValues ( Substitute ( ValueListField ; "|" ; ¶ ) ; "Fold" ) )
Will be true only if the value "Fold" is selected in that field.
I am not sure how to read that action, but when I tried to plug it into my calculation box for replacing the contents for my "Fold" field it didn't seem to work and messed with the rest of my importing script (which is getting quite long). I was simply going to build 5 replace field actions in my script, one for each check box option. I just can't get my calculation to pull one word out of a variable text string.
Correction: Not IsEmpty ( FilterValues ( Substitute ( ValueListField ; "|" ; ¶ ) ; "Fold" ) )
Will be true if "Fold" is a selected value.
the functions can all be looked up in help.
Substitute turns your | delimited list into a return delimited list needed in order for Filter values to be able to compare this list of selected values with the specific value shown in quotes. "Not IsEmpty" is a simple way to turn that text result into a simple True or False result such as you might need inside an If or Case function.
It works only if the first value is "Fold" but if the Fold option is in the middle of the string it doesn't pick it up. There seems to be a space in-between the | and the F in Fold when it is not the first value.
Also, how can I add: If ( Fold = "1" ; "X" ; "" ) after your statement?
You'll need to carefully examine the actual text and make sure that where I have "|", you use the actual characters that separate the values. That might be " | " (a space before and after the visible character), but you'll need to check the actual data to be sure.
For your other question:
If ( Not IsEmpty ( FilterValues ( Substitute ( ValueListField ; "|" ; ¶ ) ; "Fold" ) ) ; "X" ) // no need for the ; ""
You could put this expression inside the "calculation" option for a replace field contents operation or you could set it up as an auto-enter option if you enable auto-enter options during import. (There's a small little dialog with this check box that pops up just after you click "import".)