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! :mrgreen:

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. 🙂