thverdigroup Posted September 24, 2009 Share Posted September 24, 2009 Hello, I am currently trying to create a rule in my design where if there are two names in the file an "and" will be placed in between them. And if there is only one name the "and" is removed. Can anyone help me out as how to do this. I am new to the program and still learning. Thanks! Verdi Example: John Doe and Jane Doe, Link to comment Share on other sites More sharing options...
Alex Marshall Posted September 24, 2009 Share Posted September 24, 2009 Is the data in one field, or two different fields from your data file? Link to comment Share on other sites More sharing options...
Dan Korn Posted September 24, 2009 Share Posted September 24, 2009 There are more succinct solutions possible, but this should work: if (Field("Field1") && Field("Field2")) return Field("Field1") + " and " + Field("Field2"); //else return Field("Field1") || Field("Field2");Replace the field names with your own. Link to comment Share on other sites More sharing options...
thverdigroup Posted September 24, 2009 Author Share Posted September 24, 2009 Thank you so much!!! That worked!!!! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.