how to edit ofx file with sed editor? Replace Copy FITID into NAME

LinforPros linforpros at
Sun Oct 2 04:33:04 EDT 2016

Hello, thank you for the script. I appreciate the time you expended to write
It does not produce any visible changes in my computer on files being

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
<FITID>20160929000000[-6:CST]*38.90*542**160929P2 Square Inc CCD
Square Inc CCD L2021572

<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


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.... :-) )


View this message in context:
Sent from the GnuCash - User mailing list archive at

More information about the gnucash-user mailing list