<?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 How to create regex that indexes time masking maintaining string length vol. III in Getting Data In</title>
    <link>https://community.splunk.com/t5/Getting-Data-In/How-to-create-regex-that-indexes-time-masking-maintaining-string/m-p/591789#M103619</link>
    <description>&lt;P&gt;Hi all,&lt;BR /&gt;as in the previous posts &lt;A href="https://community.splunk.com/t5/Getting-Data-In/Index-time-masking-maintaining-string-length/td-p/514705" target="_self"&gt;I&lt;/A&gt;&amp;nbsp;and &lt;A href="https://community.splunk.com/t5/Getting-Data-In/Index-time-masking-maintaining-string-length-continue/m-p/514890#M87226" target="_self"&gt;II&lt;/A&gt;&amp;nbsp;I'd like to anonymize names of cities and to keep the length of a string.&lt;BR /&gt;The nature of logs is quite complex. I'm sharing the part in question:&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;2022-03-31&lt;/SPAN&gt; &lt;SPAN class=""&gt;15:23:11&lt;/SPAN&gt;&lt;SPAN&gt;,&lt;/SPAN&gt;&lt;SPAN class=""&gt;210&lt;/SPAN&gt; &lt;SPAN class=""&gt;INFO&lt;/SPAN&gt;&amp;nbsp;...&lt;BR /&gt;&amp;nbsp;&lt;SPAN class=""&gt;-&lt;/SPAN&gt; &lt;SPAN class=""&gt;...&lt;/SPAN&gt; &lt;SPAN class=""&gt;381&lt;/SPAN&gt; &lt;SPAN class=""&gt;lines&lt;/SPAN&gt; &lt;SPAN class=""&gt;omitted&lt;/SPAN&gt; &lt;SPAN class=""&gt;...&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_AUSWEISENDE=12.02.2022&lt;/SPAN&gt;&amp;nbsp;&lt;BR /&gt;&lt;SPAN class=""&gt;F_AUSWEISNUMMER=A2A2A2AAA&lt;BR /&gt;&lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;F_BEHOERDE&lt;/SPAN&gt;=Berlin&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_BV_FREITEXTANTRAG=&lt;/SPAN&gt;&lt;SPAN&gt; ---------------&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;What I'd like to get is:&lt;/P&gt;
&lt;P&gt;&lt;SPAN class=""&gt;2022-03-31&lt;/SPAN&gt; &lt;SPAN class=""&gt;15:23:11&lt;/SPAN&gt;&lt;SPAN&gt;,&lt;/SPAN&gt;&lt;SPAN class=""&gt;210&lt;/SPAN&gt; &lt;SPAN class=""&gt;INFO&lt;/SPAN&gt;&amp;nbsp;...&lt;BR /&gt;&amp;nbsp;&lt;SPAN class=""&gt;-&lt;/SPAN&gt; &lt;SPAN class=""&gt;...&lt;/SPAN&gt; &lt;SPAN class=""&gt;381&lt;/SPAN&gt; &lt;SPAN class=""&gt;lines&lt;/SPAN&gt; &lt;SPAN class=""&gt;omitted&lt;/SPAN&gt; &lt;SPAN class=""&gt;...&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_AUSWEISENDE=12.02.2022&lt;/SPAN&gt;&amp;nbsp;&lt;BR /&gt;&lt;SPAN class=""&gt;F_AUSWEISNUMMER=A2A2A2AAA&lt;BR /&gt;&lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;F_BEHOERDE&lt;/SPAN&gt;=XXXXXX&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_BV_FREITEXTANTRAG=&lt;/SPAN&gt;&lt;SPAN&gt; ---------------&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Sometimes, unfortunately, the names are more complex and include processing errors:&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;F_BEHOERDE&lt;/SPAN&gt;=Stadt&lt;/SPAN&gt; &lt;SPAN class=""&gt;Rastatt&lt;/SPAN&gt; &lt;SPAN class=""&gt;B\xFCrgerb\xFCro&lt;BR /&gt;&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;SPAN class=""&gt;then I'd like to get:&lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN class=""&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_BEHOERDE&lt;/SPAN&gt;=XXXXX&amp;nbsp;XXXXXXX XXXXXXXXXXXXXXXX&lt;BR /&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;SPAN class=""&gt;I've managed to create the regex which anonymizes city names but doesn't keep the length of them. If the dynamic version is not possible. Probably I will need to stick with this:&lt;/SPAN&gt;&lt;/P&gt;
&lt;PRE&gt;&lt;SPAN class=""&gt;s/F_BEHOERDE=.*/F_BEHOERDE=XXXXX/g&lt;/SPAN&gt;&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;I'll be grateful for any hints&lt;/P&gt;</description>
    <pubDate>Thu, 31 Mar 2022 16:55:29 GMT</pubDate>
    <dc:creator>bruncio</dc:creator>
    <dc:date>2022-03-31T16:55:29Z</dc:date>
    <item>
      <title>How to create regex that indexes time masking maintaining string length vol. III</title>
      <link>https://community.splunk.com/t5/Getting-Data-In/How-to-create-regex-that-indexes-time-masking-maintaining-string/m-p/591789#M103619</link>
      <description>&lt;P&gt;Hi all,&lt;BR /&gt;as in the previous posts &lt;A href="https://community.splunk.com/t5/Getting-Data-In/Index-time-masking-maintaining-string-length/td-p/514705" target="_self"&gt;I&lt;/A&gt;&amp;nbsp;and &lt;A href="https://community.splunk.com/t5/Getting-Data-In/Index-time-masking-maintaining-string-length-continue/m-p/514890#M87226" target="_self"&gt;II&lt;/A&gt;&amp;nbsp;I'd like to anonymize names of cities and to keep the length of a string.&lt;BR /&gt;The nature of logs is quite complex. I'm sharing the part in question:&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;2022-03-31&lt;/SPAN&gt; &lt;SPAN class=""&gt;15:23:11&lt;/SPAN&gt;&lt;SPAN&gt;,&lt;/SPAN&gt;&lt;SPAN class=""&gt;210&lt;/SPAN&gt; &lt;SPAN class=""&gt;INFO&lt;/SPAN&gt;&amp;nbsp;...&lt;BR /&gt;&amp;nbsp;&lt;SPAN class=""&gt;-&lt;/SPAN&gt; &lt;SPAN class=""&gt;...&lt;/SPAN&gt; &lt;SPAN class=""&gt;381&lt;/SPAN&gt; &lt;SPAN class=""&gt;lines&lt;/SPAN&gt; &lt;SPAN class=""&gt;omitted&lt;/SPAN&gt; &lt;SPAN class=""&gt;...&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_AUSWEISENDE=12.02.2022&lt;/SPAN&gt;&amp;nbsp;&lt;BR /&gt;&lt;SPAN class=""&gt;F_AUSWEISNUMMER=A2A2A2AAA&lt;BR /&gt;&lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;F_BEHOERDE&lt;/SPAN&gt;=Berlin&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_BV_FREITEXTANTRAG=&lt;/SPAN&gt;&lt;SPAN&gt; ---------------&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;What I'd like to get is:&lt;/P&gt;
&lt;P&gt;&lt;SPAN class=""&gt;2022-03-31&lt;/SPAN&gt; &lt;SPAN class=""&gt;15:23:11&lt;/SPAN&gt;&lt;SPAN&gt;,&lt;/SPAN&gt;&lt;SPAN class=""&gt;210&lt;/SPAN&gt; &lt;SPAN class=""&gt;INFO&lt;/SPAN&gt;&amp;nbsp;...&lt;BR /&gt;&amp;nbsp;&lt;SPAN class=""&gt;-&lt;/SPAN&gt; &lt;SPAN class=""&gt;...&lt;/SPAN&gt; &lt;SPAN class=""&gt;381&lt;/SPAN&gt; &lt;SPAN class=""&gt;lines&lt;/SPAN&gt; &lt;SPAN class=""&gt;omitted&lt;/SPAN&gt; &lt;SPAN class=""&gt;...&lt;/SPAN&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_AUSWEISENDE=12.02.2022&lt;/SPAN&gt;&amp;nbsp;&lt;BR /&gt;&lt;SPAN class=""&gt;F_AUSWEISNUMMER=A2A2A2AAA&lt;BR /&gt;&lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;F_BEHOERDE&lt;/SPAN&gt;=XXXXXX&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_BV_FREITEXTANTRAG=&lt;/SPAN&gt;&lt;SPAN&gt; ---------------&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Sometimes, unfortunately, the names are more complex and include processing errors:&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;F_BEHOERDE&lt;/SPAN&gt;=Stadt&lt;/SPAN&gt; &lt;SPAN class=""&gt;Rastatt&lt;/SPAN&gt; &lt;SPAN class=""&gt;B\xFCrgerb\xFCro&lt;BR /&gt;&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;SPAN class=""&gt;then I'd like to get:&lt;/SPAN&gt;&lt;STRONG&gt;&lt;SPAN class=""&gt;&lt;BR /&gt;&lt;SPAN class=""&gt;F_BEHOERDE&lt;/SPAN&gt;=XXXXX&amp;nbsp;XXXXXXX XXXXXXXXXXXXXXXX&lt;BR /&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;SPAN class=""&gt;I've managed to create the regex which anonymizes city names but doesn't keep the length of them. If the dynamic version is not possible. Probably I will need to stick with this:&lt;/SPAN&gt;&lt;/P&gt;
&lt;PRE&gt;&lt;SPAN class=""&gt;s/F_BEHOERDE=.*/F_BEHOERDE=XXXXX/g&lt;/SPAN&gt;&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;I'll be grateful for any hints&lt;/P&gt;</description>
      <pubDate>Thu, 31 Mar 2022 16:55:29 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Getting-Data-In/How-to-create-regex-that-indexes-time-masking-maintaining-string/m-p/591789#M103619</guid>
      <dc:creator>bruncio</dc:creator>
      <dc:date>2022-03-31T16:55:29Z</dc:date>
    </item>
  </channel>
</rss>

