i am stuck in small logic, kindly help me to resolve my issue.
there is one CRM search option, in which if i search for some initial, let say ABC, it provide the details of ABC as a table.
so in some initials what happening is ABC is a scrapped variable which is passing everytime to the CRM search option, and it match with CRM data, but in CRM , column “initials” can be in upper case or can be in lower case as well like Abc or abC.
because of this for some of the data doesn’t match.
what i have done is
i scraped the data,
then put filter wizard, so that it should match the initials first and then look for other condition.
“Initials” is the column of CRM.
sNNinitials is scrapped variable.
so i want to convert the column value to be in uppercase always, so that it should match.