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?
---( Mårten Törnquist )---