Sponsored Content
Top Forums Shell Programming and Scripting Transpose multi-line records into a single row Post 302531431 by daveyabe on Thursday 16th of June 2011 06:30:14 PM
Old 06-16-2011
Transpose multi-line records into a single row

Now that I've parsed out the data that I desire I'm left with variable length multi-line records that are field seperated by new lines (\n) and record seperated by a single empty line ("")

At first I was considering doing something like this to append all of the record rows into a single row:

Code:
awk 'BEGIN {FS= "\n";RS=""} {print $1,$2,$3,$4,$5,etc. > "NEWdata.txt" }' data.txt

Then I realized that these are not fixed length records, they're each a different number of rows. Is there an easy way around this?? Thanks!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK Multi-Line Records Processing

I am an Awk newbie and cannot wrap my brain around my problem: Given multi-line records of varying lengths separated by a blank line I need to skip the first two lines of every record and extract every-other line in each record unless the first line of the record has the word "(CONT)" in the... (10 Replies)
Discussion started by: RacerX
10 Replies

2. Shell Programming and Scripting

How to use Perl to merge multi-line into single line

Hi, Can anyone know how to use perl to merge the following multi-line information which beginning with "BAM" into one line. For each line need to delete the return and add a space. Please see the red color line. ******Org. Multi-line) BAM admin 101.203.57.22 ... (3 Replies)
Discussion started by: happyday
3 Replies

3. Shell Programming and Scripting

Capturing multi-line records containing known value?

Some records in a file look like this, with any number of lines between start and end flags: /Start Some stuff Banana 1 Some more stuff End/ /Start Some stuff End/ /Start Some stuff Some more stuff Banana 2 End/ ...how would I process this file to find records containing the... (8 Replies)
Discussion started by: cs03dmj
8 Replies

4. UNIX for Dummies Questions & Answers

Alphabetical sort for multi line records contains in a single file

Hi all, I So, I've got a monster text document comprising a list of various company names and associated info just in a long list one after another. I need to sort them alphabetically by name... The text document looks like this: Company Name: the_first_company's_name_here Address:... (2 Replies)
Discussion started by: quee1763
2 Replies

5. Shell Programming and Scripting

Merge multi-line output into a single line

Hello I did do a search and the past threads doesn't really solve my issue. (using various awk commands) I need to combine the output from java -version into 1 line, but I am having difficulties. When you exec java -version, you get: java version "1.5.0_06" Java(TM) 2 Runtime... (5 Replies)
Discussion started by: flagman5
5 Replies

6. Shell Programming and Scripting

Joining multi-line output to a single line in a group

Hi, My Oracle query is returing below o/p ---------------------------------------------------------- Ins trnas value a lkp1 x a lkp1 y b lkp1 a b lkp2 x b lkp2 y ... (7 Replies)
Discussion started by: gvk25
7 Replies

7. UNIX for Dummies Questions & Answers

Remove multi line and single line comments

Hi, I am trying to remove multi line and single line comments like examples below I have tried this pattern. it works fine for single line comments and multi line comments in a single line only. but this fails when the comments are extended in multiple lines as shown in the comment 2 of... (3 Replies)
Discussion started by: ahmedwaseem2000
3 Replies

8. Shell Programming and Scripting

Help with reformat single-line multi-fasta into multi-line multi-fasta

Input File: >Seq1 ASDADAFASFASFADGSDGFSDFSDFSDFSDFSDFSDFSDFSDFSDFSDFSD >Seq2 SDASDAQEQWEQeqAdfaasd >Seq3 ASDSALGHIUDFJANCAGPATHLACJHPAUTYNJKG ...... Desired Output File >Seq1 ASDADAFASF ASFADGSDGF SDFSDFSDFS DFSDFSDFSD FSDFSDFSDF SD >Seq2 (4 Replies)
Discussion started by: patrick87
4 Replies

9. Shell Programming and Scripting

Multi line log files to single line format

I want to read the log file which was generate from other command . And the output was having multi line in log files for job name and server name. But i need to make all the logs on one line Source file 07/15/2018 17:02:00 TRANSLOG_1700 Server0005_SQL ... (2 Replies)
Discussion started by: ranjancom2000
2 Replies

10. UNIX for Beginners Questions & Answers

Combine multi-row cell into a single line

My CSV file looks similar to this example (the K, L, and M are in the same cell as J but each on a new line within that cell): 1, A, B, C, D 2, E, F, G, H 3, I, J N, O, K L M, 4, P, Q, R, S I would like to have it look like this: 1, A,... (6 Replies)
Discussion started by: Kim Ashby
6 Replies
TCFMGR(1)							   Tokyo Cabinet							 TCFMGR(1)

NAME
tcfmgr - the command line utility of the fixed-length database API DESCRIPTION
The command `tcfmgr' is a utility for test and debugging of the fixed-length database API and its applications. `path' specifies the path of a database file. `width' specifies the width of the value of each record. `limsiz' specifies the limit size of the database file. `key' specifies the key of a record. `value' specifies the value of a record. `file' specifies the input file. tcfmgr create path [width [limsiz]] Create a database file. tcfmgr inform [-nl|-nb] path Print miscellaneous information to the standard output. tcfmgr put [-nl|-nb] [-sx] [-dk|-dc|-dai|-dad] path key value Store a record. tcfmgr out [-nl|-nb] [-sx] path key Remove a record. tcfmgr get [-nl|-nb] [-sx] [-px] [-pz] path key Print the value of a record. tcfmgr list [-nl|-nb] [-m num] [-pv] [-px] [-rb lkey ukey] [-ri str] path Print keys of all records, separated by line feeds. tcfmgr optimize [-nl|-nb] path [width [limsiz]] Optimize a database file. tcfmgr importtsv [-nl|-nb] [-sc] path [file] Store records of TSV in each line of a file. tcfmgr version Print the version information of Tokyo Cabinet. Options feature the following. -nl : enable the option `FDBNOLCK'. -nb : enable the option `FDBLCKNB'. -sx : the input data is evaluated as a hexadecimal data string. -dk : use the function `tcfdbputkeep' instead of `tcfdbput'. -dc : use the function `tcfdbputcat' instead of `tcfdbput'. -dai : use the function `tcfdbaddint' instead of `tcfdbput'. -dad : use the function `tcfdbadddouble' instead of `tcfdbput'. -px : the output data is converted into a hexadecimal data string. -pz : do not append line feed at the end of the output. -m num : specify the maximum number of the output. -pv : print values of records also. -rb lkey ukey : specify the range of keys. -ri str : specify the interval notation of keys. -sc : normalize keys as lower cases. This command returns 0 on success, another on failure. SEE ALSO
tcftest(1), tcfmttest(1), tcfdb(3), tokyocabinet(3) Man Page 2011-02-12 TCFMGR(1)
All times are GMT -4. The time now is 02:25 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy