11-12-2010
Splitting text file into 2 separate files ??
Hi All,
I am new to this forumn as well to the UNIX, I have basic knowledge of UNIX which I studied some years ago, now I have to do some shell scripting to load data into Oracle database using sqlldr utility, whcih I am able to do. I have a requirement where I need to do following operation.
I have one text file in which the data will be in following format for example
.................... FILE1.txt ....................
A1|1234561|010|065|
aaaaa
sssss
ddddd
fffff
A2|1234562|011|066|
qqqq
ww
eeeeeeee
r
A3|1234563|012|067|
ttttttttt
A4|1234564|013|068|
yyyyy
uuu
A5|1234565|014|069|
sdfsdfsd
werw345
feewwe
A6|1234566|015|060|
A7|1234567|016|061|
....................................................
Now from above file I have to split it into 2 different files for example
File_A.txt
....................................................
A1|1234561|010|065|
A2|1234562|011|066|
A3|1234563|012|067|
A4|1234564|013|068|
A5|1234565|014|069|
A6|1234566|015|060|
A7|1234567|016|061|
....................................................
File_B.txt
....................................................
aaaaa
sssss
ddddd
fffff
qqqq
ww
eeeeeeee
r
ttttttttt
yyyyy
uuu
sdfsdfsd
werw345
feewwe
....................................................
I am able to create the first file FILE_A.txt using awk command, but I am not able create the second FILE_B.txt
I just like to know is there any other quick way of creating 2 seperate files as mentioned above or I can use same awk command to create the second file FILA_B.txt
Any help is highly appreciated.
Regards
JC
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to split a file based on certain context inside the file. Is there a unix command that can do this? I have looked into split and csplit but it does not seem like those would work because I need to split this file based on certain text. The file has multiple records and I need to split this... (1 Reply)
Discussion started by: matrix1067
1 Replies
2. Shell Programming and Scripting
I'm trying to figure out how to do this efficiently with as little execution time as possible and I'm pretty sure using sed is the best way. However I'm new to sed and all the reading and examples I've found don't seem to show a similar exercise:
I have a long text file (i'll call it... (3 Replies)
Discussion started by: JeffV
3 Replies
3. UNIX for Dummies Questions & Answers
Hi, been searching Google for like an hour and I doubt I got the right keywords so might as well ask here.
What I need:
Before:
Article1.txt 564
Article2.txt 799
Article3.txt 349
Article4.txt 452
* Separate files over 400 wordcount *
After:
Article1.txt 564... (3 Replies)
Discussion started by: Richard2000
3 Replies
4. Shell Programming and Scripting
Hi,
I have a file which looks like this:
.I 1
some text
.A
this is the first line
.I 2
some text again
.B
this is the second line
.I 3
again some text
.C
this is the third line
I want to have my output like this in separate files: (7 Replies)
Discussion started by: shoaibjameel123
7 Replies
5. Shell Programming and Scripting
Hi All,
I have three separate text files which has only one line and i want to combine these lines in one text file which will have three lines.
cat file1.txt
abc
cat file2.txt
1265 6589 1367
cat file3.txt
0.98 0.36 0.5
So, I want to see these three lines in the... (9 Replies)
Discussion started by: senayasma
9 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a space delimited text file with multiple columns 102 columns. I want to break it up into 100 files labelled 1.txt through 100.txt (n.txt). Each text file will contain the first two columns and in addition the nth column (that corresponds to n.txt). The third file will contain the... (1 Reply)
Discussion started by: evelibertine
1 Replies
7. Shell Programming and Scripting
for making a summary
I have a CSV file which is transformed to .DAT. I have an AWK file which is supposing to do the mapping of the DAT file. The code from the AWK file is the one below.
The content of the DAT file looks like this (tab separated):
ODT AGE CDT CO SEX TIME VALUE COMMENT
... (1 Reply)
Discussion started by: grikoss
1 Replies
8. Shell Programming and Scripting
Hi
I have large text file consisting of five columns. Sample of the file is give below:
ed 2-4 12.0 commons that they depended on. मानवों नष्ट किया जिन पर वो आधारित थे।
ed 3-1 12.0 Almost E, but would be over. रचना करीब करीब ई तक जाती है, मगर तब तो नाटक ख़त्म हो... (2 Replies)
Discussion started by: my_Perl
2 Replies
9. Shell Programming and Scripting
Duplicate threads merged
Dear all,
I have been working with a very large text file manually. I'm ordering how to do this with a script. The gamma should be straightforward:
I just want split the text into multiple files. The file name should be "CP1", "TS1 for the second step", "PR1 for... (3 Replies)
Discussion started by: liuzhencc
3 Replies
10. Shell Programming and Scripting
Hello,
I have some large text files that look like,
putrescine
Mrv1583 01041713302D
6 5 0 0 0 0 999 V2000
2.0928 -0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0
5.6650 0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0
3.5217 ... (3 Replies)
Discussion started by: LMHmedchem
3 Replies
LEARN ABOUT REDHAT
dos2unix
dos2unix(1) General Commands Manual dos2unix(1)
NAME
dos2unix - DOS/MAC to UNIX text file format converter
SYNOPSYS
dos2unix [options] [-c convmode] [-o file ...] [-n infile outfile ...]
Options:
[-hkqV] [--help] [--keepdate] [--quiet] [--version]
DESCRIPTION
This manual page documents dos2unix, the program that converts plain text files in DOS/MAC format to UNIX format.
OPTIONS
The following options are available:
-h --help
Print online help.
-k --keepdate
Keep the date stamp of output file same as input file.
-q --quiet
Quiet mode. Suppress all warning and messages.
-V --version
Prints version information.
-c --convmode convmode
Sets conversion mode. Simulates dos2unix under SunOS.
-o --oldfile file ...
Old file mode. Convert the file and write output to it. The program default to run in this mode. Wildcard names may be used.
-n --newfile infile outfile ...
New file mode. Convert the infile and write output to outfile. File names must be given in pairs and wildcard names should NOT be
used or you WILL lost your files.
EXAMPLES
Get input from stdin and write output to stdout.
dos2unix
Convert and replace a.txt. Convert and replace b.txt.
dos2unix a.txt b.txt
dos2unix -o a.txt b.txt
Convert and replace a.txt in ASCII conversion mode. Convert and replace b.txt in ISO conversion mode. Convert c.txt from Mac to Unix
ascii format.
dos2unix a.txt -c iso b.txt
dos2unix -c ascii a.txt -c iso b.txt
dos2unix -c mac a.txt b.txt
Convert and replace a.txt while keeping original date stamp.
dos2unix -k a.txt
dos2unix -k -o a.txt
Convert a.txt and write to e.txt.
dos2unix -n a.txt e.txt
Convert a.txt and write to e.txt, keep date stamp of e.txt same as a.txt.
dos2unix -k -n a.txt e.txt
Convert and replace a.txt. Convert b.txt and write to e.txt.
dos2unix a.txt -n b.txt e.txt
dos2unix -o a.txt -n b.txt e.txt
Convert c.txt and write to e.txt. Convert and replace a.txt. Convert and replace b.txt. Convert d.txt and write to f.txt.
dos2unix -n c.txt e.txt -o a.txt b.txt -n d.txt f.txt
DIAGNOSTICS
BUGS
The program does not work properly under MSDOS in stdio processing mode. If you know why is that so, please tell me.
AUTHORS
Benjamin Lin - <blin@socs.uts.edu.au>
Bernd Johannes Wuebben (mac2unix mode) <wuebben@kde.org>
MISCELLANY
Tested environment:
Linux 1.2.0 with GNU C 2.5.8
SunOS 4.1.3 with GNU C 2.6.3
MS-DOS 6.20 with Borland C++ 4.02
Suggestions and bug reports are welcome.
SEE ALSO
unix2dos(1) mac2unix(1)
1995.03.31 dos2unix v3.0 dos2unix(1)