calibre db result with comma separated id's

[MasterPlexus]

Hi,

I try to bring

calibredb list -f id --with-library "C:\Users\Dirk\Calibre-Bibliothek" --search 'date:<10daysago'

that it results in a comma separated list. As I'm under windows I'm not able to use

| cut -f1 -d" " | tail -n+2

what I have seen in other threads. --separator is only separating if you have a list of fields, but not making a linefeed but a Comma seems to be not possible directly?

May some has an idea.
Thanks
MP

[chaley]

When I do the following in a windows cmd box:

calibredb list -f id --search "date:<10daysago"

I get a newline-separated list of ids.

Example output:

id
50
208
209
1059
1060
1062

What exactly are you getting?

If you are trying to get rid of the first line (id) then see the solutions in this post.

What version of calibre are you running?

[MasterPlexus]

Hi.
I geht the same result. But i want to geht Pike
50, 208,209..... So instead oft newline a comma.

Version 7.21 is here in use.
BR
MP

[chaley]

I don't think calibredb can do it natively and I don't know how to do it in the windows cmd line. However, a simple python script can convert the output to a comma separated list.

To use it:

• Put this script in some file such as newlines_to_commas.py
  

  import sys
  ans = []
  for line in sys.stdin:
      ans.append(line.strip())
  print(','.join(ans[1:]))

• Run your command storing the output into a file.
  

  calibredb list -f id --with-library "C:\Users\Dirk\Calibre-Bibliothek" --search 'date:<10daysago' > file_with_newlines.txt

• Run the script. If you don't have python installed then use calibre-debug as the python interpreter.
  

  calibre-debug newlines_to_commas.py < file_with_newlines.txt > file_without_newlines.txt

  If you have python installed then use
  

  python newlines_to_commas.py < file_with_newlines.txt > file_without_newlines.txt

• The comma-separated list is now in file_without_newlines.txt

[MasterPlexus]

Many thanks, very helpfull!