Place text before existing text in a field.

[hownow]

I would like to place text in a field called "textbegin"  before the text that was already there.

IN other words. How can I place text in a field before the existing text without losing the original text,

If the field contains "mystery tour" I would like place "magical " before "mystery tour".  Not sure how to calculate to make the cursor add my text before existing text in a field.

[eos]

If you do this programmatically, there is not really a cursor; rather, replace the existing field contents with the result of a text calculation:

"newText" & yourField

In a script, use

Set Field [ target field: YourTable::yourField ; value/result: "newText" & YourTable::yourField ]

where "newText" could be "a string literal", a Table::fieldReference, a $variable …

Edited April 30, 2015 by eos

[hownow]

Thank you