Please note that, because this reserved L4X table already exists, you do not have to construct and assign a new table in order to change the value of one field, instead you can assign a value directly by indexing the table by a field-name:
-- changes the dates picture-string Sheet.Pictures.date = "yy/mm/dd"If your script requires a non-standard conversion of a text-string, but only for one column, then you may assign a "picture" of this conversion to the picture field of a Column table.
-- changes the number picture for one column
Column.A = {pos=1, fmt="number", picture="(9.9)"}
This expression constructs a new table and assignes it to table:
Sheet.Out.
The fields of the new table specify miscellaneous properties
of the worksheet output by the L4X filter.
The value assigned to field: row of table:
Sheet.Out
which specifies the worksheet row where
column
import originates, must be considered when
formatting cells and columns.
When this value is changed, you may also need to adjust formatting and
formulae in the "scripted"
worksheet.
Please note that, because this reserved L4X table already exists, you do not have to construct and assign a new table in order to change the value of one field, instead you can assign a value directly by indexing the table by a field-name:
-- specifies the worksheet row -- where column import originates Sheet.Out.row = 3This expression assigns a value to field: row of table: Sheet.Out This value specifies the worksheet row where column import originates, It must be considered when formatting cells and columns. When this value is changed, you may also need to adjust formatting and formulae in the "scripted" worksheet. This expression defines the Event.OnOpenPage function. A definition of this function may include statements that select lines of text to be processed as columns. This function will be called automatically before each page of the text-file is opened, This expression defines the Event.OnOpenRow function. A definition of this function may include statements that exclude lines of text or condition the import of text. This function will be called automatically before each line of the text-file is opened, This expression defines the Event.OnWriteX function. A definition of this function may include statements returning a text-string or number that will be written to the cell or column specified by the (location) part of the function-name. This function will be called automatically before the specified cell or column is written, Event functions are called automatically by L4X as text is imported. The contents of the fields in the table parameters passed to this function reflect the page and line of the input text-file being processed at the time when this function is called. This expression executes the Sheet.Write() function. Use of this function is not recommended but is permitted for backwards compatibility. Please specify a value for field Sheet.Out.row instead.
If used, the Sheet.Write() function call must be the last statement in a script.
This expression calls the Lua strsub function. It returns another string, which is a substring of the first (string) parameter starting at the second (index) parameter and running until the third (index) parameter. strfind function. It searches the first (string) parameter for the first sub-string that matches the second (string) parameter. If it finds a match, then strfind returns the indices of the first parameter where this matching sub-string starts and ends, otherwise, it returns nil. The third (optional) parameter specifies where to start the search, its default value is 1. A value of 1 for the fourth optional parameter turns off Lua's advanced pattern matching features. You may need to use this or a similar expression, to condition processing in any Event function that you define.Please note that, because your script has not set values for the Column.Source table, the text-strings imported by this Column. table will be extracted from every line of the selected text-file. Please see the L4X language summary for information about Selecting Lines of Text
Your script has set values for the Column.Source table, Please see the L4X language summary for information about Selecting Lines of Text
Please note that, because this reserved L4X table already exists, you do not have to construct and assign a new table in order to change the value of one field, instead you can assign a value directly by indexing the table by a field-name: -- specifies the start text-line for column processing. Column.Source.fromline = 10
The parameter values passed to this function depend on the position and length of the text that you have previously selected in the Input Text form.