Approach each step logically.
I have a field which can contain one email address, or multiple email addresses, seperated by a semi colon (;). Each listing starts with a 4 character prefix and the end of the email addresses is dictated by a colon character (:). For example,
-Each e-mail is separated by a semi-colon
-Each contains a 4 character prefix
-list of e-mails ends with a colon
Assuming it is a single text field and it will always be this format, you would do the following in order:
1. get the index of the colon, starting from index t (just after the first colon so you don't count it)
2. take the substring from 4 to the index of the colon - 1 and split on semi-colons, and assign that to a temp array variable
3. for each item in the array, append it to a temp string var and add ChrW(13) to the end of each item.
You should end up with a huge multi-line textbox with one e-mail on each line. Though after trying that, I exported to excel (data-only) and it was still one line. I then tried exporting the entire report and it showed up properly, for which I copied the contents of the box and pasted it in another spreadsheet and it worked fine.
Edited by Keikoku - 22 Mar 2011 at 3:16am