Re: All special character substitution and/or drop from column names.

You're getting the occasional underscore because you include one in the replacement chars. Try changing tr/.../_/d to tr/...//d

Dave.

Comment on Re: All special character substitution and/or drop from column names. Select or Download Code

Replies are listed 'Best First'.
Re^2: All special character substitution and/or drop from column names. by paulu (Initiate) on Feb 24, 2005 at 14:24 UTC
The _ was to replace the spaces. However in a "Name & Something Else" I ended up with "Name__Something_Else".	[reply]
Re^3: All special character substitution and/or drop from column names. by dave_the_m (Monsignor) on Feb 24, 2005 at 15:38 UTC
Ah sorry, I didn't notice the double underscore. In that case, as other people have pointed out, the /s option is the way to go: `$ perl -le'$_="Name & Something Else"; tr/ &/_/sd; print' Name_Something_Else` [download] Dave.	[reply] [d/l]