FREEBMD-DISCUSS-L Archives

Archiver > FREEBMD-DISCUSS > 2003-07 > 1057078518


From: "Bob Phillips" <>
Subject: Re: Show File
Date: Tue, 1 Jul 2003 17:55:39 +0100
References: <3F66BB5AC5E4D511B23C00902746C443FAA3D5@WWMESSD207>


Hi All
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.
Thanks again
Bob
----- Original Message -----
From: "Archer Barrie" <>
To: <>
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
paste
> from column 1 into notepad.
>
> Barrie
>
> > -----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,
go to:
> http://www.ancestry.com/rd/redir.asp?targetid=571&sourceid=1237
>

This thread: