"Denis Beauregard" <denis.b-at-francogene.com@fr.invalid> wrote in message news:qosdk3dha6qlns6v1thn2ajuessm1du6io@4ax.com... > On Fri, 23 Nov 2007 21:45:57 +1300, "Himself" <himself@himself.com> > wrote in soc.genealogy.computing: > >>I am using Excel 2000 for a one name study project. >> >>Currently there are 3100 rows and 22 cols. >> >>Apart from one column all others sort in order. >> >>The column that will not sort correctly is the one with the forenames in >>it. >> > > Put the cursor over the last John and check (with F2) if it is > "John ", i.e. with a space at the end. Or look for "* " using > "full cell" (not sure about the option in English since I use > the French version of Excel). > Thanks Denis, Lesley and Steve, Denis identified the problem exactly. Data was imported from 3 different sources 1. Created in Excel and had no space at the end of the names. 2. Screen captured and imported with a single space at the end of the names. 3. Screen captured and heavily edited resulting, in two spaces at end of names. So hence the sorting result was not as expected. Now the trick will be to remove all the unwanted spaces from 3000 cells, the lazy way. Any suggestions ? Using Google there is mention of the TRIM command but not how a novice can apply it within a spreadsheet. Keith

Himself wrote: > Trying the TRIM option within Excel didn't but I must have got the syntax > wrong as it just gave #VALUE, at which point I didn't understand. Well, I gather you've already fixed it, but here's yet another method: 1. Select the column to be fixed 2. Insert column 3. In the new column, next to the first cell to be fixed, put =Trim(B1) if you are fixing column B and the first bad cell is row 1 if not, adjust. 4. Select from the =trim to the bottom. 5. Fill down 6. Select it again (probably still is) 7. Edit -> Paste special -> click "Values" -> OK 8. Your new column is now the "fixed" version of the old. Delete the old. -- Wes Groleau Guidelines for judging others: 1. Don't attribute to malice that which can be adequately explained by stupidity. 2. Don't attribute to stupidity that which can be adequately explained by ignorance. 3. Don't attribute to ignorance that which can be adequately explained by misunderstanding.

I am using Excel 2000 for a one name study project. Currently there are 3100 rows and 22 cols. Apart from one column all others sort in order. The column that will not sort correctly is the one with the forenames in it. Currently I get, for example: John John John John Albert John Frederick John George John William John John Jonathan I have formatted all cells to Text Justified the text to the left but still it will not sort in strict alpha order. The same file on other PCs using Excel 2003 and Open Office displays the same problem, thus it is my file that is the issue. Some of the data was imported from screen captured data, so I wonder if the spreadsheet has picked up some hidden coding that gives rise to the issue. Ideas, anyone ? Thanks Keith

On Sat, 24 Nov 2007 07:52:00 +1300, Himself <himself@himself.com> wrote: > 1. Created in Excel and had no space at the end of the names. > 2. Screen captured and imported with a single space at the end of the names. > 3. Screen captured and heavily edited resulting, in two spaces at end of > names. > > So hence the sorting result was not as expected. > Now the trick will be to remove all the unwanted spaces from 3000 cells, the > lazy way. Any suggestions ? Yup. Are you on anything other than Windows? If so, piece of cake with built-in Unix stuff on your system. Otherwise, do this: (I'm winging it but this should work) Export your data to a CSV file Open up the CSV file in your favorite editor (notepad if it can do search/replace) Find all instances of this (without the quotes): " ," and replace it with "," (again, without the quotes) Do it a second time to take care of the ones which were " ," but are now " ," Save it, get out of your editor, and then open the CSV file with Excel. Done. Let me know if that works - otherwise I can probably get exotic if needed. Dave

On Sat, 24 Nov 2007 11:13:13 +1300, "Himself" <himself@himself.com> wrote in soc.genealogy.computing: >Help within Excel does not go into details as how to apply TRIM, as you >have. Actually, it does. You type = and there is a button at the left end of the formula toolbar (replacing the cell position). Press that button (actually the selector, on the right side of the button) and select other functions (at the bottom of the list), then the text category then the trim function, and you get a dialog helping you to enter the text. At least, this is available in Excel 97. >My lesson learnt is to check for trailing spaces before importing additions >to the spreadsheet. Indeed Denis -- 0 Denis Beauregard - /\/ Les Français d'Amérique du Nord - www.francogene.com/genealogie--quebec/ |\ French in North America before 1722 - www.francogene.com/quebec--genealogy/ / | Maintenant sur cédérom, début à 1770 (Version 2008) oo oo Now on CD-ROM, beginnings to 1770 (2008 Release)

janehewitt@gmail.com wrote: > Free Genealogy Vouchers! > > The Origins Network (www.originsnetwork.com), specialists in British > and Irish genealogy, is offering free 24 hour access vouchers for both > British and Irish Origins to the first 200 people who sign up!* > > Visit: http://www.originsnetwork.com/thanksgivingoffer.aspx for more > information and details of how to register. > > Online Collections include: > > · Complete 1841, 1861 England and Wales Censuses with images > · Largest online index of pre-1837 marriages > · Wills > · Apprentice records > · Court records > · Property records > · Irish Census records > · Boyd's London Inhabitants > · Passenger lists > · Griffith's Valuation > · British & Irish galleries > > Origins Network records date back to the 13th Century and continue > into the 20th Century and are mostly not available anywhere else > online. > > *Please note that this offer is only available to new subscribers > > For further information, please email help@origins.net Origins Network? Isn't that the one that banjaxes the back button? -- Ian Hotmail is for spammers. Real mail address is igoddard at nildram co uk

Le Sat, 24 Nov 2007 07:52:00 +1300, "Himself" <himself@himself.com> écrivait dans soc.genealogy.computing: >Now the trick will be to remove all the unwanted spaces from 3000 cells, the >lazy way. Any suggestions ? save your excel sheet. add a column after this. If in column D, insert new column E. In the first line (cell E1), type the formula =trim(d1) copy and paste the cell to all the next lines highlight column E, then paste "special" and select "value" CHECK IF YOU DID IT CORRECTLY, i.e. if the cursor is on the new cell, do you see the formula or the name. Use F2 to check. delete colomn D. IF YOU MADE SOMETHING WRONG, quit the sheet (no save) and reopen the previous one. IMPORTANT : I use the French version of Excel. I don't know if trim is the right command for that. I usually proceed differently, by using the number of characters and copy the cell minus 1 char, and I then check again, in case some words add 2 spaces at the end. Denis -- 0 Denis Beauregard - /\/ Les Français d'Amérique du Nord - www.francogene.com/genealogie--quebec/ |\ French in North America before 1722 - www.francogene.com/quebec--genealogy/ / | Maintenant sur cédérom, début à 1770 (Version 2008) oo oo Now on CD-ROM, beginnings to 1770 (2008 Release)

On Fri, 23 Nov 2007 02:38:51 -0800 (PST), janehewitt@gmail.com <janehewitt@gmail.com> wrote: > > Free Genealogy Vouchers! Your flogging of a commercial website here is unwanted and spam. This isn't the first time you have chosen to show wanton disregard for the charter of the group. Showing your potential customers you know but won't follow rules is rarely a way to succeed.

jesse mc wrote: > Hi folks, I'm back needing advice on subject. Is there a way that > doesn't cost an arm & leg to transfer slides to my computer? I have > many-many slides I'd like to post on my web site. Thanks > jessemc I've tried 2 flat bed HP 4470c has a light adapter to go on the flat bed - takes 4 slides - push the slides up a the track one behind the other quite difficult to load and remove. You have to drag select each slide. Results ok but not brilliant. Windows only and no drivers for Vista. HP make newer models that appear to be similar Canon 9950f much more sophisticated - a template and you pop in 12 slides and it then does all the work - itself scanning one slide at a time - takes 40 minutes or so for the template. Still a flat bed so dust. Windows or MAC Plustek 7200i only for slides and negs - not a flat bed - so some dust problems removed an easy pop in slide takes 4 at a time. http://www.plustek.com/product/7200i.asp comes with http://www.silverfast.com/product/Plustek/535/en.html which means you can adjust stuff before scanning Slides are more difficult than paper as small - enlarge up well when in a projector but how to scan. With the Plustek I would go for 1200 dpi maybe 2400 for real quality some thought on that here http://www.scantips.com/basics12b.html Ron Lankshear - Sydney Aust (from London- Shepherds Bush & Chiswick) http://freepages.rootsweb.com/~lankshear/

On Fri, 23 Nov 2007 21:45:57 +1300, "Himself" <himself@himself.com> wrote in soc.genealogy.computing: >I am using Excel 2000 for a one name study project. > >Currently there are 3100 rows and 22 cols. > >Apart from one column all others sort in order. > >The column that will not sort correctly is the one with the forenames in it. > >Currently I get, for example: > >John >John >John >John Albert >John Frederick >John George >John William >John >John >Jonathan Put the cursor over the last John and check (with F2) if it is "John ", i.e. with a space at the end. Or look for "* " using "full cell" (not sure about the option in English since I use the French version of Excel). >I have formatted all cells to Text >Justified the text to the left > >but still it will not sort in strict alpha order. > >The same file on other PCs using Excel 2003 and Open Office displays the >same problem, thus it is my file that is the issue. Denis -- 0 Denis Beauregard - /\/ Les Français d'Amérique du Nord - www.francogene.com/genealogie--quebec/ |\ French in North America before 1722 - www.francogene.com/quebec--genealogy/ / | Maintenant sur cédérom, début à 1770 (Version 2008) oo oo Now on CD-ROM, beginnings to 1770 (2008 Release)

"Himself" <himself@himself.com> wrote in message news:fi6415$6ja$1@lust.ihug.co.nz... >I am using Excel 2000 for a one name study project. > > Currently there are 3100 rows and 22 cols. > > Apart from one column all others sort in order. > > The column that will not sort correctly is the one with the forenames in > it. > > Currently I get, for example: > > John > John > John > John Albert > John Frederick > John George > John William > John > John > Jonathan > It looks as though it's only sorting on the first word. I had this trouble with Word Perfect last week, then found that the default setting is 'first word only' and you have to specifically tell it if you want it to use the second (and later) one as well. Have a hunt through the sort setup area and see if there's somewhere to redefine the sort. Lesley Robertson

"Himself" <himself@himself.com> wrote in message news:fi6415$6ja$1@lust.ihug.co.nz... > > Some of the data was imported from screen captured data, so I wonder > if the spreadsheet has picked up some hidden coding that gives rise to > the issue. > > Ideas, anyone ? Try saving it as a .csv file and manually inspect the dodgy data? Steven

Free Genealogy Vouchers! The Origins Network (www.originsnetwork.com), specialists in British and Irish genealogy, is offering free 24 hour access vouchers for both British and Irish Origins to the first 200 people who sign up!* Visit: http://www.originsnetwork.com/thanksgivingoffer.aspx for more information and details of how to register. Online Collections include: · Complete 1841, 1861 England and Wales Censuses with images · Largest online index of pre-1837 marriages · Wills · Apprentice records · Court records · Property records · Irish Census records · Boyd's London Inhabitants · Passenger lists · Griffith's Valuation · British & Irish galleries Origins Network records date back to the 13th Century and continue into the 20th Century and are mostly not available anywhere else online. *Please note that this offer is only available to new subscribers For further information, please email help@origins.net

I use a Minolta Dimage Dual Scan IV for slide and negative scanning. Probably will not fit your price range or media requirements. http://www.pcmag.com/article2/0,1759,1550783,00.asp http://shutterbug.com/equipmentreviews/scanners_printers/0805konica/ I bought mine used on eBay.

On Wed, 21 Nov 2007 02:52:59 GMT, Wes Groleau <groleau+news@freeshell.org> wrote: >Robert G. Eldridge wrote: >> I have scanned 2 rolls of 35mm microfilm with my Cannon 8000F flat bed >> scanner. >> >> I masked off 3 or the 4 slide holders and part of the 4th so that the >> opening of the 4th holder equated to the size of the 35mm microfilm >> frame with it lying across the bed. I then scanned each frame, one at >> a time. .... > >I would have scanned several in one scan and then split the file up >later with a graphics program. I've been doing that with old photos. Yes but scanning photos uses the scanner light that scans the plattern from below whereas scanners with film and slide scanning capability, like mine, have a light built into the scanner lid directing light down through the film to the sensor below. I would have scanned several frames at once but the scanner lid hinge prevents the film from lying along the centre line of the lid containing the film scanning light and the supplied plastic frame has a cut-out near the hinge that has to be left open (where the film would otherwise lie across this opening). >I put as many as I can fit on the flatbed, scan to JPEG. Umm. I never scan "to" anything. I open my graphics program and then acquire an image from the scanner using its Twain driver interface. I then have the image in the application where I can manipulate, crop etc but up to the point where I Save As.. it's not any specific image type. >Load the big file into GraphicConverter, crop all but one picture, >enhance it and Save As... By first creating a .jpg file and then opening it in a "GraphicConverter" and then cropping etc and then using Save As you're saving twice as a .jpg which is NOT recommended unless you're using a lossless .jpg file system. >Then open the scanned file again and do another. No. What I do is have the scan in my application, crop to size then copy / paste to a 2nd image (for further manipulation if required and then save it) in the application and use undo on the original scan so it's back to how it was as scanned and then do the same thing again to another part of the multi photo scan. The key is NOT to save the final cut image more than once when using a normal (lossy) .jpg format. Finally remember that the .jpg compression level is variable allowing higher compression for sending a file by email for example compared to saving your own archive copy. -- Bob

Try creating a new column and copy and pasting into the new column just using "values" regards Bill ----- Original Message ----- From: "Himself" <himself@himself.com> Newsgroups: soc.genealogy.computing To: <gencmp@rootsweb.com> Sent: Friday, November 23, 2007 8:45 AM Subject: Excel problem >I am using Excel 2000 for a one name study project. > > Currently there are 3100 rows and 22 cols. > > Apart from one column all others sort in order. > > The column that will not sort correctly is the one with the forenames in > it. > > Currently I get, for example: > > John > John > John > John Albert > John Frederick > John George > John William > John > John > Jonathan > > > I have formatted all cells to Text > Justified the text to the left > > but still it will not sort in strict alpha order. > > The same file on other PCs using Excel 2003 and Open Office displays the > same problem, thus it is my file that is the issue. > > Some of the data was imported from screen captured data, so I wonder if > the spreadsheet has picked up some hidden coding that gives rise to the > issue. > > Ideas, anyone ? > > Thanks > > Keith > > > > ------------------------------- > To unsubscribe from the list, please send an email to > GENCMP-request@rootsweb.com with the word 'unsubscribe' without the quotes > in the subject and the body of the message

Robert G. Eldridge wrote: > I open my graphics program and then acquire an image from the scanner > using its Twain driver interface. I then have the image in the I used to do that, but what I use now can't do that. > By first creating a .jpg file and then opening it in a > "GraphicConverter" and then cropping etc and then using Save As you're > saving twice as a .jpg which is NOT recommended unless you're using a > lossless .jpg file system. With slides, you're probably right. With microfilm, I save as TIFF, and bring home for editing. But when I'm scanning an old photograph for web presentation, saving as JPEG (max quality) the first time, and 50% the second is usually more than adequate. -- Wes Groleau Promote multi-use trails in northeast Indiana! http://www.NorthwestAllenTrails.org/

Scripsit Dave Hinz: > you just need the film not contacting the glass or you get Newtons > Rings on the images. Not sure about film rolls, but I have places microfiche directly on the glass plate of my Canoscan and obtained quite good results with no Newtons Rings. My suggestion would be to just gently pull the film through, though you may have to scan just one frame at the time, as the film would have to go transversal in order to avoid the lid hinge. -- Med venlig hilsen Lars Erik Bryld

jesse mc wrote: > Hi folks, thanks for the response, quick 7 informative as usual. Kinda > thought I'd need a "slide scanner atch." I have a Lexmark flatbed > scanner/printer & am not sure I can use an atchment as many noted. Need > to check that out. For Dave, I live in Shawnee, OK USA. & would like to > hear about the slide atch you have. > jessemc roho29@allegiance.tv quick and nasty project on the wall and take a photo of the image Hugh W -- For genealogy and help with family and local history in Bristol and district http://groups.yahoo.com/group/Brycgstow/ http://snaps4.blogspot.com/ photographs and walks GENEALOGE http://hughw36.blogspot.com/ MAIN BLOG

Dave Hinz wrote: > On Tue, 20 Nov 2007 21:18:25 +0000 (UTC), Michael Zacherle <zacherle@szs.uni-karlsruhe.de> wrote: > >>Lesley Robertson <l.a.robertson@tnw.tudelft.nl> wrote: > > >>>My Canoscan doesn't use the perforations - but I do have to cut the film >>>into strips to fit the holder. I've scanned archival film (and entire set of > > >>I can't cut the film, unfortunately. Any ideas? > > > Nothing magic about the plastic film scanners, the purpose is to just > give a flat surface that holds the film just off the glass. Thin black > cardboard, cut as needed, works great. Even heavy construction paper, > you just need the film not contacting the glass or you get Newtons Rings > on the images. > thank you Dave fo0r the explanation Huh W -- For genealogy and help with family and local history in Bristol and district http://groups.yahoo.com/group/Brycgstow/ http://snaps4.blogspot.com/ photographs and walks GENEALOGE http://hughw36.blogspot.com/ MAIN BLOG