Document full of tables...can I compare 1 table to all others to find matches?

[Gregg_Stebben]

Hi! I love Coda…and I guess you do, too!
Thanks for helping if you can:
I have a document full of large tables…and the tables are full of lists of names and other unstructured data.
I also have a list of 500 names and I want to find out if/where the names appear throughout all the tables in the document.
Is there a way to automate this?
Yeah, I know I could cut and paste the names in search one at a time…but I am sure hoping there’s a better way!
Anyone have any thoughts?
FWIW, I thought the following might be a solution, but I think it’s only for searching in one table at a time (my document has 23 tables) and I would still have to input the names/search terms one at a time:

Hack to filter lots of data

Hi… I am new to Coda and not particularly savvy when it comes to formulas and filters…but I figured out something that might be useful for others: I have a large database of disconnected information, sort of call notes from every call I do. I have found Coda to be better overall at handling this kind of info than Evernote or Keep. I wanted to be able to quickly filter through all the records of calls to get to records with one person or one organization. I created a view that shows all recor…

Thanks for any help or ideas you can offer.

[mallika]

Hi @Gregg_Stebben,

We don’t have a very good search and workcount capability in Coda yet.
You could laborious build something like this but it will be both time (- yours) and perf ( Codas) expensive.

Do look at these as well -

Find & Count keywords from inside a paragraph of text

Told you there was a better way to do it.

Text control box for search?

I’m creating a search-based detail view. Up top, I have: Person to view: [control button to select from list of people] This lets me to start to type a person’s name, then select from a drop-down list. Then, below that, a table filtered to show just the person or people who matches that control. However, this allows me to do only a full text search. Instead of a Control to choose from a list, I’d like to be able to have a control that just lets me enter text. That way, say, if I type “Mar…