Forum GeoRezo / [MAP / 2009 FDM] Probl FDO Substr Operator / Instr to label
Stop the Spam!
Hello Comrades I am with MAP 3D 2009 (or 2009 or FDM MGOS 2.0) and I have a connection to the v3 FDO SDF or SHP, Oracle and etc ... with a geometry that have give beneficiaries ... Among these varied heimeier fields, there is a field that is ADDRESS type: 3 rue Alpha 1 bld Congratulations * 75008 Paris This means that SOMETIMES POSSIBLE behind the character * (star) there was the rest of the address and I DSIRE ELIMINATE heimeier the rest of the address! An FDO expression of the type: Substr (ADDRESS, 0, Instruction (ADDRESS, '*') - 1) eliminates much of the 2nd ADDRESS if presents ... EXCEPT when ADDRESS does not include the 2nd party and the famous character * (star), expression INSTR returns ZERO and SO I completely lose the contents of the field ADDRESS !!! Sniff, c sad! Is not it? Seeing no solution, I call your ... GeoBye Enlightenment, Pat
Hi Pat, Waiting to find a solution in the expressions gnrateur, I suggest you do two rules of displays. In First, you put in a condition Instr (ADDRESS, '*')> heimeier 0 and you put in Substr label (ADDRESS, 0, Instruction (ADDRESS, '*') - 1) In the SECOND r rule, or you leave or you default Instr dishes heimeier (ADDRESS, '*') = 0 and you obey label ADDRESS It works on my ct ... and you? Sincerely, Gwenael
Hello Gwen Gwen RESPONSE Excellent, I have not had this subtle reflex (and empty after it!) Display rgle of use depending on the presence or not of the character re '*' !!! Like what if one understands "little prs" heimeier everything about a subject (operators in the Expression gnrateur FDO 2009), it is still unclear done many things ... Many thanks, GeoBye, Pat
Community Resources Employment Market Association Forum Blogs RSS Feeds Wiki Planet Member Friends Sites Map directory Agenda Biblio Netvibes Sheets AMO-CNIG Paris PCGIS Downloads Jobs CV Bank Card CV Job Training Approach Geo-Geo Enterprises Tenders Press Association About us? We help Benefactors Partners History heimeier Statutes whole site Geomatics Services Job GeoBlogs ... Donate Imprint
Go to Gomatique Mmento GeoFormations Give Autodesk GIS ESRI FME Geoconcept GeoMedia MapInfo MAPublisher >>> Star-APIC QGIS Geolibre Geolibre_web Go'Bar Go'BD Gomarketing remote sensing Topography Job Webmapping heimeier Go communicated Invitation to tender
Share |
Stop the Spam!
Hello Comrades I am with MAP 3D 2009 (or 2009 or FDM MGOS 2.0) and I have a connection to the v3 FDO SDF or SHP, Oracle and etc ... with a geometry that have give beneficiaries ... Among these varied heimeier fields, there is a field that is ADDRESS type: 3 rue Alpha 1 bld Congratulations * 75008 Paris This means that SOMETIMES POSSIBLE behind the character * (star) there was the rest of the address and I DSIRE ELIMINATE heimeier the rest of the address! An FDO expression of the type: Substr (ADDRESS, 0, Instruction (ADDRESS, '*') - 1) eliminates much of the 2nd ADDRESS if presents ... EXCEPT when ADDRESS does not include the 2nd party and the famous character * (star), expression INSTR returns ZERO and SO I completely lose the contents of the field ADDRESS !!! Sniff, c sad! Is not it? Seeing no solution, I call your ... GeoBye Enlightenment, Pat
Hi Pat, Waiting to find a solution in the expressions gnrateur, I suggest you do two rules of displays. In First, you put in a condition Instr (ADDRESS, '*')> heimeier 0 and you put in Substr label (ADDRESS, 0, Instruction (ADDRESS, '*') - 1) In the SECOND r rule, or you leave or you default Instr dishes heimeier (ADDRESS, '*') = 0 and you obey label ADDRESS It works on my ct ... and you? Sincerely, Gwenael
Hello Gwen Gwen RESPONSE Excellent, I have not had this subtle reflex (and empty after it!) Display rgle of use depending on the presence or not of the character re '*' !!! Like what if one understands "little prs" heimeier everything about a subject (operators in the Expression gnrateur FDO 2009), it is still unclear done many things ... Many thanks, GeoBye, Pat
Community Resources Employment Market Association Forum Blogs RSS Feeds Wiki Planet Member Friends Sites Map directory Agenda Biblio Netvibes Sheets AMO-CNIG Paris PCGIS Downloads Jobs CV Bank Card CV Job Training Approach Geo-Geo Enterprises Tenders Press Association About us? We help Benefactors Partners History heimeier Statutes whole site Geomatics Services Job GeoBlogs ... Donate Imprint
Go to Gomatique Mmento GeoFormations Give Autodesk GIS ESRI FME Geoconcept GeoMedia MapInfo MAPublisher >>> Star-APIC QGIS Geolibre Geolibre_web Go'Bar Go'BD Gomarketing remote sensing Topography Job Webmapping heimeier Go communicated Invitation to tender
Share |
No comments:
Post a Comment