How to Store Specified CSV Columns to a New File

Problem description & analysis

Below is data in CSV file csv.csv:

undefined

upc14 column is the logically unique index by which data should be ordered. Get this column and name column to store them as a text file as follows:

undefined

Solution:

We write the following script p1.dfx in esProc:

A

1

=file("csv.csv").import@tc(upc14:string,name)

2

=A1.sort(upc14)

3

=file("result.txt").export@t(A2)

Code description:

A1   Read string type upc14 column and name column from the CSV file.

A2  Sort A1’s data by upc14 column.

A3  Export A2’s result to result.txt.

See How to Call an SPL Script in Java to learn about the way of integrating the SPL code with a Java program.

Q & A Collection

https://stackoverflow.com/questions/64070823/is-it-possible-to-extract-the-key-set-from-a-linkedhashmap-apply-a-sorting-algo