in reply to Re: All special character substitution and/or drop from column names.
in thread All special character substitution and/or drop from column names.

The _ was to replace the spaces. However in a "Name & Something Else" I ended up with "Name__Something_Else".
  • Comment on Re^2: All special character substitution and/or drop from column names.

Replies are listed 'Best First'.
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

    Dave.