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
Wordpress development services. Free 2025 jamb cbt questions and answers commercial free jamb answers commercial chokes.