I need a function that works as an inverted Extract... It should return everything before a specified delimeter and everything after a specified delimiter with the option to insert something in the middle.

In a working example for what I need it for is the following string:

driver={SQL Server};server=(local);database=master;uid=sa;pwd=;

In my program the database= could be many different values (here its master but I don't know at runtime). So I want to be able to insert something between database= and ; and remove whatever is there.

Is there any build in function if VFP for doing that?