Use of From ,To and Select buttons in Conditional Delete...

[Anonymous]

Hi,

Please help me to know the use of 'From','To' and 'Select' buttons that  are found  after selecting   any text  file from 'Table Files...' in edit script window,

'File Wizard : Type' window appears ,

Then click on 'Next' button , 'File Wizard : Transform' window will appear and

then follow  the following steps to reach  'From' ,'To' and 'Select' Buttons :

Enable Transformation Step >> Conditional Delete >> Range (Radio button)

Thanks

[Gysbert_Wassenaar · Accepted solution]

From the help file:

Specify Row Condition

This dialog can be opened via the File Wizard : Transform dialog's Garbage page (the Conditional Delete button), the Column page (the New... button) or the Unwrap page (the Conditional Unwrap button). Here it is possible to define a logical condition for selection of one or several rows. Depending on the context the rows that are defined are either deleted, copied to a new column and split the table in several parts.

In the Condition group it is possible to specify a condition where a column equals a specific value or another column, a range of records or all records. Several conditions can be applied together. After defining a condition press the Add button to include it in the transformation.

Compare with value	Matches the cell with a cell condition that can evaluate to true or false.
Compare with column	Matches the cell with the corresponding cell in another column.
Range	Selects x rows, then skips y rows. Starting and ending positions for this may be specified with indexes.
All Rows	Use this condition if all rows should be selected.
Column	Sets the column number on which the condition should be applied.
From	Only visible in Range mode. Sets the row number from which rows should be deleted or a second condition should be applied.
To	Only visible in Range mode. Sets the row number to which rows should be deleted or a second condition should be applied.
Select	Only visible in Range mode. Here it is possible to set whether rows should be selected or skipped cyclically, e.g. cyclically select two rows, then skip one. If all rows should be used, Select should be set to 1 and Skip should be set to 0.
Options	In this subgroup it is possible to specify modifiers for the selection. Case Sensitive Enable this option if comparisons should be case sensitive. Not Enable this option if the selection criteria should be inverted.
Conditions (AND)	In this group the conditions specified and included in the transformation are seen. A logical AND is applied between conditions. Add Adds the current condition to the list. Remove Removes a selected condition from the list.

[Anonymous]

Thanks

[#4]

I was wandering for this solution and it saved me