I have a Marcom store with a multi-line text box.
The user will enter data as follows (into a single text box):
13-103 | Calculus I | 9-10 | W
10-212 | English 1102 | 11-12 | W
11-109 | Statistics | 12-1 | W
19-115 | Project Management | 8-9 | F
17-206 | Chemistry 2 | 8-9 | S
The user is instructed to enter a pipe symbol as a delimiter.
So here's what I need to do:
1. Write a rule that will read the entire contents of that multi-line text box into an object(?) or array(?)
2. Use the FusionPro table object to create a new instance of a 4 column table, and populate the entire table with the data above
The number of rows will vary, but it will always have 4 columns.
I was able to get this to work if the data is in an external data file (using ExternalDataFileEx and a for loop).
But I'm having trouble figuring out how to read in the data if it's in a multi-line text box (not an external data file). Is there a FusionPro function that does this?