Views:

Product: LABEL MATRIX

Version: All Versions

 

Mid(data, start, length, padwith): This function results in a string that is exactly length characters long. These characters come from the characters at the start of the data string, and extend to the right.

If the datastring is shorter than start+length-1 characters, the necessary number of padwith characters is added to the right side of the result. The default padwith character is the space.

Expression

Result

Mid("Valhalla", 3, 5)

lhall

Mid("1234", 3, 5, "0")

34000