if substring[PxFx;50;1] >= "1" and substring[PxFx;50;1] <= 9" and substring[PxFx;49;1] = " " then substring[PxFx;50;1] else if substring[PxFx;49;1] >= "1" and substring[PxFx;49;1] <= 9" and substring[PxFx;48;1] = " " then substring[PxFx;49;2] else
start from the end, work towards the beginning. remember that the numbers are text entries. got it? Don 2010/12/6 Helmuth E. Günther <[email protected]> > Hi, > > > > My intention: in a report to separate the content of a field into two parts > if the last part of the field is a numeric value. > > > > The field street A50;;N;;T contains the street and the house no. > > > > Examples: > > > > Main Road 5 > > Alexander Guido Place 7 > > City 2 > > Piazza > > City Yard > > > > As the examples show, not each entry contains a house number. So my > intention is to find the number of spaces and check if the last part (n-1) > is a numeric value. If this is true then separate the content of the field > into two parts e.g. field “street” and field “house no”. > > > > A appreciate any hint or any help! > > > > First: how to find the number of spaces? > > Second: how to check if the value of the last part of the content is > numeric? > > > > Best Regards > > > > Helmuth E. Günther > > > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > > -- 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
