AnalystRN Posted July 23, 2019 Report Share Posted July 23, 2019 This is probably simple but i don't know how to do it. I'm using ME 5. Above is an example of what I would like to do. I want to move the data from the CSV file into the fields above. In the CSV example everything in Column A from Group through Group12 goes into the one program screen in meditech and then I need it to "start over" with Group F.PRECA and continue on. I don't know how to call F.LIVWITH and then call the "element codes" and "element names" as they are in the same column in the .CSV file. Any help would be greatly appreciated. Quote Link to comment Share on other sites More sharing options...
Cory Posted July 23, 2019 Report Share Posted July 23, 2019 Are you using ASCII File Process? Are you using controls? Assuming you are, as you look though the file line by line, you would detect by the content of the first array value if it's "Group" and then switch you method in the loop to add the GroupElements. Once group row appears again, do the other thing. Quote Link to comment Share on other sites More sharing options...
AnalystRN Posted July 23, 2019 Author Report Share Posted July 23, 2019 I attempted to do it as a .txt but I don't know how to split the rows up and apparently ME5 doesn't have the split variable command? So in the example above I am using ASCII. What do you mean by "controls?" What I am seeing so far is ASCII seems to look at data via columns and Text seems to look at data by rows is that correct? Quote Link to comment Share on other sites More sharing options...
Cory Posted October 27, 2019 Report Share Posted October 27, 2019 If you use ASCII File Process it splits the variables for you on the delimiter, a comma. There is a Split command. Please read the help file. It's called "Split String", you can't miss it. Last question is correct. ASCII file process reads line by line like Text File Process, but it splits the row by the delimiter and places them in an array variable of your choice. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.