Scan of rules not returning what I am expecting

[JohnO]

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

[Andy Key]

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.

[JohnO]

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.

[Steve Rowe]

scribe, subscribe !

[JohnO]

scribe, subscribe !

? Too cryptic for me.

[gtonkin]

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'

[Wim Gielis]

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

[MarenC]

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]

scribe, subscribe !

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