<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Use attribute rules to block invalid characters in at text field. in Geodatabase Questions</title>
    <link>https://community.esri.com/t5/geodatabase-questions/use-attribute-rules-to-block-invalid-characters-in/m-p/843716#M4850</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm working with a point layer for addresses that will be exported to a CSV file, once it is complete.&amp;nbsp; I have set up &lt;EM&gt;Attribute Rules &lt;/EM&gt;on the &lt;EM&gt;Constraints&lt;/EM&gt; tab&amp;nbsp;to find invalid characters, those characters which were not allowed in the address field.&amp;nbsp; I have created 18 different rules in order to catch all of the invalid characters and just replaced the &lt;SPAN style="color: #ff0000;"&gt;'$'&amp;nbsp;&lt;SPAN style="color: #000000;"&gt;in the expression below with the appropriate invalid character, which are &lt;SPAN style="color: #ff0000;"&gt;$ % + - ^ &amp;amp; * ( ) ? / ' " : ; } { ] {&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;My expression is;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Find(&lt;SPAN style="color: #ff0000;"&gt;'$'&lt;/SPAN&gt;, $feature.Address)&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is there a way to write only one Arcade expression that will find all of the invalid characters instead of the 18 I have now?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 18 Feb 2020 16:33:22 GMT</pubDate>
    <dc:creator>JeffJensen3</dc:creator>
    <dc:date>2020-02-18T16:33:22Z</dc:date>
    <item>
      <title>Use attribute rules to block invalid characters in at text field.</title>
      <link>https://community.esri.com/t5/geodatabase-questions/use-attribute-rules-to-block-invalid-characters-in/m-p/843716#M4850</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm working with a point layer for addresses that will be exported to a CSV file, once it is complete.&amp;nbsp; I have set up &lt;EM&gt;Attribute Rules &lt;/EM&gt;on the &lt;EM&gt;Constraints&lt;/EM&gt; tab&amp;nbsp;to find invalid characters, those characters which were not allowed in the address field.&amp;nbsp; I have created 18 different rules in order to catch all of the invalid characters and just replaced the &lt;SPAN style="color: #ff0000;"&gt;'$'&amp;nbsp;&lt;SPAN style="color: #000000;"&gt;in the expression below with the appropriate invalid character, which are &lt;SPAN style="color: #ff0000;"&gt;$ % + - ^ &amp;amp; * ( ) ? / ' " : ; } { ] {&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;My expression is;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Find(&lt;SPAN style="color: #ff0000;"&gt;'$'&lt;/SPAN&gt;, $feature.Address)&lt;/EM&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is there a way to write only one Arcade expression that will find all of the invalid characters instead of the 18 I have now?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 18 Feb 2020 16:33:22 GMT</pubDate>
      <guid>https://community.esri.com/t5/geodatabase-questions/use-attribute-rules-to-block-invalid-characters-in/m-p/843716#M4850</guid>
      <dc:creator>JeffJensen3</dc:creator>
      <dc:date>2020-02-18T16:33:22Z</dc:date>
    </item>
  </channel>
</rss>

