sed expression error

sed: -e expression #1, char 24: Invalid range end

by

While working on sed command stricken with this, error : “sed: -e expression #1, char 24: Invalid range end “). To solve this problem, we have used sed and tr command.

We made a bash script having expect command in it. We were passing variable value from my mysql database into the bash script.

The output which was coming from mysql was appearing like this —
sed expression error

The problem was coming because the sed command which we used was giving right output i.e 351 only in terminal.
But in my bash script variable it seems it was also taking some other unknown characters or spaces.

Here the plus(+) sign is a special character.

The solution come when we used the below tr command in our bash script. It has trimmed the special character from the output which we got from mysql command.

ID=`mysql -uUsername -pPASSWORDXXX -e "select id from databasename.tablename where name = ''linuxtribe"| sed -e 's/[!@#$%^&*()]//g'|sed '1d'|tr -cds "[:alnum:]" "[ ]"`

The troubleshooting which we did ,is not same with every such error.

Related posts:

  1. setfacl: Option -m: Invalid argument near character 3
  2. Convert new line to space by using sed command
  3. convert space into new line using sed command
  4. cat,sed and awk commands to display file contents
  5. sed : find the pattern (keyword) and delete the line from file
  6. remove html tags by using sed command
  7. sed command to display text between two strings or keywords
  8. Taking file backup while using sed command with -i flag
  9. How to print particular line number by using sed command
  10. sed : remove lines between two keywords [ including keywords ]

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.