Retrieve multiple columns from a csv file to generate a new file #eg23

I have a standard format csv file:

Image description
I need to use Java to do this: Take column names as the parameter to retrieve multiple columns and save them as a new file. For example, when the parameter is “ID,Name,Gender”, the expected new file is as follows:

Image description
Write the following SPL code:

=T(\”d:\result.csv\”:T(\”d:\data.csv\”,${arg_cols}))

T()function parses a file or writes data of a file to a new one, where we can specify column names; ${} treats a string as an expression to execute.

Read How to Call a SPL Script in Java to find how to integrate SPL into a Java application.
Source:https://stackoverflow.com/questions/69819686/how-to-extract-csv-columns-with-the-specific-header-names-and-output-to-a-new-fi


Discover more from Coursity

Subscribe to get the latest posts sent to your email.

Leave a Comment

Your email address will not be published. Required fields are marked *

Discover more from Coursity

Subscribe now to keep reading and get access to the full archive.

Continue reading

Scroll to Top