Replace multiple values to one value

[#1]

how to set two values in variable for text object action?

Select Variable: vCountry

Select Value: 'India' and 'BHARAT' it does not work for me tried pick match but still not working

i have India and BHARAT in my Region field, i mean some file has BHARAT and some files has India.

i want when BHARAT is selected it should show India\BHARAT same when BHARAT selected show India\BHARAT in button.

can we replace two values with one value by using REPLACE function?

[Kushal_Chawda]

In script create a new field

if(match(lower(Region),'india','bharat','India',Region) as New_Region

[#3]

hi kush,

thanks for your reply, but it does not work, cant we do in text object action?

[jagan]

HI,

Try like this in script

LOAD

*,

if(match(lower(Region),'india','bharat','India',Region) as New_Region

FROM DataSource;

No use New_Region field as filter.

Hope this helps you.

Regards,

Jagan.

[Kushal_Chawda]

I quite don't understand if user is going to select the Region from listbox then why you need text object and button

[#6]

Hi,

If your intention is to combine two values into one, then below script will help you.

=Replace(Replace(Country,'Bharat','INDIA'),'India','INDIA / BHARAT') as Region,

If you take the list box REGION the you will seen combined value for India and Bharat as INDIA / BHARAT.

Regards,

Pavan.

[sasiparupudi1]

use an if condition

if (lower(region)='india' or lower(region)='bharat','india\BHARAT',region)

hth

Sasi

[jsingh71]

See this:

=if(Region = 'India' or Region ='Bharat', 'India/Bharat',Region)

[veidlburkhard · Accepted solution]

Hi Nilanjan,

you have to enter your selections like this:

Hope this helps

Burkhard

[#10]

Hi guys thanks a lot for all the useful answers.