Translate AB,CD to "AB":"CD"

HCL Domino Domino Forum
1

Hi I’m looking into a way to translate the multiple values from a field (for example AB,CD) into a specific string formatted like this “AB”:“CD”

Does anyone know whether this would be possible?

Thanks

B.

2

Subject: Translate AB,CD to “AB”:“CD”

Easy with @Implode…

initialValue := “AB”:“CD”;

initialValue := “"”+initialValue + “"”;

@Implode(initialValue;“:”)

3

Subject: Translate AB,CD to “AB”:“CD”

Sure, just use:

Split(“AB,CD”, “,”)

4

Subject: RE: Translate AB,CD to “AB”:“CD”

This will split the string indeed, but how do I format the output to exactly be (including colon) AB:CD

5

Subject: RE: Translate AB,CD to “AB”:“CD”

Sorry, I thought you meant you wanted a list. You could either do a Join afterwards or simply do a Replace.

6

Subject: Translate AB,CD to “AB”:“CD”

What do you intend to do?

Are you in the LotusScript or @function environment?

P.

7

Subject: Translate AB,CD to “AB”:“CD”

Thanks! the @Implode did the trick.