The next best thing would then be to have the field delimited with a semicolon or colon, so then it would be:
Then you could just use the split function to get the pieces you need. For this to work properly, though, the Notes, Name and Email would need to be in the same section every time. For example, have notes be first, then name, then email. Then for each section you could just do:
split({table.emailfield}, ';')[1]//notes
split({table.emailfield}, ';')[2]//name
split({table.emailfield}, ';')[3]//email
You could still keep all the information in one field and just make a small change that will have an enormous impact on the report design.
Edited by FrnhtGLI - 15 Oct 2009 at 11:38am
IP Logged
