Hi,
I tried all the possibilities of using Implode/Explode in a dialog list but still no use. I am sorry if already somebody did post in here, but couldn’t find anything related to my problem. The problem is if value already exists then it automatically splits up. For eg I have field1 and that takes its values from Profile document. The formula used is
CLR := @GetProfileField(“Profile”;“Claim_Rep”);
@If(Claim_Rep != “”; @Explode(Claim_Rep; " ,;"; @True; @False) : CLR; CLR)
The values I get from profile document would be like this in dialog list
A B
C D
X Y
and if already value was saved as “A B” then by using above formula my dialog list shows like this
A
B
C D
X Y
If anyone know this please help me.
Subject: Implode Explode & Dialog list
I’ m not sure what you’re trying to get? Can you give a bit more info on what you want to get?
Your profile document has a fiedl Claim_Rep with the value:
“A B”:“C D”:“X Y” (multiple value)
Then I’m not sure what you want from field1??
If Field1 is (assuming you want Field1 to be these values?)
“A B” then you want what to happen?
“E F” then you want what to happen?
Subject: RE: Implode Explode & Dialog list
Andre I did search for multivalue space in the forums but couldn’t find one.
Stephen the value I get from Profile document is proper. The problem is with an existing document? For example I have document which has claim_rep as A B. So now I want to change the claim rep and I open the document in edit mode. Then I click on the dialog box and the values should be displayed as
A B
C D
E F
but for me it gets displayed as
A B
C D
E F
A
B
Hope now you understood what I am trying to say. And fyi claim rep multivalues are keywords.
Subject: Implode Explode & Dialog list
I’m not sure I understand correctly, but it looks like you need to do something like this…
list:=CLR:Claim_Rep;
@trim(@unique(list))
this will simply add the Claim_Rep value to the values already stored in your profile doc.
Subject: RE: Implode Explode & Dialog list
Hi,
I tried out the code which you told me still I get same thing.
A B
C D
A
B
But if you see the output is different.
Subject: RE: Implode Explode & Dialog list
Search in here for multivalue space