Filter Rows and Sort a CSV Naturally (Room 2 before Room 10)

Created by

Data Done Right

Actor

Dataset Transform: Rename, Flatten, Filter & Sort Columns

Filter a pasted CSV with AND/OR rules, remove rows by regex, sort with natural order so Room 2 comes before Room 10, number the rows and compute years of service. Replace the CSV with your own file URL or dataset.

Try for free

Dataset Transform: Rename, Flatten, Filter & Sort Columnsdata-done-right/dataset-transform

Name

Price

Price incl. tax

+4 fields

Input

Pasted CSV or JSON text

name:staff

format:csv

text:employee,room,department,salary,start Dana Cole,Room 10,Sales,52000,2023-04-01 Eli Park,Room 2,Support,41000,2022-09-15 Fay Ross,Room 1,Sales,61000,2021-01-10 Gus Hill,Room 11,Support,38000,2024-02-01 Hana Ito,Room 3,Sales,47000,2020-07-20 Ivo Zed,Room 9,Legal,90000,2019-05-05

Transform steps (ordered pipeline)(required)

op:filter+5

where

Output fields

Name

Price

Price incl. tax

Seller

Country

How it works

Sign up on Apify or log in

The Dataset Transform: Rename, Flatten, Filter & Sort Columns Actor is ready to run with the inputs already set for "Filter Rows and Sort a CSV Naturally (Room 2 before Room 10)". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Filter Rows and Sort a CSV Naturally (Room 2 before Room 10)" task

The Dataset Transform: Rename, Flatten, Filter & Sort Columns Actor will start running based on the input automatically. You can also change all the input fields, like pasted csv or json text and transform steps (ordered pipeline), to match your specific use case.

Receive the "Filter Rows and Sort a CSV Naturally (Room 2 before Room 10)" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as ID, name, price, and more.