Apply a formula to each value in a list field

The formula below translates each value in the "website" field to insert the "http://" prefix if needed. It uses the new @Transform which applies a formula to each value.
Lotus Formula

fld := website ;

newvalue := @Transform(fld;"VARIABLE";  @If(
@LowerCase(@Left(@Trim(VARIABLE);4))="http" ;
"" + VARIABLE + "" ;
"" + VARIABLE + ""
));

@Implode( newvalue ; "<br>" )

Written by Frank Joseph Brefere III

Posted by on Thursday October 25, 2007