topic Trim Trailing space in popup maybe by using SQL in definitionexpression? in ArcGIS Viewer for Flex Questions https://community.esri.com/t5/arcgis-viewer-for-flex-questions/trim-trailing-space-in-popup-maybe-by-using-sql-in/m-p/425200#M12071 <HTML><HEAD></HEAD><BODY><SPAN>I'm wondering if there is a way to trim the trailing whitespace for a field in a mapservice for use in a popup.&nbsp; The example is shown below, I am displaying a service hosted by esri that displays health care facilities nationwide and I have formatted a popup to display the address by adding the fields in the appropriate order to the &lt;![CDATA]/&gt; tag.&nbsp; However, the city field has several trailing spaces that I'd like to get rid of.&nbsp; How can I do it?</SPAN><BR /><BR /><SPAN>I tried to use a definitionexpression with the SQL TRIM() function on the appropriate sublayer to no avail.&nbsp; Can anyone point me in the right direction?</SPAN><BR /><BR /><SPAN>I'm including a screenshot of the example, the layer tag for the main config file and the popup.xml</SPAN><BR /><BR /><SPAN>layer tag</SPAN><BR /><BR /><PRE class="plain" name="code">&nbsp; &lt;layer label="Nationwide Hospitals" type="dynamic" visible="true" alpha="1" visiblelayers="6,12,18" &nbsp;&nbsp; url="http://maps3.arcgisonline.com/ArcGIS/rest/services/A-16/HHS_IOM_Health_Resources/MapServer"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sublayer id="6" popupconfig="popups/popup_ESRI_WOL_HealthHomeServices.xml" definitionexpression="ARC_City = TRIM(BOTH ' ' FROM ARC_City)"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sublayer id="12" popupconfig="popups/popup_ESRI_WOL_HealthHomeServices.xml" definitionexpression="ARC_City = TRIM(BOTH ' ' FROM ARC_City)"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sublayer id="18" popupconfig="popups/popup_ESRI_WOL_HealthHomeServices.xml" definitionexpression="ARC_City = TRIM(BOTH ' ' FROM ARC_City)"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/layer&gt;</PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>popup</SPAN><BR /><BR /><PRE class="plain" name="code">&lt;?xml version="1.0" ?&gt; &lt;configuration&gt; &nbsp;&nbsp;&nbsp; &lt;title&gt;Health Home Services:&nbsp; {ProviderName}&lt;/title&gt; &nbsp;&nbsp;&nbsp; &lt;description&gt; &lt;![CDATA[Health Home Services Number:&nbsp;&nbsp;&nbsp; {ProviderNum}&lt;br&gt;Address:&nbsp;&nbsp;&nbsp; {ARC_Address}&lt;br&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {ARC_City}, {ARC_State} {ARC_Zip}&lt;br&gt;Phone Number:&nbsp; {Telephone}&lt;br&gt;Date Certified:&nbsp; {DateCertified}&lt;br&gt;Ownership:&nbsp; {OwnershipType}]]&gt; &nbsp;&nbsp;&nbsp;&nbsp; &lt;/description&gt;&nbsp; &lt;fields&gt; &lt;/fields&gt; &lt;/configuration&gt;</PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>Jeremy</SPAN></BODY></HTML> Wed, 28 Sep 2011 18:21:49 GMT CharlesHarris 2011-09-28T18:21:49Z Trim Trailing space in popup maybe by using SQL in definitionexpression? https://community.esri.com/t5/arcgis-viewer-for-flex-questions/trim-trailing-space-in-popup-maybe-by-using-sql-in/m-p/425200#M12071 <HTML><HEAD></HEAD><BODY><SPAN>I'm wondering if there is a way to trim the trailing whitespace for a field in a mapservice for use in a popup.&nbsp; The example is shown below, I am displaying a service hosted by esri that displays health care facilities nationwide and I have formatted a popup to display the address by adding the fields in the appropriate order to the &lt;![CDATA]/&gt; tag.&nbsp; However, the city field has several trailing spaces that I'd like to get rid of.&nbsp; How can I do it?</SPAN><BR /><BR /><SPAN>I tried to use a definitionexpression with the SQL TRIM() function on the appropriate sublayer to no avail.&nbsp; Can anyone point me in the right direction?</SPAN><BR /><BR /><SPAN>I'm including a screenshot of the example, the layer tag for the main config file and the popup.xml</SPAN><BR /><BR /><SPAN>layer tag</SPAN><BR /><BR /><PRE class="plain" name="code">&nbsp; &lt;layer label="Nationwide Hospitals" type="dynamic" visible="true" alpha="1" visiblelayers="6,12,18" &nbsp;&nbsp; url="http://maps3.arcgisonline.com/ArcGIS/rest/services/A-16/HHS_IOM_Health_Resources/MapServer"&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sublayer id="6" popupconfig="popups/popup_ESRI_WOL_HealthHomeServices.xml" definitionexpression="ARC_City = TRIM(BOTH ' ' FROM ARC_City)"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sublayer id="12" popupconfig="popups/popup_ESRI_WOL_HealthHomeServices.xml" definitionexpression="ARC_City = TRIM(BOTH ' ' FROM ARC_City)"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;sublayer id="18" popupconfig="popups/popup_ESRI_WOL_HealthHomeServices.xml" definitionexpression="ARC_City = TRIM(BOTH ' ' FROM ARC_City)"/&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/layer&gt;</PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>popup</SPAN><BR /><BR /><PRE class="plain" name="code">&lt;?xml version="1.0" ?&gt; &lt;configuration&gt; &nbsp;&nbsp;&nbsp; &lt;title&gt;Health Home Services:&nbsp; {ProviderName}&lt;/title&gt; &nbsp;&nbsp;&nbsp; &lt;description&gt; &lt;![CDATA[Health Home Services Number:&nbsp;&nbsp;&nbsp; {ProviderNum}&lt;br&gt;Address:&nbsp;&nbsp;&nbsp; {ARC_Address}&lt;br&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {ARC_City}, {ARC_State} {ARC_Zip}&lt;br&gt;Phone Number:&nbsp; {Telephone}&lt;br&gt;Date Certified:&nbsp; {DateCertified}&lt;br&gt;Ownership:&nbsp; {OwnershipType}]]&gt; &nbsp;&nbsp;&nbsp;&nbsp; &lt;/description&gt;&nbsp; &lt;fields&gt; &lt;/fields&gt; &lt;/configuration&gt;</PRE><DIV style="display:none;"> </DIV><BR /><BR /><SPAN>Jeremy</SPAN></BODY></HTML> Wed, 28 Sep 2011 18:21:49 GMT https://community.esri.com/t5/arcgis-viewer-for-flex-questions/trim-trailing-space-in-popup-maybe-by-using-sql-in/m-p/425200#M12071 CharlesHarris 2011-09-28T18:21:49Z