Scan Fun and Games

Post Reply
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Scan Fun and Games

Post by jim wood »

Guys,

I've always had fun with Scan but I'm having trouble with it today. For some reason it keeps returning 0.

Here is the code for the variable being examined by the scan:

Code: Select all

V2=DimNm('}Groups',1);
Here is the result:
Issue Part 1.PNG
Issue Part 1.PNG (1.6 KiB) Viewed 2501 times
Here is the code for the scan:

Code: Select all

V3=SCAN(V2,'-GRP');
Here is the result of the scan:
Issue Part 2.PNG
Issue Part 2.PNG (1.53 KiB) Viewed 2501 times
I'm doing this in version: 10.1.1

It's late in the day and it may be something obvious so don't go kicking my door down if it is :)

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: Scan Fun and Games

Post by Duncan P »

SCAN finds the first string in the second, not the second string in the first.

HTH
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Scan Fun and Games

Post by jim wood »

Thanks Duncan. I knew it would be something stupid like that. With the bad we've had this week, it's been a very long one indeed.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply