IT-Tool

%TFP0% or
%PARSERNAME0%

Returns the value for the provided index in the current row loaded.

R

%HEADERNAME%

Returns the value for the provided column name in the current row loaded.

R

TFPROWCOUNT or PARSERNAMEROWCOUNT

Returns the amount of columns in the current row.

R

TFPHEADERCOUNT or PARSERNAMEHEADERCOUNT

Returns the amount of columns in the header.

R

TFPAddFormat(Name As String, Format As String,

                              Optional Type As Integer = 0,

                              Optional TrimWhiteSpace As Boolean = True,

                              Optional HasFieldsEnclosedInQuotes As Boolean = True)  As Boolean    

Type: Fixed width = 1, Delimited = 0

TFPRemoveFormat(Name As String) As Boolean

TFPSetFormat(Name As String, Optional parserName As String = "") As Boolean

       Default formats already available are “CSV”, “TAB” and “PATH”

TFPLoadFile(path As String, Optional parserName As String = "") As String

TFPLoadString(value As String, Optional parserName As String = "") As String

TFPPeekLine(Optional parserName As String = "") As String

TFPReadHeader(Optional parserName As String = "") As Integer

TFPReadNextLine(Optional format As String = "", Optional parserName As String = "") As Boolean

TFPGetValue(index As Integer, Optional parserName As String = "") As String

TFPGetValue2(Name As String, Optional parserName As String = "") As String

TFPGetHeaderValue(index As Integer, Optional parserName As String = "") As String

TFPReadFields(Optional parserName As String = "") As Integer

TFPEndOfData(Optional parserName As String = "") As Boolean

TFPClearParser(Optional parserName As String = "") As Boolean

TFPGetDataTable(fileName As String, headerIncluded As Boolean, 

                              Optional format As String = "") As DataTable