Our Text Lookup
User Function Library is a set of seven
functions--which we detail below. This outstanding tool enables you to search through a text file and extract
lines and columns to display in your report.
It allows
you to search text documents and return individual lines or
columns.
For example, you may not have a
database table with descriptions of your codes.
By creating a
text file with those codes and descriptions, this UFL will read
the text file like a table.
This avoids your needing to have
repeated if..then ..else in multiple formulas.
A free
trial version is available for evaluation on our download
page. Please bookmark this page, download that, and test-drive
this outstanding product.
The
Seven functions of Our Text Lookup
User Function Library:
TextLookupLine( FileName,
Search). Open and search
FileName for the Search text. The function returns the
entire line where the search was found. If the Search is not
in the file, an empty string”” is returned.
TextLookupColumn( FileName,
Search, Col). Open and search
FileName. This function assumes that the file is a series of
values on a line with a tab or comma to separate the values
into columns. The Search is made on the first column (which is
regarded as column 0). The values are viewed as additional
columns. If a column number of less than 0 or beyond the end
of the line is requested a blank value is returned. If the
search is not found a blank value is returned.
TextLookupColumnCount(
FileName, Row). Open and search
FileName for a specific row (or line). Count the columns in
that line and return the number of columns. The values on the
line can be tab or comma delimited.
TextLookupColumnSeperator( FileName). Open and search
FileName. Examine the columns in that line and whether it is
tab or comma delimited. The function will return “Comma”
or “Tab” and is intended for diagnostic use.
TextLookupLineNumber( FileName, LineNo). Open and
search FileName and return a specific line number from the
file. If the line number is beyond the end of the file, a
blank is returned.
TextLookupCount( FileName). Open and search FileName and
return the number of lines in the file.
TextLookupConfirm( FileName). Look for FileName and identify
if the file is found or not. This is intended for diagnostic
purposes.
These keywords may have brought you here: crystal reports text lookup, crystal reports utilities, TextLookupLine, crystal reports solutions, TextLookupColumn, crystal reports tools, TextLookupColumnCount, crystal reports software, TextLookupColumnSeperator, crystal reports add-ons, TextLookupLineNum, looking up text in crystal reports, ber, crystal reports downloads, TextLookupColumnSeparator, crystal reports function libraries, TextLookupCount, crystal software, TextLookupConfirm, crystal downloads, text tools for crystal reports, crystal reports problems, crystal reports developers, crystal reports help, crystal reports modules, crystal reports scripts, crystal reports management tools, crystal reports management software, crystal reports management utilities, crystal reports user function libraries, crystal reports ufls
