Gene Young wrote: > Peter Simpson wrote: > >> Time to see if this forum can crack a problem. >> A number of our user group have been for too long trying every means >> possible to achieve what we believed should be the simplest of tasks. >> Finally one of our group enquired to Legacy tech support and received a >> confusing response. >> In order to achieve some major ongoing data management solutions for a >> very large body of research we have need to generate a txt file of every >> name in the legacy database. >> What is seen on the screen everytime you click the name list icon in Legacy, >> that being 1st column rin, 2nd column surname and given names followed by >> the short date (ie years only - we can live with blanks, bef and abt) in >> brackets is exactly what we need. >> We cannot understand that if Legacy can generate internally a window that >> has the precise data displayed in the absolute & exact form needed, why we >> cannot print that out nor save same in the csv form available from which we >> can so easily convert to txt ourselves. >> What are we all missing please? >> Any help appreciated. >> Peter Simpson >> >> >> > > I might have misunderstood but I created a csv file from the names list and loaded into a spreadsheet to see what I got. If you only want the four digit year from the born column where place of birth etc is added a bit of 'if'ing with strings should extract the four digit year. Basically discard anything after and including the comma then take the righthand four digits.
Better still. Alternatively keep everything to the left of the first comma, then take the righthand four digits Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergr...@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
