Rustywinger Posted October 16, 2007 Report Share Posted October 16, 2007 For the life of me, I cannot grok text processing. I capture a reference number from a record in a program, and then try to match it to a name in an Excel file saved as a comma delimited CSV. The Excel file has two columns, one with a match for the aforementioned number and the name associated with it in the next. It has 10800 rows in it, and the file size is 223kb. The crude way I have this set up to work right now is: Variable Set Integer %N60% to 0 Repeat Until %T57% Contains "%T58%" Text File Begin Process: "referring_lookup.txt" Text File End Process Variable Modify Integer: %N60% = %N60% + 1 Repeat End <IVAR2:60:01:0><REP3:08:000007:000001:0057:0:01:%T58%> <BTFBEG:057:N00060:000001:\\nevermindthis\referring_lookup.txt> <BTFEND><NMVAR:01:60:1:0000060:2:0000001> <TBOX4:T:1:CenterCenter000278000200:000:T58=%T58%-T57=%T57%><ENDREP> %T58% is the captured reference number, which is the condition for the repeat loop to end. %T57% is the destination variable for the result from the Text File Begin Process (TFBP) command. %N60% is an incremented integer within the loop that is used as the starting line value within the TFBP. The TFBP is processing one line at a time. I have no doubt I am doing this wrong, it takes forever to process the file line by line, but I can't see how to just load the whole thing into a variable and get the information I need, which is a single row matching the criteria being put into another variable. 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.