Hmmmm. Watch out for the variable sString, not all loops can be skipped.kenship wrote: ↑Mon Sep 19, 2022 7:13 pm I get it, I'll implement it.
Kenneth
Wim Gielis wrote: ↑Mon Sep 19, 2022 5:27 pm I would add a couple of:
If ( nFlag = 0);
To avoid processing useless loops.
If you already know that nFlag <> 0, why bother with other loops ?
ASCIIOutput Elements in One Dimension Only
-
- MVP
- Posts: 3105
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: ASCIIOutput Elements in One Dimension Only
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Regular Participant
- Posts: 194
- Joined: Thu May 30, 2013 1:41 pm
- OLAP Product: Cognos
- Version: Planning Analytics 2.0.7
- Excel Version: 2010
Re: ASCIIOutput Elements in One Dimension Only
Noted with thanks.
Actually I skipped the sString since I only need the project code extracted. The IF check is added at the beginning of the each section before resetting the iTimeCount to 1. The output result is the same so I am sure I'm not missing anything.
Kenneth
Actually I skipped the sString since I only need the project code extracted. The IF check is added at the beginning of the each section before resetting the iTimeCount to 1. The output result is the same so I am sure I'm not missing anything.
Kenneth
Wim Gielis wrote: ↑Mon Sep 19, 2022 7:25 pmHmmmm. Watch out for the variable sString, not all loops can be skipped.kenship wrote: ↑Mon Sep 19, 2022 7:13 pm I get it, I'll implement it.
Kenneth
Wim Gielis wrote: ↑Mon Sep 19, 2022 5:27 pm I would add a couple of:
If ( nFlag = 0);
To avoid processing useless loops.
If you already know that nFlag <> 0, why bother with other loops ?