Include Command or READTEXT Command?

[Snowshoeman]

Hello,

I have a Prime 11 file that I'm using 4 iterations of the INCLUDE Statement to pull data from 4 prime sheets.  The processing is very slow.

I'm thinking about using instead four sets of READTEXT commands as I can probably pull the data I need from the 4 prime files into 4 large text files.  Then read the text files back into the Prime sheet in question.  Seems like there would be more time creating the text files with WRITETEXT commands for each sheet.  But processing the 4 big text files into my sheet should be quicker.

Anyone has experience with these two alternatives?  I see a number of questions regarding the INCLUDE statement.

[terryhendicott]

Hi Bob

If your data is numeric only matrices then WRITEBIN() and READBIN() are very effective.  Used for very large FEA matrices and happy with the speed.

Cheers

Terry

[Snowshoeman]

It's all strings.

[Werner_E]

To be honest, I don't know what to imagine under “4 iterations of the INCLUDE Statement”.

But if the data in the include files, which is then later transferred to the main sheet, has to be calculated in a complex and time-consuming manner, it can certainly be advantageous to calculate it only once and then make it available in a file.

You could possibly make sure that numerical data is not saved as a string already when saving, or you could convert the data column in one go when importing so that numerical data is also available as such (as I showed in your other thread).

I can't say more than that with only vague hints about how your worksheet is structured.
If you can't provide your worksheets here, you could at least create similar sample worksheets with dummy data that still show the procedure.

[Snowshoeman]

Hello,

I hope this reply gets to you. The information is not necessarily proprietary but has sensitive NERC CIP information. So, I can’t share the project and adjacent materials. I can only share snippets. But what you have provided is very valuable and probably enough for now.

Thank you for all your help.

Bob