note
neurotoxx
<p>
Thanks. The regex expressions work great. However, I have a couple more issues with the data. For example, I would like to replace only the spaces after the first element and before the last element. I need to keep the spaces that are part of the last name. For example:</p>
<code>
0211121253 Mike Dell ID06533
0211121253 Leo De Vinci ID02014
0211121253 Joe De La Marco ID65255
</code>
<p>
Should look like this:
</p>
<code>
0211121253|Mike|Dell|ID06533
0211121253|Leo|De Vinci|ID02014
0211121253|Joe|De La Marco|ID65255
</code>
<p>
Also, I would like it to delete any lines that are missing field elements.
</p><code>
0211121253|Mike|Dell|ID06533
Missing data|Leo|De Vinci|ID02014 <--delete line
0211121253|Joe|De La Marco|ID65255
</code>
<p>
I have been trying to create a regex that keys on "ID" and replaces the space before it. I've been trying these:
</p>
<code>
$_ =~\b\sID\d;
$_ =~^\d+;
</code>
<p>
But these expressions replace instead of add the pipe.
</p>
<p>
I would really appreciate a way to add the pipes and not replace the search value in the regex.
</p><p>
Thank you so much for your help,
</p>
vince
778727
778734