Google Sheets' regular expression calculation

Question

Can I compute the numeral part of a string then put it back in the string using Google Sheets?

https://docs.google.com/spreadsheets/d/13zl7uUq8EtbdLDVFrLKfD7XOQ4feqd9Xrm2F4NX6L54/edit

Answer 1

=ARRAYFORMULA(TEXTJOIN(";", 1, 
 IF(REGEXMATCH(TRANSPOSE(SPLIT(C1, ";")), A1), 
 TRANSPOSE(SPLIT(C1, ";"))&" @ $"&A2&" = "&
 REGEXEXTRACT(TRANSPOSE(SPLIT(C1, ";")), "\d+")*A2, 
 IF(REGEXMATCH(TRANSPOSE(SPLIT(C1, ";")), B1), 
 TRANSPOSE(SPLIT(C1, ";"))&" @ $"&B2&" = "&
 REGEXEXTRACT(TRANSPOSE(SPLIT(C1, ";")), "\d+")*B2, ))))