Friday, June 13, 2008

Zero Padding a Field to 10 characters- VB Script

dim cnt
dim iter
dim tempString
cnt = Len(me.Field("StoreNumber").Value)
tempString = me.Field("StoreNumber").Value
For iter = 0 to 10-cnt
tempString = "0" + tempString
Next

Adding Dashes to a Social Security Number - VB Script

Dim TempSSN
TempSSN = Mid( Me.Field("SSN").Value, 1, 3 )
TempSSN = TempSSN & "-"
TempSSN = TempSSN & Mid( Me.Field("SSN").Value, 4, 2 )
TempSSN = TempSSN & "-"
TempSSN = TempSSN & Mid( Me.Field("SSN").Value, 6, 4 )
Me.Field("SSN").Value = TempSSN

Concatenating Values from a column of a table into a single field - JScript

var ItemsCount = Field("TotalColumn").Items.Count;
var Sum = 0;
var tempField = "";
for( i = 0; i < ItemsCount; i++ ){
tempField = tempField + "," + Field("TotalColumn").Items.Item(i).Value;
}
Field("CombineField").Value = tempField;

Friday, June 13, 2008 4:27:46 PM (Mountain Standard Time, UTC-07:00)  #    Comments [0]  | 
Thursday, June 12, 2008

Finding addresses is hard if the address is unlabeled.

Use this regular expression in a character string to help find addresses. Add post-search code that favors addresses near the top of the page ( FuzzyQuality: Top, {0,0,200,25000 }*dt; ), and/or near some address label ( FuzzyQuality: AddressLabel.Left - Left, {0,0,200,15000 }*dt; ), and you'll be acquiring addresses like you're Donald Trump.

[0-9]{1-6}*{1-30}(
([Dd]*{0-10}[Ee])|([Dd][Rr])
|([Ss]*{0-7}[Tt])
|([Aa]*{0-7}[Ee])|([Aa][Vv])
|([Cc]*{0-7}[Tt])
|([Bb]*{0-10}[Dd])
|([Ll]*{0-3}[Ee]))*{0-30}

Thursday, June 12, 2008 4:32:36 PM (Mountain Standard Time, UTC-07:00)  #    Comments [0]  | 

The settings that need to be set to allow DocuWare to email a document as its original file name without adding any DocuWare files is as follow:

Once DocuWare is opened go to Options > Export Settings and set the following

Thursday, June 12, 2008 6:31:31 AM (Mountain Standard Time, UTC-07:00)  #    Comments [0]  | 
Monday, June 09, 2008

Compare number ranges in ABBYY FlexiCapture

 

vbscript

 

dim val, val1

val = me.Field("Field1").Value

val1 = CInt(val)

 

if val1 >= 1.00 and val1 <= 32.47 then

                me.Field("Field2").Value = "text"

else if val1 >= 32.48 and val1 <= 58.63 then

                me.Field("Field2").Value = "text"

else if val1 >= 58.64 and val1 <= 70.19 then

                me.Field("Field2").Value = "text"

else if val1 >= 70.20 and val1<= 77.71 then

                me.Field("Field2").Value = "text"

else if val1 >= 77.72 and val1 <= 100 then

                me.Field("Field2").Value = "text"

end if

Monday, June 09, 2008 8:33:55 AM (Mountain Standard Time, UTC-07:00)  #    Comments [0]  | 
Wednesday, March 26, 2008

Restrict search area to a sliver next to a label:

          rightof:label;

          above:label.bottom,-20*dot;

          below:label.top,-20*dot;

 

Only grab a capture element if the label element is found:

          if label.isnull then dontfind;

 

Select the capture element closest to a label element:

          nearest:label;

 

Select the label element closest to the top of the page:

          nearesty:pagerect.top;

 

Select the label element closest to the bottom of the page

          nearesty:pagerect.bottom;

 

Limit the search area to the top half of the page:

          above:pagerect.bottom/2;

 

Limit the search area to the upper right hand quadrant of the page:

          above:pagerect.bottom/2;

          rightof:pagerect.right/2;

 

Choose between two capture areas, combine the results in a third:

          if not firstchoice.isnull then

          restrictsearcharea(firstchoice.rect);

          else if not secondchoice.isnull then

          restrictsearcharea(secondchoice.rect);

          end if

 

Choose between n capture areas:

          if not firstchoice.isnull then

          restrictsearcharea(firstchoice.rect);

          else if not secondchoice.isnull then

          restrictsearcharea(secondchoice.rect);

          else if not thirdchoice.isnull then

          restrictsearcharea(thirdchoice.rect);

          .

          .

          .        

          else if not lastchoice.isnull then

          restrictsearcharea(lastchoice.rect);

          else dontfind;

          end if

 

Expand table borders:

          exactcolumnborders(labelfield.left,-30*dot,labelfield.right,-30*dot,block.tablename.columnname);

Wednesday, March 26, 2008 1:30:52 PM (Mountain Standard Time, UTC-07:00)  #    Comments [0]  | 

Pick a theme: