Concatenation / LEFT() or RIGHT()

Answered
LittleMan asked on April 12, 2024

Hi Team,

We are looking at the possibility of using Excel type text functions within Flexmonster.

E.g. Pivoting names based on initials.

Our data has names shown as A Jones, F W Smith etc.

Without separate data being provided in a raw format, are we able to create calculated fields that will allow us to obtain A, FW etc from the above example?

1 answer

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster April 15, 2024

Hello!

Thank you for reaching out to us.

Please note that it is not possible to perform string manipulations in Flexmonster. We kindly recommend preprocessing such data before passing it to our component.

Hope it helps.
Feel free to reach out to us in case of any other questions.

Kind regards,
Solomiia

Please login or Register to Submit Answer