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.
Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
