Copy address from Apple Notes in table?

[yoalfie]

I have an Apple note with a table with 2 columns, name and address. I would like to create a workflow where I could type the name from column 1 and have it copy the address from column 2. Is that possible? Would it be easier if it were stored in a plain text file or some other format?

[vitor]

6 hours ago, yoalfie said:

Would it be easier if it were stored in a plain text file or some other format?

 

Considerably. A csv would be ideal. You can even load said csv directly into a List Filter Input in Alfred.

[yoalfie]

Thanks, I created a .csv file which works. Is it possible to copy 2 lines? My csv file contains:

Library1,sub,"Library1\n1 main st, New York"
Library2,sub,"Library2\n2 main st, New York"
 

The workflow follows with copy to clipboard but pasting in the text shows \n on one line instead of interpreting it as a newline. How can I get it to copy 2 lines?

[vitor]

3 hours ago, yoalfie said:

How can I get it to copy 2 lines?

 

Either edit the Arg for that line in the List Filter, or add a Run Script between Your List Filter and the next node, that looks like this: