substring problem..

[eja2000]

i have a string that reads thus;
equipment catalog id=Faxmail;

what i want is to create a variable which will display "Faxmail" (no quotes)

i have several rows of data that are in this format..
in short, i want everything between the "=" sign and the ";" sign..
i am using webi6 ..
thanks

 

[blom0344]

Does WebI feature the Pos() and Substr() functions?

Ties Blom
Information analyst
tbl@shimano-eu.com

 

[BrianTyler]

If a variable FRED contains "equipment catalog id=Faxmail;"

then

=SubStr(<fred> ,Pos(<fred> ,"=") ,Length(<fred>)-Pos(<fred> ,"="))

gives Faxmail

It works by using POS to find the position of the = sign to determine the first character required, and then to determine the number of characters to be moved.