DEV Community

Judy
Judy

Posted on

3 1 1 1 1

How to Store Specified CSV Columns to a New File #eg77

Problem description & analysis

Below is data in CSV file csv.csv:

Image description
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:

Image description
Solution:

We write the following script p1.dfx in esProc:

Image description
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.

Open source SPL source address

Download

Image of Timescale

Timescale – the developer's data platform for modern apps, built on PostgreSQL

Timescale Cloud is PostgreSQL optimized for speed, scale, and performance. Over 3 million IoT, AI, crypto, and dev tool apps are powered by Timescale. Try it free today! No credit card required.

Try free

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay