Tim,
Thank you very much. Well I dont know yet, if it will be a one-time conversion. The report will be used in a Navigon gps system. Well I keep all data in DP. At present I export the addresses and import these into Outlook. The rest is done by a synch program from Navigon. It works, but isnt very smart. Except of the street issue, my report is finished. Maybe there will be a smart solution? I didnt give up so far. Best Reards Helmuth E. Günther _____ Von: [email protected] [mailto:[email protected]] Im Auftrag von Tim Rude Gesendet: Montag, 6. Dezember 2010 22:32 An: [email protected] Betreff: Re: [Dataperf] separate street and house no 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 <mailto:[email protected]> 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
