Copy 1 column of numbers to csv text

macOS
1

I have a gadget that will talk to my camera, allow clients to rate images, export the rating with the image number in a large column with image numbers (need) and rating number (great for sort but don’t want to copy text).
In Lightroom Classic, I need to copy just the file name into comma separated text so i can search for those files and tag with inside Lightroom with rating ( i e 5 starts)
I have put the columns into Numbers - that’s easy. But can’t figure out how to copy a numbers column into csv text only.

Update - find/replace - replaced .NEF with ", " but lightroom is only finding 1st file name not all files

Help! :slight_smile:

2

I knew if i kept trying… figured it out

  1. Emailed myself the rating list

  2. copy/paste all the ratings into a Numbers document or Excel

  3. Filter by rating

  4. Replace part of the file name with find/replace - Replace _DSC part of file name with nil. Replace .NEF with nil so I’m left with just numbers in Numbers
    6925
    6990
    7021
    7056

  5. Copy numbers column

  6. Paste into Text search in Lightroom - viola! those images appear!

  7. Select all and hit the corresponding # 1-5 for rating.

  8. Do a happy dance!

3

Great job! Sometimes it’s not clear why things don’t work, so I’m glad to hear you found a solution.

Welcome to the forums!