|
|
Sponsored Content
Top Forums
UNIX for Beginners Questions & Answers
Merging multiple lines into single line based on one column
Post 302987792 by raju2016 on Friday 16th of December 2016 02:31:28 AM
12-16-2016
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a H U G E file with over 1million entries in it.
Looks something like this:
USER0001|DEVICE001|VAR1
USER0001|DEVICE001|VAR2
USER0001|DEVICE001|VAR3
USER0001|DEVICE001|VAR4
USER0001|DEVICE001|VAR5
USER0001|DEVICE001|VAR6
USER0001|DEVICE002|VAR1
USER0001|DEVICE002|VAR2... (4 Replies)
Discussion started by: SoMoney
4 Replies
2. Shell Programming and Scripting
The symbols are \t and \t\t (note: not tab)
If the line starts with \t merge them into a single line upto symbol \t\t
\t\t to end and start new line
I able to join in a single line but not ending at \t\t and I completely confused
help would be appreciated:b::D
Input
\ta tab XXXXXXXXXX
\te... (5 Replies)
Discussion started by: repinementer
5 Replies
3. Shell Programming and Scripting
Dear All,
I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...):
ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N
ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Discussion started by: tomasl
3 Replies
4. Shell Programming and Scripting
Hi,
I have a requirement with,
No~Dt~Notes
1~2011/08/1~"aaa
bbb
ccc
ddd
eee
fff
ggg
hhh"
Single column alone got splitted into multiple lines.
I require the output as
No~Dt~Notes
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh"
mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies
5. Shell Programming and Scripting
This is related to one of my previous post.. I have huge file currently I am using loop to read file and checking each line to build this single record, its taking much much time to parse those records.. I thought there should be a way to do this in awk or sed.
I found this code in this forum... (7 Replies)
Discussion started by: Vasan
7 Replies
6. Shell Programming and Scripting
Hi,
1. Each message starts with date
2. There is blank line between each message
3. Each message does not contain same number of lines.
Any help in merging multiple lines in each message to a single line is much appreciated.
AIX: Korn Shell
Error log file looks like below.
... (5 Replies)
Discussion started by: bala123
5 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I have a file which I'd like to merge lines based on duplicates in one column while keeping the info for other columns. Let me simplify it by an example:
File
ESR1 ANASTROZOLE NA FDA_approved
ESR1 CISPLATIN NA FDA_approved
ESR1 DANAZOL agonist NA
ESR1 EXEMESTANE NA FDA_approved... (3 Replies)
Discussion started by: JJ001
3 Replies
8. Shell Programming and Scripting
Hello,
I am trying to return a time multiple times from a file that has varying output just before the time instance, i.e.
cat jumped
cat jumped
cat jumped
time = 1.1
cat jumped
cat jumped
time = 1.2
cat jumped
cat jumped
time = 1.3
In this case i would like to output a time.txt... (6 Replies)
Discussion started by: ryddner
6 Replies
9. Shell Programming and Scripting
I would like to merge two tables based on column 1:
File 1:
1 today
1 green
2 tomorrow
3 red
File 2:
1 a lot
1 sometimes
2 at work
2 at home
2 sometimes
3 new
4 a lot
5 sometimes
6 at work (4 Replies)
Discussion started by: BSP
4 Replies
10. UNIX for Beginners Questions & Answers
I have code as below
# create temporary table `temp4277`(key(waybill_no))
select waybill_no,concat_ws('',card_type,card_series_no) cardinfo
from rfid_temp_ticket where waybill_no='4277'
group by... (4 Replies)
Discussion started by: kaushik02018
4 Replies
LEARN ABOUT DEBIAN
trackgen
Terrain generator for tracks(6) Games Terrain generator for tracks(6) NAME
trackgen - Terrain generator for tracks SYNTAX
trackgen -c category -n name [-a] [-m] [-s] [-S] [-E <n> [-H <nb>]] DESCRIPTION
This manual describes the Ac3d compiler application that is shipped with the game TORCS. OPTIONS
-c category track category (road, oval, dirt...) -n name track name -b draw bump track -B Don't use terrain border (relief supplied int clockwise, ext CC) -a draw all (default is track only) -s split the track and the terrain -S split all -E <n> save elevation file n 0: all elevatation files 1: elevation file of terrain + track 2: elevation file of terrain with track white 3: track only 4: track elevations with height steps -H <nb> nb of height steps for 4th elevation file [30] SEE ALSO
torcs(6) AUTHOR
This manual page was writen by Rudy Godoy <rudy@kernel-panik.org>, for the Debian GNU/Linux system (but may be used by others). Rudy Godoy 1.2 Terrain generator for tracks(6)