0
Display first two characters
I am trying to create a formula that will only display the first two left characters from a text box. How do I create this?
3 replies
-
I assume you want to retain the complete text, but only display the first two left characters. In that case I would create a field that stores the complete text, but is hidden. I used this code in "Trigger after update"...
let txtMyText := Text1;
Text2 := txtMyText;
Text1 := substr(txtMyText, 0, 2) -
Perfect thank you!
What I was doing was embedding it into a Printed Form and I just used substr!!
-
That's what happens when one assumes things! :-D
Content aside
- 5 yrs agoLast active
- 3Replies
- 1956Views