how to edit ofx file with sed editor? Replace Copy FITID into NAME
LinforPros
linforpros at gmail.com
Sun Oct 2 04:33:04 EDT 2016
Hello, thank you for the script. I appreciate the time you expended to write
it.
It does not produce any visible changes in my computer on files being
processed.
INPUT september2016.ofx
OUTPUT septermber016converted.ofx
THE SCRIPT awkconvert_gwb.awk
I did the following:
awk -f awkconvert_gwb.awk september2016.ofx > september2016converted.ofx
and then checked if NAME has been populated with FITID line (just the
portion after the double **):
$cat septermber016converted.ofx
[...]
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20160929000000[-6:CST]
<TRNAMT>38.90
<FITID>20160929000000[-6:CST]*38.90*542**160929P2 Square Inc CCD
L202157288906
<NAME>160929P2
Square Inc CCD L2021572
</STMTTRN>
<STMTTRN>
<TRNTYPE>POS
<DTPOSTED>20160928000000[-6:CST]
<TRNAMT>-26.35
<FITID>20160928000000[-6:CST]*-26.35*13**POS DEB 1922 09/27/16 00478770
SHELL Servi$
<NAME>POS DEB 1922
09/27/16 00478770 S
</STMTTRN>
[...]
So for now I have no clue where to start.
I tried "awk --help" and did this:awk -D awkconvert_gwb.awk
awk: cmd. line:1: awkconvert_gwb.awk
awk: cmd. line:1: ^ syntax error
But I am not sure whether the option -D should serve the purpose of checking
the script..
If you could follow up on the issue I would be greatful (which of course
stil does not give you any profits.... :-) )
regards
Lin
-----
regards
Lin
--
View this message in context: http://gnucash.1415818.n4.nabble.com/how-to-edit-ofx-file-with-sed-editor-Replace-Copy-FITID-into-NAME-tp4686543p4686874.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
More information about the gnucash-user
mailing list