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

LinforPros linforpros at gmail.com
Mon Oct 3 20:31:07 EDT 2016


Chris,
I think I found the problem.
The removal of "^" from your script seems to work.

<FITID>20160902000000[-6:CST]*-27.68*13**POS DEB 2022 09/01/16 00077336 KUM 
GO #0633 1400 N MINNESOTA A
<NAME>POS DEB 2022 09/01/16 00077336 KUM  GO #0633 1400 N MINNESOTA A

The script looks looks like this now:

$ cat awkconvert_gwb.awk 
/<STMTTRN>/ {
	name=""
}
/<FITID>/ {
	idx=index($0, "**")
	if (idx > 0) {
		name=substr($0, idx+2)
	}
}
/<NAME>/ {
	if (length(name) > 0) {
		print "<NAME>" name
		next
	}
}
{ print }


Do you think it will be safe to use it without those ^ ?

regards
Lin



-----
regards
Lin
--
View this message in context: http://gnucash.1415818.n4.nabble.com/RE-how-to-edit-ofx-file-with-sed-editor-Replace-Copy-FITID-tp4686890p4686893.html
Sent from the GnuCash - User mailing list archive at Nabble.com.


More information about the gnucash-user mailing list