I have the following formula...when I check for errors, it gives me "the remaining text does not appear to be part of the formula" and points to where I have indicated...if I take the stuff out below the select block it's OK...but Ineed that stuff there...what is it seeing...
thanks
local stringvar tmpExtension;
select uppercase({@xxx_File Format (PDF, HTML, Text, Excel)})
case "PDF" : tmpExtension:="pdf"
case "HTML" : tmpExtension:="htm"
case "TEXT" : tmpExtension:="txt"
case "EXCEL" : tmpExtension:="xls"
default : tmpExtension:={@xxx_Export File extension};
//error points here
if uppercase({@xxx_File Format (PDF, HTML, Text, Excel)}) in ["PDF","HTML","TEXT","EXCEL"] and trim({@xxx_Export File extension})<>""
then tmpExtension:={@xxx_Export File extension};
local stringvar tmpFilename:=filename;
tmpFilename:=strreverse(mid(instr(strreverse(tmpFilename),"/"));
thanks
local stringvar tmpExtension;
select uppercase({@xxx_File Format (PDF, HTML, Text, Excel)})
case "PDF" : tmpExtension:="pdf"
case "HTML" : tmpExtension:="htm"
case "TEXT" : tmpExtension:="txt"
case "EXCEL" : tmpExtension:="xls"
default : tmpExtension:={@xxx_Export File extension};
//error points here
if uppercase({@xxx_File Format (PDF, HTML, Text, Excel)}) in ["PDF","HTML","TEXT","EXCEL"] and trim({@xxx_Export File extension})<>""
then tmpExtension:={@xxx_Export File extension};
local stringvar tmpFilename:=filename;
tmpFilename:=strreverse(mid(instr(strreverse(tmpFilename),"/"));