DEV Community

Judy
Judy

Posted on

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

Top comments (1)

Collapse
 
esproc_spl profile image
Judy

SPL open source address:github.com/SPLWare/esProc/stargazers