FREEBMD-DISCUSS-L ArchivesArchiver > FREEBMD-DISCUSS > 2003-07 > 1057078518
From: "Bob Phillips" <>
Subject: Re: Show File
Date: Tue, 1 Jul 2003 17:55:39 +0100
Thank you for all the suggestions. I really want a very simple
solution, it's not me doing the file replacing and it's not fair for me to
ask a transcriber to do what may seem complicated things. However I try it
in excel I end up with commas or quotes. I'm sure it's a no-go.
I'll have to see how the transcriber feels about copy and paste into
Notepad but it adds another stage and we are dealing with a lot of files.
The transcriber involved has been very friendly and very cooperative.
----- Original Message -----
From: "Archer Barrie" <>
Sent: Tuesday, July 01, 2003 3:46 PM
Subject: RE: Show File
> Trailing spaces will not affect the upload.
> If you want to use Excel the only way I can see to get round the trailing
> comma problem is to create the Excel file with the entire line in column 1
> (e.g. by specifying tab as the delimiter on import) and then copy and
> from column 1 into notepad.
> > -----Original Message-----
> > From: Bob Phillips [mailto:]
> > Sent: 30 June 2003 11:43
> > To:
> > Subject: Show File
> > Hi
> > I am going through some file changes with another
> > transcriber. The original transcripts have not been kept. I
> > am getting copies of the files from Show-File but the copy
> > and paste technique that I am using is adding an extra space
> > to the end of every line. Does it matter to FreeBMD if these
> > spaces remain if these "copies" are used as replacement
> > files? If it does matter can the spaces be removed on Show-File?
> > Also these copies are pasted into Excel. When the Excel
> > files are saved as csv extra commas are added to the lines to
> > make each line equivalent in fields to the longest line.
> > This is stopping us from being to upload the amended excel
> > file. Does anyone know a way around this? Editing out all
> > the ",," is just making the job too fiddly.
> > cheers
> > Bob Phillips
> > ______________________________
> To join Ancestry.com and access our 1.2 billion online genealogy records,