LEFT

Description

LEFT takes string (or list) and a number and returns the first number of characters from the string.

Example

LEFT('DE12500105170648489890', 2)

This will extract the first two characters from the left of the provided IBAN. This effectively extracts the country here indicating you have a "DE" IBAN at hand.

Last updated