How can I replace string in KSH file from a sql file?

Question

Here is my code in ksh file

current_year=$(date +%Y)
current_month=$(date +%m)
sql=$(cat $script_path | sed -i 's/&1/current_year/g' | sed -i 's/&2/current_month/g')

Fisrt, I cat a sql file in KSH file and then I want the a string called "&1" and "&2" in sql file are replaced by current_year and current_month. But it doesn't work, hope I can find a solution here, thanks very much.

The reason I did that is I don't want to pass the parameter to sql file from ksh file, I just want a simple way to replace the string in ksh file.

James Risner · Accepted Answer · 2022-09-13 18:47:20Z

1

I changed your script to:

script_path=script.txt

current_year=$(date +%Y)
current_month=$(date +%m)
sql=$(sed -e "s/\&1/${current_year}/g" \
    -e "s/\&2/${current_month}/g" "${script_path}")
echo "${sql}"

You don't need cat, I put it as a stdin read (< ${script_path}) for sed.
Search and replace for sed is -e not -i which is for inline editing.
Use double quotes, not single quotes. That allows variable substitution.
Escape the &, by doing \& so it isn't interpreted.

Here is a sample input file and the result:

# cat script.txt; ksh sq.sh
select * from &1 where &2;
select script.txt sq.sh from 2022 where 09;

edited Sep 13, 2022 at 18:47

answered Sep 10, 2022 at 17:13

James Risner

6,09711 gold badges33 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I replace string in KSH file from a sql file?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related