PAF to Excel
Moderator: MOD_nyhetsgrupper
PAF to Excel
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to want
to recognise columns with gaps in them.
Any help wpild be appreciated.
tried printing it out and scanning to OCR but the OCR does not seem to want
to recognise columns with gaps in them.
Any help wpild be appreciated.
Re: PAF to Excel
On Tue, 31 Jan 2006 20:35:22 +0000 (UTC), "Trefor Jones"
<[email protected]> wrote in soc.genealogy.computing:
You can print directly to a text file with PAF...
Denis
<[email protected]> wrote in soc.genealogy.computing:
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to want
to recognise columns with gaps in them.
You can print directly to a text file with PAF...
Denis
Re: PAF to Excel
On Tue, 31 Jan 2006 20:35:22 +0000 (UTC), "Trefor Jones"
<[email protected]> wrote:
display on your screen, ie, if you can generate a report with the data
you want showing on the screen, then COPY (control-C) from PAF and
PASTE (Control-V) into Excel.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/
<[email protected]> wrote:
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to want
to recognise columns with gaps in them.
Any help wpild be appreciated.
You could try COPY and PASTE. That works for almost anything you can
display on your screen, ie, if you can generate a report with the data
you want showing on the screen, then COPY (control-C) from PAF and
PASTE (Control-V) into Excel.
Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/
Re: PAF to Excel
Trefor Jones wrote:
Print it out to file as .rtf (there is a Print to file checkbox on the
Print dialog)
You can then manipulate that in Word to make a table. Stick the table
into Excel.
Paul
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to want
to recognise columns with gaps in them.
Any help wpild be appreciated.
Print it out to file as .rtf (there is a Print to file checkbox on the
Print dialog)
You can then manipulate that in Word to make a table. Stick the table
into Excel.
Paul
Re: PAF to Excel
GEDTool will do that. Get the trial version by sending an e-mail to
[email protected]
Trefor Jones wrote:
[email protected]
Trefor Jones wrote:
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to want
to recognise columns with gaps in them.
Any help wpild be appreciated.
Re: PAF to Excel
Hi Trefor,
It can be done. I just did it.
If you save it as a .rft document then Select All, Copy, click on the first
cell in Excel and click on Past Special then select Unicode Text, it will
paste it into an Excel spreadsheet for you.
Good luck.
--
Di Maloney
Please remove 1 from email address to reply direct.
"Trefor Jones" <[email protected]> wrote in message
news:[email protected]...
| I would like to export a Sorted Individual List from PAF to Excel. I have
| tried printing it out and scanning to OCR but the OCR does not seem to
want
| to recognise columns with gaps in them.
| Any help wpild be appreciated.
|
|
It can be done. I just did it.
If you save it as a .rft document then Select All, Copy, click on the first
cell in Excel and click on Past Special then select Unicode Text, it will
paste it into an Excel spreadsheet for you.
Good luck.
--
Di Maloney
Please remove 1 from email address to reply direct.
"Trefor Jones" <[email protected]> wrote in message
news:[email protected]...
| I would like to export a Sorted Individual List from PAF to Excel. I have
| tried printing it out and scanning to OCR but the OCR does not seem to
want
| to recognise columns with gaps in them.
| Any help wpild be appreciated.
|
|
Re: PAF to Excel
On Tue, 31 Jan 2006 20:35:22 +0000 (UTC), "Trefor Jones"
<[email protected]> wrote:
I have a proigram that will do that with PAF 2.x (indiv2.dat files) but I
don't know about later versions.
--
Steve Hayes from Tshwane, South Africa
http://www.geocities.com/Athens/7734/stevesig.htm
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk
<[email protected]> wrote:
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to want
to recognise columns with gaps in them.
Any help wpild be appreciated.
I have a proigram that will do that with PAF 2.x (indiv2.dat files) but I
don't know about later versions.
--
Steve Hayes from Tshwane, South Africa
http://www.geocities.com/Athens/7734/stevesig.htm
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk
Re: PAF to Excel
Thanks for your all your suggestions.
"Trefor Jones" <[email protected]> wrote in message
news:[email protected]...
checkbox, printed to .rtf, imported it to Excel as a \ delimited file and
globally replaced the "tab". All 500+ names transferred in the time it took
me to scan 1 page!! Cheers all!
"Trefor Jones" <[email protected]> wrote in message
news:[email protected]...
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to
want
to recognise columns with gaps in them.
Any help wpild be appreciated.
Thanks for your all your suggestions. I eventually found the "Print to file"
checkbox, printed to .rtf, imported it to Excel as a \ delimited file and
globally replaced the "tab". All 500+ names transferred in the time it took
me to scan 1 page!! Cheers all!
Re: PAF to Excel
Trefor Jones wrote:
I'm glad it worked, but at the bottom of PAF 5's custom reports screen,
it does offer to export a comma delimited file for you.
Cheryl
Thanks for your all your suggestions.
"Trefor Jones" <[email protected]> wrote in message
news:[email protected]...
I would like to export a Sorted Individual List from PAF to Excel. I have
tried printing it out and scanning to OCR but the OCR does not seem to
want
to recognise columns with gaps in them.
Any help wpild be appreciated.
Thanks for your all your suggestions. I eventually found the "Print to file"
checkbox, printed to .rtf, imported it to Excel as a \ delimited file and
globally replaced the "tab". All 500+ names transferred in the time it took
me to scan 1 page!! Cheers all!
I'm glad it worked, but at the bottom of PAF 5's custom reports screen,
it does offer to export a comma delimited file for you.
Cheryl