var t = @your text field;
Removing characters from text
Im trying to remove the last 14 characters from a textstring - but nothing seems to work.
Which formula do I need to use to do this?
Please sign in to leave a comment.
Thanks! It works :)
The string is actually build lige this: Text1 + Text2 + Text3.
Is it possible to identify the second spacing from the right in order only have text1 as a result?
Text1 could consist of more than one word ex. Office Supplies for Office 1 (text1) + RLK (text2, department) + 2610 (internal ref. number). In this case I only need text1 shown in the calculation field.
Thanks for the help.