Skip to main content
S
Snowshoeman13-Aquamarine
13-Aquamarine
August 7, 2025
Question

Include Command or READTEXT Command?

  • August 7, 2025
  • 2 replies
  • 458 views

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.

2 replies

T
21-Topaz II
terryhendicott21-Topaz II
21-Topaz II
August 7, 2025

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

S
Snowshoeman13-AquamarineAuthor
13-Aquamarine
August 7, 2025

It's all strings.

W
Werner_E25-Diamond I
25-Diamond I
August 7, 2025

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.

 

S
Snowshoeman13-AquamarineAuthor
13-Aquamarine
August 7, 2025

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

Terms & ConditionsCookie settingsAccessibility statement