TM1 Forum

This should be a simple one. The following is not returning a positive number. I am being blind to something?

sExisting_Rule = CubeRuleGet('INP Capital Planning');
nTargetCommaPosition = scan(sExisting_Rule,char(39)) ;
asciioutput('Test_Scan_Rule_File.csv',numbertostring(nTargetCommaPosition) );

nTargetCommaPosition is returning 0.

I have checked:
1) that the full rule string is being referenced
2) that the ' characters in the rule file are Ascii code 39 as you would expect

Switch the order of your Scan parameters. You're currently looking for the text of the existing rule inside a string that only contains an apostrophe.

Andy Key wrote: ↑Tue Sep 17, 2024 2:58 am Switch the order of your Scan parameters. You're currently looking for the text of the existing rule inside a string that only contains an apostrophe.

How obvious.

Thank you.

scribe, subscribe !

Steve Rowe wrote: ↑Wed Sep 18, 2024 1:30 pm scribe, subscribe !

? Too cryptic for me.

My cheat sheet just has it as: Scan(substring, string)
And don't forget that it is case sensitive.

Or maybe try remember something like "submarine"
Scan('sub', 'submarine');

A different take on Steve's approach but maybe his example would have worked better with 'sub' as the substring instead of 'scribe'

I have more problems with INSRT and FILL. To name just a few. Luckily PAW helps us.

I must admit that I always think scan means the whole word, so I would expect the full string to be the first argument. I.e. I am scanning this to see if I can find that.

That said, the fact checking the order was missing from this is a bit of an oversight

1) that the full rule string is being referenced
2) that the ' characters in the rule file are Ascii code 39 as you would expect

Maren

Steve Rowe wrote: ↑Wed Sep 18, 2024 1:30 pm scribe, subscribe !

Pretty sure this was the example quoted in the help document at one time, just stuck in my brain....