creating QIF file under Dos using AWK

[piggyb]

Thank for letting me know how to use a external script 
Because I am using a comma separated file, I tried these scripts

/NR <2 {FS =";"}{ print "D" $1; print "P" $2; print "T" $3; print "^"; }
NR <2 {FS ="\"*;\"*"}{ print "D" $1; print "P" $2; print "T" $3; print "^";
}/

But now the script reads form the first line and displays a comma in front
of the bank-number 


KNAB EXPORT													
BankAcount	Transactiondate	Valutacode	CreditDebet	Amount	Banknr	bankaccount
date	 Method 	Discription	Type	Machtigingsnummer	authorization Number 	Adres
123456	31-12-2014	EUR	C	50	987569	gnucash	01-01-2015	iDEAL	Contract 154543				
123457	31-12-2014	EUR	D	60	987570	gnucash	31-12-2014	iDEAL	Contract 154544	
HKU0000324354537934	KSADASD35342434235	Hippo Land
123458	31-12-2014	EUR	D	70	987571	gnucash	31-12-2014	iDEAL	Contract 154545	
HKU0000000000000001	KSADASD1	Hippo Land
123459	31-12-2014	EUR	D	71	987572	gnucash	31-12-2014	iDEAL	Contract 154546	
HKU0000000000000002	KSADASD2	Hippo Land
123460	30-12-2014	EUR	C	72	987573	gnucash	30-12-2014	iDEAL	Contract 154547	
HKU0000000000000003	KSADASD3	Hippo Land
123461	30-12-2014	EUR	C	73	987574	gnucash	30-12-2014	iDEAL	Contract 154548	
HKU0000000000000004	KSADASD4	Hippo Land
123462	30-12-2014	EUR	C	74	987575	gnucash	30-12-2014	iDEAL	Contract 154549	
HKU0000000000000005	KSADASD5	Hippo Land
123463	30-12-2014	EUR	D	75	987576	gnucash	30-12-2014	iDEAL	Contract 154550	
HKU0000000000000006	KSADASD6	Hippo Land
123464	29-12-2014	EUR	D	76	987577	gnucash	29-12-2014	iDEAL	Contract 154551	
HKU0000000000000007	KSADASD7	Hippo Land






--
View this message in context: http://gnucash.1415818.n4.nabble.com/creating-QIF-file-under-Dos-using-AWK-tp4676673p4676720.html
Sent from the GnuCash - User mailing list archive at Nabble.com.