How to set sed command correctly

Question

When I try following command, I'd like to rewrite sql.

Day='2020/12/1'
Dir=/home/test/data


sql=`cat $Dir"/"$test".sql" | sed -e "s/Day/$Day/g"`

I suffered following errors.

sed: -e expression #1, char 24: unknown option to `s'

Why the s is recognised as option ? why is this command couldnt work well ?

if someone has opinoin, please let me know

Thanks

Does this answer your question? [Using different delimiters in sed commands and range addresses](https://stackoverflow.com/questions/5864146/using-different-delimiters-in-sed-commands-and-range-addresses) — Wiktor Stribiżew, Jan 19 '21 at 08:52

score 0 · Answer 1 · answered Jan 19 '21 at 08:48

The problem is with slashes: your variable contains them and the final command will be something like sed "s/string/path/to/something/g", containing way too many slashes.

Since sed can take any char as delimiter (without having to declare the new delimiter), you can try using another one that doesn't appear in your replacement string like below:

sql=`cat $Dir"/"$test".sql" | sed -e "s|Day|$Day|g"`

Also, you would need to use sed -i to update the file in-place, since it looks like that is what you're trying to do.

There is no need to use cat here. Simply add the path to the file at the end of the sed command, — Raman Sailopal, Jan 19 '21 at 09:42

How to set sed command correctly

1 Answers1