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
