I have a need to concatenate data from several hundred CSV files which are generated by a manufacturing measurement tool.
Only "Wafer" and "Recipe" details are required in this first concatenation, Rows 1 & 8 below.
I was hoping to edit the import script below such that in place of "Lines To read( 8 )" there could be something like "Read Lines (1,8)"
Is there some code which would allow this?
Column( "CSV Detailed Wafer Report", Character, "Nominal" ),
Column( "c000002", Character, "Nominal" )
End Of Line( CRLF, CR, LF ),
End Of Field( Comma, CSV( 0 ) ),
Strip Quotes( 1 ),
Use Apostrophe as Quotation Mark( 0 ),
Use Regional Settings( 0 ),
Scan Whole File( 1 ),
Treat empty columns as numeric( 0 ),
CompressNumericColumns( 0 ),
CompressCharacterColumns( 0 ),
CompressAllowListCheck( 0 ),
Labels( 1 ),
Column Names Start( 1 ),
Data Starts( 7 ),
Lines To read( 8 ),
Year Rule( "20xx" )
You could read it twice, once for each line. Or you could stop after 8 lines and delete the unwanted rows. Your idea is good, but there is no current plan to implement it.