Search Results

For homework, please use this link:
Homework & Coursework Questions - The UNIX and Linux Forums (https://www.unix.com/homework-coursework-questions/)

You may try something like this:

# cat /tmp/data.txt
doni|student|westjava|123412|lombok|
iwan|student|westjava|1234412|utankayu|
rio|student|westjava|12342|cempedak|
# mysql -uroot -p t...

Your problem is still with the "sed":
sed "s/$current/$change/g" ...

I have not had lunch yet, but I am guessing that you are not telling sed what to do. Perhaps (note the s)

sed "s/$current/$change" file.txt > file1.txt

That can't be what you actually typed. What did you type?

---------- Post updated at 02:13 PM ---------- Previous update was at 02:12 PM ----------

777 is not the magic sledgehammer to solve...

You used || when you should have &&

$ echo 100,2.4 | awk -F"," '{if ($2>1 && $2<2) print $1","$2}'


$ echo 100,1.4 | awk -F"," '{if ($2>1 && $2<2) print $1","$2}'
100,1.4

V7.6 is almost 10 years old and doesn't support 11g database. You need to upgrade to at least v9.7 or v10.x