|Problems? Is your data what you think it is?|
Re^2: parse array to replace specific spaces with pipesby neurotoxx (Novice)
|on Jul 12, 2009 at 21:23 UTC||Need Help??|
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:
Should look like this:
Also, I would like it to delete any lines that are missing field elements.
I have been trying to create a regex that keys on "ID" and replaces the space before it. I've been trying these:
But these expressions replace instead of add the pipe.
I would really appreciate a way to add the pipes and not replace the search value in the regex.
Thank you so much for your help,vince