Organizing variables (2000+)

[JMichaelTX]

@hh97

I want one table that i can put values in and access without having to space each column manually as do now, and perhaps a better way to get a value from the table (i currently use get substring). For scale, I will need at least 2000 rows and the number only grows.

2000 rows may be stretching the usability of this technique, but you can give it a try to see if the performance is acceptable:
Lookup / Search within macros (telephone directory) / internal "database" in KM and how to do it elegantly?

I would store the data as files, maybe the source file being Excel, which you can export to text as TAB delimited when needed. If the performance is unacceptable, you could save to separate files based on some category.

Here is a simple example to get you started.
Instead of storing the data in a KM Variable, I would change to use a file.

MACRO: Replace Text with Numbers; OR, Lookup Data Using RegEx [Example]

For really large datasets (>> 2,000 rows), I would consider:

1. SQL Database (SQLite)
2. Excel using VLookup

Both of those obviously require more development effort, but will easily provide a good return if this is an ongoing workflow.