Since the imported date data is in a uniform format you can also use the
substr expression, like this:
Or, if preferred, this:
This is similar to the MID text function you may have seen in spreadsheets: start at a specified character in a string and include a specified number of characters after that. Unlike spreadsheets,
substr starts from character 0 rather than character 1. So:
substr($MyString,0,2) means start at the first character and include two characters, equivalent to =MID(ref to string,1,2)
substr($MyString,2,2) means start at the third character and include two characters
substr($MyString,4,10) means start at the fifth character and include 10 characters after that. Tinderbox doesn’t seem to mind if you use a value larger than 10 here to make sure you capture up to the end of the string.
Preformatted text , though there are more sophisticated ways to do that using $String.size as suggested in the examples in Mark A’s aTbRef.