Labels Printing

4 posts / 0 new
Last post
mauro_png
mauro_png's picture
Labels Printing

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

ok2cqr
ok2cqr's picture
Re: Labels Printing

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

mauro_png
mauro_png's picture
Re: Labels Printing

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

mauro_png
mauro_png's picture
Re: Labels Printing

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