Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Awk multiple lines with 4th column on to a single line
Top Forums Shell Programming and Scripting Awk multiple lines with 4th column on to a single line Post 302560734 by Vasan on Friday 30th of September 2011 05:39:21 PM
Old 09-30-2011
Thanks.

But I am not getting the right output..

Here is what I got
Code:
$ cat FILENAME|awk -F"|" '{print $1,$2,$4}' |tr " " "\|"
XXXXXXXXXX1|07/24/2007|aaaaaaaaaaabbbbbbbbccccccccccccc
XXXXXXXXXX1|07/24/2007|sometxt
XXXXXXXXXX1|07/30/2007|some_random_text
XXXXXXXXXX1|07/30/2007|new_random.
XXXXXXXXXX1|09/27/2007|some_nre_random_test
XXXXXXXXXX1|09/27/2007|blabla
XXXXXXXXXX1|09/27/2007|fixed_text_random
XXXXXXXXXX1|11/14/2007|blabla
XXXXXXXXXX1|11/28/2007|junk_text
XXXXXXXXXX2|12/21/2007|Notes


Am I missing something..

Thanks
Last edited by Franklin52; 10-01-2011 at 05:56 AM.. Reason: Please use code tags for data and code samples, thank you
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replacing multiple lines with single line

Can any one give me the idea on replacing multiple blank lines with a single blank line? Please conside it for a file having more than 100 number of characters. Regards, Siba (3 Replies)
Discussion started by: siba.s.nayak
3 Replies

2. Shell Programming and Scripting

Awk multiple lines with 3rd column onto a single line?

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

3. Shell Programming and Scripting

Multiple lines into a single line

Hi, I've some files with the following data and i need to convert the lines between the separator ---, into a single line. I've tried with the paste cmd but my main problem is that the number of lines between the separator is not fix, it can very between 1-4 lines. Input --- 2010-02-22... (4 Replies)
Discussion started by: RickyC9999
4 Replies

4. Shell Programming and Scripting

Combine multiple lines in single line

This is related to one of my previous post but now with a slight difference: I need the "Updated:" to be in one line as well as the "Information:" on one line as well. These are in multiple lines right now as seen below. These can have 2 or more lines that needs to be in one line. System name:... (8 Replies)
Discussion started by: The One
8 Replies

5. Shell Programming and Scripting

Multiple lines in a single column to be merged as a single line for a record

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

6. Shell Programming and Scripting

Awk match multiple columns in multiple lines in single file

Hi, Input 7488 7389 chr1.fa chr1.fa 3546 9887 chr5.fa chr9.fa 7387 7898 chrX.fa chr3.fa 7488 7389 chr21.fa chr3.fa 7488 7389 chr1.fa chr1.fa 3546 9887 chr9.fa chr5.fa 7898 7387 chrX.fa chr3.fa Desired Output 7488 7389 chr1.fa chr1.fa 2 3546 9887 chr5.fa chr9.fa 2... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

7. Shell Programming and Scripting

Making multiple lines as single line

Hi All, I have a spool file which as shown below. I want to make it as single line after every semicolon. In this case there should be 2 lines in vi editor. I am not used to use sed so could you guys please help me out ? exec spk_dba.sp_runsql('ALP','CREATE DATABASE LINK "TEST" CONNECT TO... (2 Replies)
Discussion started by: nicolas38
2 Replies

8. Shell Programming and Scripting

Coverting multiple lines to a single line

Hi all, I have a requirement to covert multiple lines in a comma delimited file to a single line through shell scripting. We should compare the data in the first column in each line. If it is same, then the other data should be put in the same line.Below is the sample input and expected output:... (4 Replies)
Discussion started by: Bobby_2000
4 Replies

9. UNIX for Beginners Questions & Answers

Merging multiple lines into single line based on one column

I Want to merge multiple lines based on the 1st field and keep into single record. SRC File: AAA_POC_DB.TAB1 AAA_POC_DB.TAB2 AAA_POC_DB.TAB3 AAA_POC_DB.TAB4 BBB_POC_DB.TAB1 BBB_POC_DB.TAB2 CCC_POC_DB.TAB6 OUTPUT ----------------- 'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'... (10 Replies)
Discussion started by: raju2016
10 Replies

10. UNIX for Beginners Questions & Answers

Multiple lines to single line

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 SUSE

ooconvert

ooconvert(1)							   User Commands						      ooconvert(1)

Name
       ooconvert - Commandline Document Converter Using OpenOffice.org

SYNOPSIS

       ooconvert [--help] [--force]  input output

DESCRIPTION

       This  tool  converts documents between various formats on the commandline.  It uses OpenOffice.org that guarantees the quality of available
       import and export filters.

       This tool tries to start OpenOffice.org in the server mode on backgroud.  It does not work if the OpenOffice.org  application  has  already
       been running. Also it slows down the conversion a lot. We hope to reduce these limitations in the further versions.

OPTIONS

       input  Input file. The filename suffix must be one of the currently supported file formats, see below.

       output Output  file. The filename suffix defines the output file format. It must be one from the table below. An existing file can be over-
	      written by the --force option.

       --help Print help and exit.

       --force
	      Force an already existing output file to be replaced.

SUPPORTED FILE FORMATS

       The current version of this tool does not read the list of available input and output filters directly from  OpenOffice.org.  The  list	of
       supported file formats is hardcoded and thus limited to:

       doc    Microsoft Word 97/2000/XP

       docx   MS Word 2007 XML

       dot    Microsoft Word 97/2000/XP Template

       dotx   MS Word 2007 XML Template

       html   HyperText Markup Language (Web Page)

       odt    ODF Text Document

       ods    ODF Spreadsheet

       odp    ODF Presentation

       ott    ODF Text Document Template

       ots    ODF Spreadsheet Template

       otp    ODF Presentation Template

       pdf    Portable Document Format

       ppt    Microsoft PowerPoint 97/2000/XP

       pptx   Microsoft PowerPoint 2007 XML

       pot    Microsoft PowerPoint 97/2000/XP Template

       potx   Microsoft PowerPoint 2007 XML Template

       rtf    Rich Text Format

       stc    OpenOffice.org 1.0 Spreadsheet Template

       sti    OpenOffice.org 1.0 Presentation Template

       stw    OpenOffice.org 1.0 Text Document Template

       sxc    OpenOffice.org 1.0 Spreadsheet

       sxi    OpenOffice.org 1.0 Presentation

       sxw    OpenOffice.org 1.0 Text Document

       swf    Macromedia Flash

       txt    Plain Text

       xls    Microsoft Excel 97/2000/XP

       xlsx   Microsoft Excel 2007 XML

       xlt    Microsoft Excel 97/2000/XP Template

       xltx   Microsoft Excel 2007 XML Template

TROUBLESHOOTING PROBLEMS

       See http://en.opensuse.org/Bugs:OOo for more details about how to report bugs in OpenOffice.org.

AUTHOR

       This manual page was created by Petr Mladek <petr.mladek@novell.com>.

OpenOffice.org Converter					    2009-02-09							      ooconvert(1)
All times are GMT -4. The time now is 06:39 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy