| User: kaili Tan -- 2018-12-18 << 1429 1431 >> |
| Hits: 2401 |
| Type: Text file splitter |
| Search all Text file splitter examples |
| Description: |
| I have a .csv file, and I want to extract the specified row to a new txt according to date, the exzample as follow. |
| Input Sample: |
| ---- L:4384 T:01-JAN-2010 00:00 0 0 0 0 0 0 0 0 1.2 3.2 4.5 0 1.2 3.1 4.5 5.6 0 0 0 0 0 7 8 9 4 5 61 2 3 0 2 5 56 4 ---- L:4385 T:02-JAN-2010 00:00 0 1.2 3.1 4.5 5.6 0 0 0 0 0 0 0 0 0 0 0 0 0 1.2 3.2 4.5 3 3.2 5.6 7.8 1.2 0 0 0 0 0 ---- L:4386 T:03-JAN-2010 00:00 0 0 0 0 0 0 0 0 1.2 3.2 4.5 7 8 9 4 5 61 2 3 0 2 5 56 4 0 1.2 3.1 4.5 7 0 0 0 0 0 |
| Output Sample: |
| 001.txt 0 0 0 0 0 0 0 0 1.2 3.2 4.5 0 1.2 3.1 4.5 5.6 0 0 0 0 0 7 8 9 4 5 61 2 3 0 2 5 56 4 002.txt 0 1.2 3.1 4.5 5.6 0 0 0 0 0 0 0 0 0 0 0 0 0 1.2 3.2 4.5 3 3.2 5.6 7.8 1.2 0 0 0 0 0 003.txt 0 0 0 0 0 0 0 0 1.2 3.2 4.5 7 8 9 4 5 61 2 3 0 2 5 56 4 0 1.2 3.1 4.5 7 0 0 0 0 0 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open source text file 2. ctrl-h open 'replace' dialog * set 'replace unit' to 'Line' * set 'search for pattern' to: * set 'replace with pattern' to: * set 'output file' to * change the '>' to at the left of 'output file'. * click 'settings' tab: * set 'para start' to 'Other': * set 'para end' to 'None' 3. click 'replace', splitted files will be in d:\test\ folder. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Settings_Window |
Similar Examples: |
| How to split a text file according to first word in each line? (74%) How to split a text file with specified start and end line and name? (68%) How to convert a text file to specified format? (67%) How to split a csv file according to the value of column A? (67%) How to split a large text file into specified various number of lines? (65%) How to delete blocks of text containing a specified string? (63%) How to split a text file to different files according to first word in each line? (63%) How to split a text file to different files according to first word in each line? (63%) |
Check Demo of Text file splitter |
| Keywords: |
| how to split a text file according split by paragraph tags non splitter text file splitter tag paragraph paragra acc csv file splitter open source txt to csv split text file splitter by date txt file splitter row split csv according extract paragraph split csv files by text folder date |