Category Archives: Text Processing

esProc Joins a Structured Text file with a JSON File

structure.txt is a tab-separated structured text file. json.txt contains non-structured JSON strings. We need to join the two files to create a new file result.txt. The original data is as follows: structure.txt Json.txt Result.txt esProc will first import json.txt as … Continue reading

Posted in Structured Text, Text Processing | Tagged , , | Leave a comment

Find Differences between Text Files with esProc

Problem source:http://bbs.csdn.net/topics/360033579 Compare the following two text files of the same format and write the differences (different records) into a text file. Content of 1.txt: Proto      Local Address Foreign Address     State TCP 111.11.1.111:1975   221.181.70.12:5926       ESTABLISHED Content of 2.txt: Proto      Local … Continue reading

Posted in Text Processing | Tagged , , | Leave a comment

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. JAVA … Continue reading

Posted in Text Processing | Tagged , , , | Leave a comment

Find Differences between Text Files with esProc

Problem source:http://bbs.csdn.net/topics/360033579  . Compare the following two text files of the same format and write the differences (different records) into a text file. Content of 1.txt: Proto      Local Address Foreign Address     State TCP 111.11.1.111:1975   221.181.70.12:5926       ESTABLISHED Content of 2.txt: Proto      … Continue reading

Posted in Text Processing | Tagged , , | Leave a comment

Combine Text Files Conditionally with esProc

Problem source: http://bbs.csdn.net/topics/390507610 . There are multiple text files in a single directory which need to be combined according to specified conditions. The text files include, for example, 12345.txt, 12346.txt, 12347.txt, 2013070312345.txt, 2013070312346.txt, 2013070312347.txt and 2013070412347.txt. The combination result is shown … Continue reading

Posted in Text Processing | Tagged , , | Leave a comment

Export Dynamic Text Files to Database with esProc

Problem source: http://bbs.csdn.net/topics/330190185 . There are multiple text files in a certain directory. Each of their names includes one of the letters a/b/c at the beginning and a date. The letter is fixed while the date is dynamic. You need … Continue reading

Posted in Text Processing | Tagged , , | Leave a comment

esProc Improves Text Processing – Conditional Query on Big Files

During text processing, you often have the tasks of querying data from a big file on one or more conditions. Command line grep\cat command can be used to handle some simple situations with simple command yet low efficiency. Or high-level … Continue reading

Posted in Text Processing | Tagged , , , , | Leave a comment