Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2246
|
|
[img]https://a.fsdn.com/con/app/proj/textwedge/screenshots/123159.jpg[/img]
TextWedge is a utility for splitting text files. It operates through an editor interface, with
various dialog boxes for configuring the actions you want to perform. You can split on "chunk
size" or "number of lines per chunk" criteria, or you can split at lines containing any one of
multiple search strings (can do standard text search, or regular expression search).
If you use it in "Preview" mode (virtual splitting), it functions as a multi-string regular
expression search tool. Note that ALL operations occur against the editor contents, and
that the original text file is only read once, when you execute "File | Load". This means that
you can make any changes you like in the editor BEFORE you split, and the original file is
unaffected unless you explicitly save it.
I found it while looking to answer a question posted here:
In that example:
test.csv containing:
sno,employee name,address,location,zip code
1,aaaa,12/34,Hyderabad,500089
2,bbbb,12/35/44,chennai,500079
3,cccc,12/31/11,pune,500069
Cardnumber,cardname,card type,card limit
12345,visa,diamond,10000
2345,master,platinum,50000
Accno,bank name,branch code,Branch location
98765,sbi,23456,hyd
12457,citi,8765,usa
4444,axis,78767,India
was split into 3 files called test1.csv, test2.csv and test 3.csv, each containing 1 chunk of lines
How to make it with TextWedge (my post from computing.net):
1. I created your csv file in C:\Test\test.csv file and
2. Extract archive, and open TEXTWEDGE.exe.
3. Go to Dialogs and then choose Configure Standard Splitting.
4. In the first field replace /file/<#>.Txt with C:\Test\test<#>.csv
Note: test<#>.csv changes based on the name of your file, just 1 # means the name is test followed by 1 character.
5. In the second field called "Chunks are limited by" write 1.
It's the number of lines that delimits the text you want to split. The number of lines will be discarded (removed)
6. Click OK, now go to File - Load & Split and browse to your file and open it. You can check the test folder.
In this example it contains 3 new csv files called test1, test2, test3 with those 3 chunks of information split from test.csv main file. |
Download
_______________________________________
|
|
