AnsweredAssumed Answered

Help with script

Question asked by kilbot on Sep 29, 2009
Latest reply on Oct 13, 2009 by TSGal


Help with script


I have a repeating field (up to 15 per record) and I want to print a report that will capture the right 3 digits of a 6 digit position number. Example


1st record 

Tom Jones        900701

Karrie McCarty   912301

Mary Cartwright 911606 


2nd record 

Ed James          900626

Kenny McCree    912881

Joe Smith          911116 


3rd record 

Jim Jacklin          900626

Liz Keen            912755

Jimmy Gonzalez   912216 


So I would like it to capture 2 records  if I was looking for 700 - 800 for the last 3 digits. I would also like to get a summary of how many cases plus a couple of other fields. Please let me know if you have any advice.