dev-resources.site

for different kinds of informations.

Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

Published at

8/27/2024

Categories

sql

development

programming

esproc

Author

esproc_spl

Main Article

https://dev.to/esproc_spl/java-fill-each-row-having-a-null-value-in-a-csv-file-with-values-in-the-directly-previous-row-eg32-4ng6

Categories

4 categories in total

Author

10 person written this

Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

In the csv file below, Number column has some null values.

Task: Use Java to modify the file. The rule is like this: When a Number value is null, modify values of the current row as those of the directly previous row and save result as a new csv file.

Write the following SPL statement:

=T(""result.csv"":T(""data.csv"").(~=if(Number,~,~[-1])))

T()function reads data from or writes data to a csv file. ~ is the current record, and ~[-1] represents the directly previous record.

Read How to Call a SPL Script in Java to find how to integrate SPL into a Java application.

SPL open source address

esproc Article's

30 articles in total

Add records that meet the criteria before each group after grouping ：From SQL to SPL

Multi combination condition grouping and aggregation #eg93

Split a Huge CSV File into Multiple Smaller CSV Files #eg69

Group & Summarize a CSV File #eg68

Getting positions of members according to primary key values #eg58

Getting members according to primary key values #eg63

How to Access Databases using One SQL Statement #eg71

Filter a CSV file and re-arrange it by category #eg60

Getting positions of members based on a specified condition #eg46

Convert Each Whites-space-separated Text Block into a Row #eg62

Perform Distinct on Ordered Numbers in a Text File #eg61

Parse a csv file having a primary-sub tables structure #eg41

Convert CSV Data into Multilevel JSON #eg56

Add a compute column to a csv file #eg40

SQL, in each group modify the null value of a specified column as its neighboring value #eg43

Get the whole group where at least one member meets the specified condition #eg36

Parse a csv file where field values are enclosed by quotation marks and contain carriage return #eg35

Replace Duplicate Digits in Every 9-digit Number in a Text File with Non-duplicate Ones #eg52

Reverse Rows in a Text File #eg51

The Difference between Each Value in a Certain Column and Its Previous One and Display Result

Java, perform COUNT on each group of a large csv file #eg33

SQL, extract unique values of JSON format field from each group #eg42

Multi-condition filtering #eg48

Getting members based on a specified condition #47

Read specified columns from a csv file #eg44

Something could double the development efficiency of Java programmers

Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

currently reading

To Index Data is To Sort Data

Clear duplicate lines and lines having missing values from a csv file #eg24

SQL, Set different flags for different groups according to whether there are duplicate values #eg19

Featured ones:

abubakersiddique761