DEV Community

Judy
Judy

Posted on

2 1 1 1 1

Perform Distinct on Ordered Numbers in a Text File #eg61

Problem description & analysis

Below is data in text file txt.txt:

Image description
Each row in the text file contains a number. There are duplicates and rows are already sorted. We are trying to trim the file to remove the duplicates and generate a new ordered file, as shown below:

Image description
Solution

Write the following script p1.dfx in esProc:

Image description
Explanation:

A1   Import the txt data; @i option enables returning a sequence when the result set has only one column.

A2  Perform distinct on A1’s ordered sequence and export result to result.txt.

Explanation:

A1   Import the txt data; @i option enables returning a sequence when the result set has only one column.

A2  Perform distinct on A1’s ordered sequence and export result to result.txt.

SPL open source address

Download

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

Top comments (0)

Heroku

This site is powered by Heroku

Heroku was created by developers, for developers. Get started today and find out why Heroku has been the platform of choice for brands like DEV for over a decade.

Sign Up