<html><head></head><body><div class="ydp5d2ec553yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
<div><br></div><div><br></div>
</div><div id="ydp7cc4da04yahoo_quoted_9740694616" class="ydp7cc4da04yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, December 30, 2020, 02:45:40 PM EST, Jochen Schmidt <jochen@r-ci.de> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">Am 30.12.2020 um 12:22 schrieb Aaron Mehl:<br clear="none">> I need a little help,<br clear="none">> I tried the different ideas for moving pdf to kmymoney.<br clear="none">> <br clear="none">> Okular - I used the table select, but couldn't figure out how to export<br clear="none">> csv. Plus I want something more automatic, if possible<br clear="none"><br clear="none">not automatic, but: Select table in Okular, add vertical delimiters by<br clear="none">clicking on the top border. Then just type Ctr-C.<br clear="none"><br clear="none">Change to a spreadsheet application (i.e. Libreoffice Calc) and type Ctrl-V<br clear="none">in an empty table. You are asked for formatting details, just accepting the<br clear="none">defaults does work in most cases.<br clear="none"><br clear="none">> pdftotext - produced a nice text file, but since the columns were<br clear="none">> separated, by commas and the dates also use commas I need to get the<br clear="none">> columns separated by tabs? Also I found that in the final text file there<br clear="none">> was extra rows that was overflow from the same column but the row above.<br clear="none"><br clear="none">You can use awk to output it to useful format. Years ago I wrote a perl<br clear="none">script to reformat such files according to a config file.<div class="ydp7cc4da04yqt7875913170" id="ydp7cc4da04yqtfd04034">---------------------------------------</div><div class="ydp7cc4da04yqt7875913170" id="ydp7cc4da04yqtfd04034" dir="ltr" data-setdir="false"><br clear="none"></div><br clear="none"><br clear="none">You have to help them by providing a suitable script (awk / perl whatever)<br clear="none">to get this done.<div class="ydp7cc4da04yqt7875913170" id="ydp7cc4da04yqtfd18402" dir="ltr" data-setdir="false">-----------------------------------<br clear="none"><div><div class="ydp7cc4da04yqt7875913170" id="ydp7cc4da04yqtfd04034" dir="ltr" data-setdir="false" style="color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">I unfortunately, have no such script. I am assuming it would need to be configurable.</div><div class="ydp7cc4da04yqt7875913170" id="ydp7cc4da04yqtfd04034" dir="ltr" data-setdir="false" style="color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">As I said if anyone has such a script, bring it on.....</div><div class="ydp7cc4da04yqt7875913170" id="ydp7cc4da04yqtfd04034" dir="ltr" data-setdir="false" style="color: rgb(38, 40, 42); font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Aaron <br clear="none"></div></div><br clear="none"></div></div></div>
</div>
</div></body></html>