Cory Posted December 2, 2005 Report Share Posted December 2, 2005 Is there a way to, in effect, do a %T%N1%%? IOW have the number in the string variable increment? Specifically I’m dealing with a tab delimited file that comes form an Excel spreadsheet with a variable number of data columns. What I am doing is a little more complicated in actuality but I can distill it to a simpler example. Suppose I read in the first line from the text file. In the register I will have values in T1 thru some unknown number of strings. I want a repeat to check each of them in sequence to determine how many there are. So I was thinking that one could have a repeat and put the counter in %N1%. Then use that counter as the number part of the string variable. As soon as I encounter the first blank record I can subtract one form N1 and know how many columns there are. I tried a simple test using text type but the test prints out “%T1%%T2%%T3%...” instead of the text save in the string vars. I’ve scanned Joe’s book for it and also the forum here but I can’t find anything relevant. Probably because I don’t know what the proper terminology would be for this. Also maybe there’s a completely different way to approach this. This must be a common problem so there must be an elegant solution. For the moment I’ll use a limited ugly approach, hopefully one of you can help me cut it out later. Thanks! Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.