I want to write a script to do something like this:

UPDATE DocumentItem
SET MainContent = REPLACE('<style>%</style>' WITH '' IN MainContent)

WHERE [some condition]

;

i.e. I have a bunch of web-pages in a table & they contain identical style-sheets embedded
in each document ... I want to remove these so I can set the styles programatically.

What I need is for DBISAM to accept wild-cards in its REPLACE function ... so that it can
delete out longer/variable sections of text.

The above syntax doesn't work. Is there another version that does?

If not, any chance of adding it to the "ToDo" ... ??

adam

adam


A bit more longwinded but what about using SUBSTR and POS - almost certainly wrong but

UPDATE DocumentItem
SET MainContent = SUBSTR(MainContent,1,POS('<style>',MainContent))+SUBSTR(MainContent,POS('</style>',MainContent)+7,LENGTH(MainContent))

WHERE [some condition]

;

Roy Lambert

Adam,

<< What I need is for DBISAM to accept wild-cards in its REPLACE function
.... so that it can delete out longer/variable sections of text.

The above syntax doesn't work. Is there another version that does? >>

No, but you can add this type of functionality very easily via a custom
function.   See here:

http://www.elevatesoft.com/dbisam4d7_customizing_engine.htm

--
Tim Young
Elevate Software
www.elevatesoft.com