Subscribe Bookmark RSS Feed

Is there a way to selectively import certain, non consecutive, lines from a CSV file using JSL?

jpol

Community Trekker

Joined:

Oct 11, 2015

Hi,

 

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.

 

list.png

 

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?

 

 

Open(

            "C:\D13N01.1_16.45.00.csv",

            columns(

                        Column( "CSV Detailed Wafer Report", Character, "Nominal" ),

                        Column( "c000002", Character, "Nominal" )

            ),

            Import Settings(

                        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" )

            )

);

 

 

 Thanks,

 

Philip

 

 

1 REPLY
Craige_Hales

Staff

Joined:

Mar 21, 2013

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.

Craige