Tag: File operations

This article explains various operations over a big file, illustrates how to make the computation faster using parallel processing, and gives concise sample programs in esProc SPL.

In real-world businesses, we often need to generate Excel files of various formats based on structured data of different sources. Those Excel formats include pure data export, export of huge amounts of data, specifying display properties, fill of fixed rows and columns, property display according to dynamic condition, groups with detailed data and aggregates, crosstab, etc.

This article illustrates how to parse Excel files of different formats and sizes, including the common row-wise format, complicated table headers, free-style format, crosstab, main & sub tables, and big files, into structured data, and provides sample programs in esProc SPL.

This article explains methods of performing distinct operation on small files and big files, and offers sample program in esProc SPL. Those methods include removing or retaining duplicates by rows or by key filed.

This article illustrates the comparison of two text files to find their commons and differences and offers sample programs in esProc SPL.

This article explains how to merge multiple text files or Excel files into one file, and split a text file or Excel file into multiple smaller ones. It illustrates several types of scenarios and offers sample programs in esProc SPL.Samples of Merging and Splitting Files!

Filter out the records that meet the conditions from the data table.