suppose that we have following string:
$6 $7 You have received the grade of $3 in the subject $1 ($10) in the semester $2 ($11). Grade date: $4 Entered: $5
I need to figure out how to dynamically and corrcetly replace those variables. And suppose we have folloving
for i in 1..X loop l_str := regexp_replace(l_str, '\$'||to_char(i), l_replace(i)); end loop;
But when it comes to first iteration -
$11 variables are being replaced - but only
$1 is correct.
Does anyone have advice how to fix it?