07-24-2007
splitting a column into rows
I have a column of data of the format:
EDITORIAL OPED
193987141
193986701
193987451
193986321
STATISTICS
193986351
COLUMN
EDITORIAL OPED
193987171
NEWS
193321171
NEWS
193321111
NEWS
193320891
NEWS
193321841
NEWS
193320821
BUSINESS
BUSINESS
193323581
i would like to take this column and separate it into several columns so it looks like this.
EDITORIAL OPED 193987141
193986701
193987451
193986321
STATISTICS 193986351
COLUMN eDITORIAL OPED 193987171
NEWS 193321171
NEWS 200057287
Can anyone offer any suggestions?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I'm, new to shell scripting, I have a requirement where I have to split an incoming file into separate files each containing a maximum of 3 million rows.
For e.g: if my incoming file say In.txt has 8 mn rows then I need to create 3 files, in which two will 3 mn rows and one will contain 2... (2 Replies)
Discussion started by: wahi80
2 Replies
2. Linux
Hello,
Please help me. I have hundreds of text files composed of several rows of information and I need to separate each row into a new text file. I was trying to figure out how to split the text file into different text files, based on each row of text in the original text file. Here is an... (2 Replies)
Discussion started by: dvdrevilla
2 Replies
3. Shell Programming and Scripting
Hi, I have flat file with following format
Col1, Col2, Col3, Col4
---------------------------------
r1_c1, r1_c2, r1_c3, abc | def | efg
r2_c1, r2_c2, r2_c3, abcwdw | dweweef | efg | ijk
r3_c1, r3_c2, r3_c3, abaac
...........
The first three columns contain only one entry per... (3 Replies)
Discussion started by: nick2011
3 Replies
4. Shell Programming and Scripting
Dear All,
I have a data file input.csv like below. (Only five column shown here for example.)
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
3,2,4,5,6
5,3,5,5,6
From this I want the below output
Data1,StepNo,Data2,Data3,Data4
2,1,3,4,5
3,1,5,6,7
where the second column... (4 Replies)
Discussion started by: ks_reddy
4 Replies
5. UNIX for Dummies Questions & Answers
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
e.g.
file 01
James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
My requisite is to split a single column of phonemes seperated by spaces into multiple rows.
my input file is:
a
dh
u
th
a
qn
ch
A
v
U
r
k
my o/p should be like:
adhu a dh u (3 Replies)
Discussion started by: girlofgenuine
3 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks!
Input:
1 1 ABC DEF
2 2 IJK LMN
1 2 ZYX OPW
Output:
1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
2 Replies
8. Shell Programming and Scripting
Hi,
I have file with values as below
1~ab~456~ac:bd:de:ef~yyyy-mm-dd
2~cd~458~af:fg:ty:er:ty:uj:io:~yyyy-mm-dd
I want the o/p as for frist row
1~ab~456~ac~yyyy-mm-dd
1~ab~456~bd~yyyy-mm-dd
1~ab~456~de~yyyy-mm-dd
1~ab~456~ef~yyyy-mm-dd
and for the second row
2~cd~458~af~yyyy-mm-dd... (4 Replies)
Discussion started by: rithushri
4 Replies
9. Shell Programming and Scripting
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies
10. Shell Programming and Scripting
Hi,
I have a requirement that has 50-60 million records that we need to split a delimited string (Delimeter is newline) into rows.
Source Date:
SerialID UnidID GENRE
100 A11 AAAchar(10)BBB
200 B11 CCCchar(10)DDD(10)ZZZZ
Field 'GENRE' is a string with new line as delimeter and not sure... (5 Replies)
Discussion started by: techmoris
5 Replies
LEARN ABOUT REDHAT
rc.news
RC.NEWS(8) InterNetNews Documentation RC.NEWS(8)
NAME
rc.news - Start or stop INN daemons
SYNOPSIS
rc.news [start | stop]
DESCRIPTION
rc.news can be used to start or stop innd and supporting programs. It checks to make sure INN is not already running, handles cases of
unclean shutdown, finishes up tasks which might have been interrupted by the preceding shutdown, e-mails certain boot-time warnings to
newsmaster (as set in inn.conf), and is generally safer and easier than starting and stopping everything directly. It needs to be run as
the news user so that files in pathrun are created with the right ownership (though this is less important for "rc.news stop").
Programs run and stopped by this script include:
o Always: innd is started or stopped.
o If doinnwatch is true in inn.conf: innwatch is started and stopped.
o If docnfsstat is true in inn.conf: cnfsstat is started and stopped.
o If ovmethod is set to "ovdb" in inn.conf: ovdb_init is run; ovdb_server and ovdb_monitor are stopped.
o If rc.news.local exists in pathbin: rc.news.local is run with argument "start" or "stop" (to perform site-specific startup or shutdown
tasks).
OPTIONS
"start"
If the first argument is "start", or no first argument is given, rc.news initiates INN startup.
"stop"
If the first argument is "stop", rc.news initiates INN shutdown. It is recommended to throttle the server first as described in
ctlinnd(8).
EXAMPLES
To start INN and leave certain error messages going to the terminal:
su - news -c <pathbin in inn.conf>/rc.news
To run INN at startup time from appropriate system boot scripts:
su - news -c <pathbin>/rc.news >/dev/console
To stop INN (throttling first):
<pathbin>/ctlinnd throttle reason
su - news -c '<pathbin>/rc.news stop'
BUGS
Running "rc.news start" as root is never the right thing to do, so we should at minimum check for this and error, or perhaps change
effective user ID.
HISTORY
// FIXME: any attribution for rc.news itself?
This manual page written by Jeffrey M. Vinocur <jeff@litech.org> for InterNetNews.
$Id: rc.news.pod 9340 2011-08-16 13:50:19Z iulius $
SEE ALSO
ctlinnd(8), cnfsstat(8), inn.conf(5), innwatch(8), ovdb(5).
INN 2.5.3 2011-08-22 RC.NEWS(8)