Hi…I’m trying to output data into a file with the following format:
009996213 EN375 MW TISCH-207 02:30 PM -03:50 PM Smith, Susannah B. EN380 TR LIB-213 11:10 AM -12:30 PM Smith, Greg AM235 TR TISCH-203 03:40 PM -05:30 PM Smith, Rebecca ********** 009991512 AN101 TR ANNEX-119 09:40 AM -11:00 AM Smith, Joowon PA112C MW SPORTS-WGHT 09:05 AM -10:00 AM Smith, Joseph T. AAMF323 TR BOLTON-281 03:40 PM -05:30 PM Smith, Scott EN238 MW PALMTN-303 04:00 PM -05:20 PM Smith, Hajar SO101 WF TISCH-203 12:20 PM -01:40 PM Smith, James R. ********** 009991008 AN101 MWF BOLTON-280 09:05 AM -10:00 AM Smith, Bernardo R. MP193 WF ZANKEL-006 01:30 PM -02:50 PM Smith, Brett D. CS209 MWF ANNEX-118 10:10 AM -11:05 AM Smith, Michael PA118C MW SPORTS-GYM 11:15 AM -12:10 PM Smith, Robert J. SW212 TR PALMTN-GANN 11:10 AM -12:30 PM Smith, Peter J. CS209 R CIS-237 12:40 PM -03:30 PM Smith, Michael **********
So in short, they are looking for a student id in the first field and then looking for ********** to close the record. All the data in the middle is fixed width and easily defined.
I know how to group this data and have it display this way in JSON, but am baffled as to how to translate this to a fixed width file using SL. Any ideas? This was built out in a PL/SQL script previously and I’d like to ditch that particular code to move this integration to SL.