title: How to change a string delimiter in Ab Initio?
body: <p>In Ab Initio graph I have an input file which has pipe-delimited values in rows. I use similar DML file to parse it:</p>
  
  <pre><code>record
    decimal("|",0, maximum_length=19, sign_reserved) v1 = NULL("");
    utf8 string("|", maximum_length=10) v2 = "";
    utf8 string("|", maximum_length=10) v3 = "";
    utf8 string("|", maximum_length=40) v4 = "";
    utf8 string("|", maximum_length=255) v5 = "";
    utf8 string("\n", maximum_length=40) v6 = "";
  end
  </code></pre>
  
  <p>For use in later equality comparisons with other data I want to make all those strings pipe-delimited, so I need to change v6 value.</p>
  
  <p>I tried do it with simple Reformat by changing output DML to this one, and leaving the transform function empty:</p>
  
  <pre><code>record
    decimal("|",0, maximum_length=19, sign_reserved) v1 = NULL(""); 
    utf8 string("|", maximum_length=10) v2 = "";
    utf8 string("|", maximum_length=10) v3 = "";
    utf8 string("|", maximum_length=40) v4 = "";
    utf8 string("|", maximum_length=255) v5 = "";
    utf8 string("|", maximum_length=40) v6 = "";
    string(1) newline = "\n";
  end
  </code></pre>
  
  <p>However, this left trash character inside v6. Later I needed to filter v6 value to make it only contain proper characters. This solution doesn't seem neat.</p>
  
  <p>To avoid this trash left inside v6 I tried to use reinterpret_as, string_concat and others but nothing ended up with a nice solution.
  How should I change the delimiter of v6 in a simple way?</p>