Issues with String format

[#1]

Is it possible to change the letter case to Upper for some part of the string.

Ex. 'aaa-Chennai and bb-India'  this needs to converted 'AAA-Chennai AND BB-India'

[jagan]

Hi,

Try like this

=Upper(Left('Hello world', 5)) & Right('Hello World', 6)

Regards,

Jagan.

[#3]

Let me explain my requirement clearly...

Filter values and the scenario name will be given in an excel file. And I need to apply those filter for each scnario.

First I'll load the whole data into a qvd file. Then I need to apply the filters for each scenario on that qvd and will load it in a table. So whenever the users select the scenario the values will be filtered out. (Just to avoid selecting the values manually for each scnario during the analysis)

Now the Filter conditions are in the following format

DBTableName.DBFieldName1 like 'abc%' or DBTableName.DBFieldName2 like 'de%'

This filter condition can contain any number of fields.

As I need to apply this formula on top the qvd, I cannot use 'like' function and the above string needs to be converted into

wildmatch(DBTableName.DBFieldName1,'abc*') or wildmatch(DBTableName.DBFieldName2,'de*')

[#4 · Accepted solution]

Got the solution

='wildmatch('&replace(replace(replace(formula,'OR', ') OR wildmatch('),'like',','),'%','*')&')'