Build an AppleScript that reads a Numbers file and picks out certain values to print to a text file

I have a data set that is in a Numbers file. It has pertinent range variable data to report every day at the same time every day. The data changes over time given the functions within the Numbers file. I would like to build a script that keeps Numbers closed, reads the file and looks for a value of 1, 1.0, 2, 3, 5, and 8 and writes the text string of heading of the target values and the values themselves every time they occur within the Numbers file and spits these values to a text file. Here is an example Numbers file and print out to the text file of what I have explained I wish to have help building. I also want it to write out the text file in the order of the Fibonacci sequence just like it is listed above and in the text file that I provided for an example of the design intent for the problem statement for the class. If you have any questions about the problem statement feel free to ask for clarification on how to correctly answer this "ask the community" exercise to satisfy my needs for the algorithm that is desired to be sufficiently solved. I will give you a hint; one needs to specify for the AppleScript script to scrape the data via a logical order of operations of when to print which value based on the desired order of 1, 1.0, 2, 3, 5, 8 and then continue where it left off and continue looking for another instance of the desired order further down in the data set and it must print the text at the end of the text file

once it has satisfied the conditions that it can ascertain the data set no longer has a chronological readable Fibonacci sequence within it.


MacBook Air 13″, macOS 14.5

Posted on Jul 4, 2024 1:28 PM

Reply

There are no replies.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Build an AppleScript that reads a Numbers file and picks out certain values to print to a text file

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.