Formula Splitget

[SergeiEvdokimov]

Hi all!
I can't understand the line splitting logic of the splitget function. The string "invoice #132456 of 20 01 2022"
Formula: SPLITGET(FT_StringNumberDate, "of", 0)

Result:

Can you help me?

​

------------------------------
Sergei Evdokimov
------------------------------

[SergeiEvdokimov]

Yup, I forgot that for functions, the separator is a character 🙂

------------------------------
Sergei Evdokimov
------------------------------

[PabloSarabia]

Hi @SergeiEvdokimov

It's everything clear? or need some help with this?



See you in the community, bye :)​

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------

[SergeiEvdokimov]

Hi Pablo!

Thanks, I figured out where I went wrong 🙂

------------------------------
Sergei Evdokimov
------------------------------