KnightShift Posted October 23, 2003 Posted October 23, 2003 I am writing data from a repeating field(s) into a text field. This text field is then sent off as an email notice to internal users. I want each repetition cell to show on a separate text line (easier to read), no problem so far. But my problem is this, if, for example, repetition 2 has no entry, the code will leave a blank line (because of the return marker). It's this blank line I want to prevent, so I need to correctly set into the statement a condition that if the case fails, the return marker is not envoked. In this sample I am checking a field cell that would contain a "P" or "C" (partial or complete"), if it meets this criteria then get the data from a specific repeating field. Here's part of my code Case(GetRepetition(x_PO::rec.P_C_pg1,1) = "C",GetRepetition(LineString1,1), GetRepetition(x_PO::rec.P_C_pg1,1) ="P",GetRepetition(LineString1,1),"") & "
BobWeaver Posted October 23, 2003 Posted October 23, 2003 You can run the final result through this type of calculation to strip out duplicated
Recommended Posts
This topic is 7771 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now