Hi Don; First of all thank you for responding. The field containing the text is A45. Searching for the first word of a field is simple: subfield[P1F1;' ';1] but what is the formula for extracting the last word of the field?
Malkie > Malkie - I don't know if my response is the best approach but if I > were pressed to do this the first thing I'd need to know is what kind > of field I'm pulling the data from - a fixed size field or a variable > text field. In some fashion you have to be able to determine where the > entry ends and work backwards from there. > > What is the format of the field and if it's a variable text field I'm > flummoxed. > > If it's a standard fixed data field then I'd start testing each > position starting at the right looking for the last letter of the last > entry and once known, looking for the next space to the left and > assuming that once that space is found then the letters in between it > and the space after the last letter is the last word. > > Don > > -- > Don Friedman > ProfessionalRecords.Com LLC > PRS Data Systems > 205 S Main Street > Pittsburgh, PA 15215 > 412-784-1600 - 1-800-PRS-FILE > 412-784-1615 Fax > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
