Hello to anybody...
I was playing with the labels printing export option....
and in a first time I was setting up glabels for printing on a
multi label A4 sheet.... but why spend more money for buying
labels A4 sheet if we have also QSL card printed ?
So I decided to print directly on my QSL card...
now the problem are CVS {-} field...
I need the DAY, MONTH and YEAR field of qso individually...
is this possible ? or are only QSO_DATE ( year_month_day ) available ?
I can not find CVS structure on CQRLOG help....
in second way... I want to mark a field on the QSL card just like a [x]
for examples: on my QSL card I have two field like:
PSE QSL [ ]
TNX QSL [ ]
there is a way to sign a X in this field ? is this possible ?
many many thanks for all answer...
Vy 73, IZ8OXW
Hi,
you can open csv file in OpenOffice.org Calc and change date format. I thing you can also modify PSE QSL field.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
well, ok I will try.....
thank you....
bye bye Mauro, IZ8OXW
ok, here are a very stupid solution using bash scripting and "sed"
it is also possible to do by OpenOffice while importing CSV data in excell sheet
and use the TEXT SUBSTITUTION for take DAY, MONTH, YEAR
but this script will do it better and faster... ;)
I will modify it to do a better job for
substitute the "-" char only on the second "," separator field
for preventing mismatch...
<-SNIP->
#!/bin/bash
# CQRLOG CSV data modify script
# explode the QSO_DATA field into DAY, MONTH, YEAR format
#
# Mauro, IZ8OXW
#
#
INFILE=$1
OUTPUT=output
E_NOARGS=65
if [ -z "$1" ]
then
echo "Usage: `basename $0` [INPUT-FILE]"
exit $E_NOARGS
fi
sed "s/-/,/g" $INFILE > $OUTPUT
mv $OUTPUT $INFILE
echo "File cleaned. . ."
exit 0
<-SNIP>
Vy 73 Mauro, IZ8OXW
well...
I think it's better to use awk like so:
awk '{ sub(/-/,","); print }' $INFILE > $OUTPUT
that it replaces just the first match...
and we can just run the script twice
and solve the problem...
hope to be useful to somebody
73 Mauro, IZ8OXW
Vy 73 Mauro, IZ8OXW