12-17-2014 05:18 AM
There are 2 fields called Company Name and Tradestyle. My requirement is if company name is ABC Company "Software" and the tradestyle is Software; I have to change the company name to ABC Company. That means I have to remove the string in double quotes from the Company Name if it is matched to Tradestyle. Can anyone help on this?
12-17-2014 05:57 AM
if company_name = 'ABC Company "Software"' and tradestyle = 'Software' then company_name = 'ABC Company';
if substr(company_name,length(company_name)-length(tradestyle)-1) = '"'!!trim(tradestyle)!!'"' then
company_name = substr(company_name,1,length(company_name)-length(tradestyle)-3);
Please avoid to post the same question to multiple communities in the future.