Hey Mark, Great to see you still lurking in this fantastic group.
All the best, Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mark Nepon Sent: Tuesday, August 11, 2009 6:40 PM To: [email protected] Subject: Re: [Dataperf] Extracting Words URGENT This formula works for 11 words or less in a field. If more needed just add the lines and endif's needed. It starts by searching for a word in the 11th and if exists shows it, If not, tests for ten words and displays the tenth and on and on. If any field contains more than 11 words the "oooppps" will display letting you know to add more lines.. if subfield[P7F4;" ";11]<>" " then subfield[P7F4;" ";11] else if subfield[P7F4;" ";10]<>" " then subfield[P7F4;" ";10] else if subfield[P7F4;" ";9]<>" " then subfield[P7F4;" ";9] else if subfield[P7F4;" ";8]<>" " then subfield[P7F4;" ";8] else if subfield[P7F4;" ";7]<>" " then subfield[P7F4;" ";7] else if subfield[P7F4;" ";6]<>" " then subfield[P7F4;" ";6] else if subfield[P7F4;" ";5]<>" " then subfield[P7F4;" ";5] else if subfield[P7F4;" ";4]<>" " then subfield[P7F4;" ";4] else if subfield[P7F4;" ";3]<>" " then subfield[P7F4;" ";3] else if subfield[P7F4;" ";2]<>" " then subfield[P7F4;" ";2] else if subfield[P7F4;" ";1]<>" " then subfield[P7F4;" ";1] else "Oooooops formula not big enough" endif endif endif endif endif endif endif endif endif endif endif mark ----- Original Message ----- From: <[email protected]> To: "'Dataperfect Users Discussion Group'" <[email protected]> Sent: Tuesday, August 11, 2009 1:51 PM Subject: [Dataperf] Extracting Words URGENT > Hi Everyone; > > I desperately need your expertise. I would like to make a formula in a > field (not in a report) that would automatically extract the last word of > another field, something like with a subfield or substring function or > whatever. The amount of words in that field are not identical. It can > vary between 2 and 10 or even more. > > Also, how would I extract all the words of a field besides the last > word or besides the first word? > > Malkie > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.50/2296 - Release Date: 08/11/09 06:10:00 _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
