Page 1 of 1

Scan on an empty string

Posted: Thu Apr 29, 2021 6:28 pm
by Wim Gielis

I had to investigate a tricky mapping process with TM1 data going to Hyperion Financial Management (HFM).

Actually, it turns out that using the Scan function with an empty string, to be looked up in a non-empty string, gives a result of 1. Not 0.

Be aware of this :-)

Re: Scan on an empty string

Posted: Mon May 03, 2021 7:16 pm
by 20 Ton Squirrel
*peers into a box looking for an empty*

My god, it is FULL of nothings! ×___×

Thanks for posting on this, one of the projects I'm working on is using SCAN in a few spots. I'll keep this in mind.

Re: Scan on an empty string

Posted: Tue May 04, 2021 1:12 pm
by PavoGa
"Nothing from nothing leaves nothing"

-Billy Preston

Who knew Billy was a TM1 expert back in 1974. :lol: