PAF to Excel

Moderator: MOD_nyhetsgrupper

Svar
Trefor Jones

PAF to Excel

Legg inn av Trefor Jones » 31. januar 2006 kl. 21.35

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.

Denis Beauregard

Re: PAF to Excel

Legg inn av Denis Beauregard » 31. januar 2006 kl. 22.58

On Tue, 31 Jan 2006 20:35:22 +0000 (UTC), "Trefor Jones"
<[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

Charlie Hoffpauir

Re: PAF to Excel

Legg inn av Charlie Hoffpauir » 31. januar 2006 kl. 23.14

On Tue, 31 Jan 2006 20:35:22 +0000 (UTC), "Trefor Jones"
<[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/

Paul Blair

Re: PAF to Excel

Legg inn av Paul Blair » 1. februar 2006 kl. 0.37

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.



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

David

Re: PAF to Excel

Legg inn av David » 1. februar 2006 kl. 1.24

GEDTool will do that. Get the trial version by sending an e-mail to
[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.


Maloney Empire

Re: PAF to Excel

Legg inn av Maloney Empire » 1. februar 2006 kl. 3.03

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.
|
|

Steve Hayes

Re: PAF to Excel

Legg inn av Steve Hayes » 1. februar 2006 kl. 7.02

On Tue, 31 Jan 2006 20:35:22 +0000 (UTC), "Trefor Jones"
<[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

Trefor Jones

Re: PAF to Excel

Legg inn av Trefor Jones » 1. februar 2006 kl. 15.22

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!

singhals

Re: PAF to Excel

Legg inn av singhals » 1. februar 2006 kl. 16.34

Trefor Jones wrote:

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

Svar

Gå tilbake til «soc.genealogy.computing»