i have two columns and want to select a part of the column

[saumyashah90]

I have two columns.

FieldA
223
224
225
226

FieldB
1923_223
1344_224
2343_435
2323_225

When i select 223,

I want 1923_223 to get selected.

Note i can not make additional column , Just a GUI possibility

[saumyashah90]

btw both are list box

[avinashelite]

If you want 1923_223  to get selected when 223 is selected , then you need to build a relation for it and you cannot achieve in this easily in the front end .

Try like this :

Subufield(fieldB,'_',2) as FieldA

in front end try like this if(FieldA=Subufield(fieldB,'_',2),FieldB)

[ganeshreddy]

Hi Saumya,

If two fields are from same tables try to create a new field in script as mentioned below, then in list box make a concatenated field.

1. In script :  Subufield(FieldB,'_',2) as FieldC

2. In list box expression (Make a concatenated field) : FieldA&'_'&FieldC

i hope it works.

Regards,

Ganesh

[saumyashah90]

i cannot touch the script

[saumyashah90]

see i got way to select on value

but i need to see if i can select multiple values

[saumyashah90]

see i got way to select on value

but i need to see if i can select multiple values

[settu_periasamy]

If you want multiple value selection, you can try to use concat.. Like

='('&Concat(DISTINCT '*'&FieldA,'|')&')'

store this into your variable.