VBScript Requires Chilkat v11.7.0+
VBScript
Replace the Value After a Label in a PDF (Re-issue an Invoice)
See more PDF Text Replacement Examples
Demonstrates replacing the values that follow labels such as "Invoice Number:" on a PDF that has no placeholders -- an ordinary invoice. Each entry of the "labels" array names a label as it appears on the page and the new value; the value replaces the rest of the label's line. Label matching ignores case, extra spaces and a trailing colon. The replaced text is read back with ExtractText to confirm it.Chilkat VBScript Downloads
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
success = 0
' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
' The PDF used in this example is available at invoice_labels.pdf
set pdf = CreateObject("Chilkat.Pdf")
success = pdf.LoadFile("qa_data/pdf/invoice_labels.pdf")
If (success = 0) Then
outFile.WriteLine(pdf.LastErrorText)
WScript.Quit
End If
' The invoice has lines such as "Invoice Number: INV-2026-0412" and "Total Due: $1,234.53".
' Each label's new value replaces whatever follows the label on its line.
set json = CreateObject("Chilkat.JsonObject")
success = json.UpdateString("labels[0].label","Invoice Number:")
success = json.UpdateString("labels[0].value","INV-2026-0500")
success = json.UpdateString("labels[1].label","Invoice Date:")
success = json.UpdateString("labels[1].value","April 2, 2026")
success = json.UpdateString("labels[2].label","customer")
success = json.UpdateString("labels[2].value","Contoso Ltd")
success = json.UpdateString("labels[3].label","Total Due:")
success = json.UpdateString("labels[3].value","$1,999.99")
set jsonOut = CreateObject("Chilkat.JsonObject")
success = pdf.TextReplace("apply",json,jsonOut)
If (success = 0) Then
outFile.WriteLine("Not applied: " & jsonOut.Emit())
If (success = 0) Then
outFile.WriteLine(pdf.LastErrorText)
WScript.Quit
End If
End If
i = 0
count_i = jsonOut.SizeOfArray("replacements")
Do While i < count_i
jsonOut.I = i
outFile.WriteLine("Replaced the value of """ & jsonOut.StringOf("replacements[i].label") & """ on page " & jsonOut.StringOf("replacements[i].pages"))
i = i + 1
Loop
success = pdf.WriteFile("qa_output/invoice_reissued.pdf")
If (success = 0) Then
outFile.WriteLine(pdf.LastErrorText)
WScript.Quit
End If
' Read the new values back with ExtractText's label option.
set jsonRead = CreateObject("Chilkat.JsonObject")
set jsonText = CreateObject("Chilkat.JsonObject")
success = jsonRead.UpdateString("label","Total Due")
success = jsonRead.UpdateString("labelValue","right")
success = pdf.ExtractText("text",jsonRead,jsonText)
If (success = 0) Then
outFile.WriteLine(pdf.LastErrorText)
WScript.Quit
End If
outFile.WriteLine("Total Due is now: " & jsonText.StringOf("text"))
' Sample output:
' Replaced the value of "Invoice Number:" on page 1
' Replaced the value of "Invoice Date:" on page 1
' Replaced the value of "customer" on page 1
' Replaced the value of "Total Due:" on page 1
' Total Due is now: $1,999.99
outFile.Close