AnsweredAssumed Answered

Producing non-printing/delimiting/repeating field characters in a formula with text result

Question asked by JeffJ on Sep 4, 2009
Latest reply on Sep 5, 2009 by JeffJ

Title

Producing non-printing/delimiting/repeating field characters in a formula with text result

Post

I am attempting to bring a set of records from one database into a group of repeating fields in another in FM 5.5. Please don't ask why. So far I have tried several methods with little success but my latest is promising with two basic problems. The first is the topic of this post. The following is a representation of a formula I have created to facilitate this:

 

SetField("gGlobalTextField","TextField1 & Char(29) & TextField2")

 

The Char(29) figure would be what I understand is the repeating field delimiting character if there was a Char() function in FM 5.5. Does anyone have any thoughts on how to produce a text line as outlined above? Thanks

Outcomes