Placing a "." after each letter through @Formula language

HCL Domino Domino Forum
1

Hi

I habe a form with a field in which users must enter their middle initials. I want to place a @Formula code in the Input translation event of the field to place a “.” after each letter in this field.

So when the user enters “tur” the input transation formula must change this into “t.u.r.”.

And when the user enters “tu.r”, i tmust be changed into “t.u.r.”

What must the formula looks like to get this result?

Regards

2

Subject: Placing a “.” after each letter through @Formula language

There might be an easier way but this is what I could come up with in few minutes I had:

@For(

		i := 0; 

		i < @Length(@ThisValue); 

		i := i +1; 

		tmp := @Middle(@ThisValue; i ; 1); @If(tmp!="."; _withDots := _withDots + tmp + "."; "")

);

_withDots

3

Subject: RE: Placing a “.” after each letter through @Formula language

Hi

Thank you very much for the quick reaction. Your solution works perfectly!!!

Many Thanks.

Regards