"Paul Kraus" <[EMAIL PROTECTED]> wrote in message 007001c2cba0$2a952ae0$8afea8c0@pkraus">news:007001c2cba0$2a952ae0$8afea8c0@pkraus... > Nope I wish. > > 3 fields. 1 is a part number, 2 is cost, 3 is list. > I am removing the '$' for 2 and 3. where as I am removing white space > from 1,2,&3. > I was just trying to do it all in one statement.
Ah, I see. Leading or trailing whitespace or a (leading?) dollar. > Frank Wiles solution worked perfectly. > s/(?:^\s+|\$+|\s+$)//g Great. Except that the clustering isn't necessary. s/^\s+|\$+|\s+$//g does the same thing. Or even: s/^[\s$]+|\s+$//g which removes only leading dollars, rather than dollars anywhere in the string. I doubt if it matters though :) Rob -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]