creating QIF file under Dos using AWK

[Wrolf]

Try awk < statement.csv -F, 'NR > 2 { print "D" $1; print "P" $2; print "T"
$3;
print "^"; }' > statement.qif

Wrolf
wrolf at wrolf.net

On Fri, Mar 6, 2015 at 10:33 AM, piggyb <piggybattery at gmail.com> wrote:

> Hello I am trying to created a QIF file from a CSV using AWK under Dos
> I have found a  example script
> <
> http://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_convert_from_CSV.2C_TSV.2C_XLS_.28Excel.29.2C_or_SXC_.28OpenOffice.org_Calc.29_to_a_QIF.3F
> >
> and edit it to work under Dos
> But I can't get the script to print out the ^ circumflex accent
> I have tried to  escape <http://www.robvanderwoude.com/escapechars.php>
> characters using ^^
>
> My Current script looks like this
> /gawk < statement.csv -F, "{ print \"D\" $1; print \"P\" $2; print \"T\"
> $3;
> print \"^\"; }" > statement.qif/
>
> Can someone also tell me how I can skip the first two rows, that would be a
> lot of help to me
>
>
>
>
> --
> View this message in context:
> http://gnucash.1415818.n4.nabble.com/creating-QIF-file-under-Dos-using-AWK-tp4676673.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>