AnsweredAssumed Answered

Splitting a string into 30 separate records

Question asked by mckinlay on Jul 23, 2014
Latest reply on Jul 24, 2014 by philmodjunk

Title

Splitting a string into 30 separate records

Post

     Sounds silly but I'm given data as a big string, I can readily parse it into separate fields but really the data should be split into up to 30 records, each with 5 fields, for the data to be useful. It's not consistent, some may have only one set of  5 data points (rare) but most have around three.

     Each record will need to be associated with a client record via a client_PK

     Data includes one date field, one text, the rest are simply number fields

     The solution is running on a FM13 server so ideally I would prefer it to run with out exporting then reimporting records (how I'm doing it now) speed is not that critical as it tends to be in batches of 30 to 40 records once a week.

     My current solution just dumps each set as CSV file then reimports them but it just feels inelegant 

     FM13

Outcomes