title: How to parse a specific column or data without losing content from other columns/rows after parsing?
body: <p>I have the following output to grep the value in this case &quot;225&quot;. This value is actually a variable $pd so it could change depending on users input&quot; It could be integer numbers or an alphanumeric character case-insensitive exact match. Example if value of variable is &quot;225&quot; then a &quot;0225&quot; or &quot;11225&quot; its not a valid output from the file Im reading it.</p>
  <pre><code>Input File:
  10.20.223.10|2000-H1|1/1/2|DeviceX_4021|LG
  10.20.223.10|2000-H1|1/1/3|Undiscoverable|Unkwn
  10.20.225.10|2000-H1|1/1/5|DeviceZ_2050|LG
  10.20.223.10|2000-H1|1/1/8|DeviceY_225_|Kenmore
  10.20.223.10|2000-H1|1/1/8|DeviceY_01225_|Kenmore
  10.20.225.10|2000-H1|1/1/8|DeviceY_2250_|Kenmore
  
  Desired Output File:
  10.20.223.10|2000-H1|1/1/8|DeviceY_225_|Kenmore
  
  If user input is &quot;lg&quot;; then it should output the line without not ignoring it because the input file has &quot;lg&quot; in uppercase. (This part is already fixed on the script).
  
  Desired Output:
  10.20.223.10|2000-H1|1/1/2|DeviceX_4021|LG
  10.20.225.10|2000-H1|1/1/5|DeviceZ_2050|LG
  
  </code></pre>