Is there an equivalent to LEN() function in excel I can use?

[joselv]

I need to get the first x characters of a string in an attribute and concatenated it to another attribute. Is there a way to do this in AIM? It would be the equivalent of using the LEN() function in excel.

[BenHayat]

CHARS_FROM_LEFT

Description:
Returns the text being the specified number of the leftmost characters in the provided text

Parameters:
Attribute of the Plain Text type or string constant or calculation producing text and an integer constant indicating the number of characters to retrieve

Example:
If  CHARS_FROM_LEFT (Account.Name, 2) =  ‘Jo’ Then …

[joselv]

Works beautifully! Thanks Ben!

[BenHayat]

FYI, in Excel, LEN is when you want to count how many characters there are in some text. It returns an integer and Aware has such function too.

[joselv]

haha! You are correct, I meant the LEFT() function. Sorry, good catch.