Skip to main content
Level 9
Jun 23, 2015 1:56 PM UTC
Question

Substr Function

I have a script that "walks" through all the records in an Access database table to find the largest file ID number. This script has been working correctly. Now I need to add a prefix to all the ID numbers. This requires me to modify my script so it ignores the one character prefix (prefix is either a "T" or a "Y"). I was trying to use the Substr function to accomplish this.

This is the original script that works:


while(!oDB.isEOF()){


if(xfa.record.DataConnection1.FileName.value > nMaxID)


  nMaxID = Number(xfa.record.DataConnection1.FileName.value);


oDB.next();


}


Below is how I tried to modify the script above to ignore the prefix but I get an error that says Substr is not defined. What have I got wrong?


while(!oDB.isEOF()){


if(xfa.record.DataConnection1.FileName.value > nMaxID)


  nMaxID = Number(Substr(xfa.record.DataConnection1.FileName.value,2,12);


oDB.next();


}


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

16 replies

DKinsleyAuthor
Level 9
Jun 24, 2015 1:03 PM UTC

This is now working. Thank you to all the responders for helping me solve this issue.

This works:


while(!oDB.isEOF()){


if(xfa.record.DataConnection1.FileName.value > nMaxID)


  nMaxID = Number(xfa.record.DataConnection1.FileName.value.substr(1,12));


  Test.rawValue = nMaxID;


oDB.next();


}


Thank you!

Translate
DKinsleyAuthor
Level 9
Jun 25, 2015 12:20 PM UTC

I am mistaken. The script above is still not working correctly.

radzmar: your script does not include "substr" - is it missing or can I use Number(vValue, 2, 5) the same way as substr ?

Translate
radzmar
Level 10
Jun 25, 2015 1:43 PM UTC

Yes, the code got a bit flawed by copy and paste at  my mobile I'm afraid :-O

Translate
DKinsleyAuthor
Level 9
Jun 25, 2015 2:20 PM UTC

Thanks for your help. When you can, please post what your script should look like.

Thank you

Translate
radzmar
Level 10
Jun 26, 2015 7:30 PM UTC

Here'e the complete script I was thinking of.


while (!oDB.isEOF()) {  


  if (xfa.record.DataConnection1.FileName.value > nMaxID) {


       var vValue = xfa.record.DataConnection1.FileName.value;


       nMaxID = Number(vValue.substr(1,12));


  }


  oDB.next();


}


Translate
DKinsleyAuthor
Level 9
Jun 26, 2015 7:34 PM UTC

Thank you. I will give it a try. My concern is that the vValue will not find the largest number in the database column when each value starts with text ("T" or "F"). Example T1012 or F1013

Translate