302 Found

Found

The document has moved here.

Formula Function Reference

Our Formula Function Reference

Part - Text

Arguments: 
(Text t, Number p, Text d)
Result Type: 
Text
Explanation: 
Returns the specified part of a text value. The parts are separated by the occurrence of any delimiter character. The first argument, t, is the value to be searched. The second argument, p, is the position of the part in the argument t. The first part starting on the left is position 1. Negative part numbers can be used to start from the right. The third argument, d, is a text value containing all the possible delimiter characters. If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter.
Example: 
Part("hh:mm:ss",1,":") returns "hh" Part("hh:mm:ss",3,":") returns "ss" Part("hh:mm:ss",-1,":") returns "ss" Part("hh:mm",3,":") returns "" Part("abc, def,ghi",2," ,") returns "def" Part([Append],2,"[") returns all text from the Append field that lives between the first [ character and the second [ character. This example shows how to extract only the most recent entry from an append field.
Tags:

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.