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

[LinforPros]

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.