$def = ".define get_user_info select user_location,user_name, user_company, &fax_header || +';style=' || letterhead, fax_printer, nvl(fax_yn,'N') into user_location, user_name, user_company, fax_header, fa +x_printer, fax_yn from security_header where user_id = lower(substr(user,5,10)) .."; $def =~ s/(^\.\w+\s)(\w+)(\s+)(.+)(^select\..$)/$2$5/; print $def;