Skip to Navigation | Skip to Content

Forums

concatenate text

Mar 28 2007 at 6:36 pm

swisscheez

I have an entry set with 3 fields - a, b, c.
I'd like to form a field "d" by combining a & b & c with possibly some additional text values like ", " in there too. Is there a way to do this?

Mar 28 2007 at 7:37 pm

swisscheez

hmm - well i just used vba but am still wondering if there is a way to do it in the interface.

Mar 29 2007 at 10:38 am

esan

Sorry for the late reply, there have been some glitches in getting notifications from the forums.

You can use the entryset formula to do that. See the attached Module as an example.

It takes the values from each cell in the attributes A B and C, concatenates them and outputs them in the new attribute D.

let me know if this helps

-Esan

Attached File

 
Already using Proto? Log In | Register