October 23, 200322 yr 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),"") & "
October 23, 200322 yr You can run the final result through this type of calculation to strip out duplicated
Create an account or sign in to comment