Category Archives: Program Language

esProc Assists Java in Merging Text Files to Excel

Problem source:http://bbs.csdn.net/topics/390842850  . In this case, you need to merge data from all text files in a given directory and export it to an Excel file. Each of these text files has tab-seperated data with one row and three columns. … Continue reading

Posted in esProc/R/Python/Perl, Program Language, Structured Data Process | Tagged , , , , | Leave a comment

esProc Assists Java to Retrieve Text Files

Java provides functions for handling the basic file processing, which refers to the retrieval of small text files, in a simple, unstructured way. But in handling files requiring structured format, holding data of various formats and having particular requirements, or … Continue reading

Posted in Application, Program Language | Tagged , , | Leave a comment

esProc Assists Java to Query Big Text Files

Sometimes you need to query a big text file, instead of the database. In those cases, you need to retrieve the file in a stream style to perform the query algorithm, in which parallel processing is required in order to … Continue reading

Posted in esProc/R/Python/Perl, Program Language, Structured Data Process | Tagged , , , | Leave a comment

esProc Simplifies SQL-style Computations – Record Splitting

Programmers often encounter complicated SQL-style computations during database application development. Record splitting, for example, is to split a record separated by a certain separator into multiple ones. For different databases, SQL has various problems like poor syntax support and the … Continue reading

Posted in esProc/R/Python/Perl, Program Language, SQL-related Puzzle, Structured Data Process | Tagged , , | Leave a comment

esProc Simplifies SQL-style Computations – Arrange Multilayered Data in One Column

We are often confronted with complicated SQL-style computations during developing data base applications. For instance, arrange grouped data into one column in certain order, making marks for different types of groups and detail data, as shown in the following:   … Continue reading

Posted in Program Language, SQL-related Puzzle | Tagged , , | Leave a comment

esProc Simplifies SQL-style computations – Ungrouping

During database application development, we often need to handle complicated SQL-style computations. One of them is the ungrouping, that is, the opposite process of grouping and summarizing which requires, for example, splitting each record into multiple records. We cannot realize … Continue reading

Posted in Program Language, Structured Data Process | Tagged , , | Leave a comment

esProc Helps Process Structured Text in Java – Grouping and Summarizing

Following problems will arise if you perform conditional filtering on text files in Java alone: The text file is not a database, so it cannot be accessed by SQL. The code needs to be modified if the expression of grouping … Continue reading

Posted in Program Language, Structured Data Process | Tagged , , , , | Leave a comment