Helmuth, Is this for a one-time data conversion or is this something that will need to happen on a regular basis?
If it's just a one-time conversion, I would export all of the data to a CSV file and convert it using some other program such as MS Excel. Then import it back into DP. Otherwise you could probably write a DP report to convert the data, using the subfield[] function and virtual subreports to simulate looping through the address words. Do-able, but a real pain. DP's string manipulation routines have never been particularly impressive. Tim Rude ----- Original Message ----- From: Helmuth E. Günther To: [email protected] Sent: Monday, December 06, 2010 2:47 PM Subject: [Dataperf] separate street and house no 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
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
