Sponsored Content
Top Forums Shell Programming and Scripting Issue while append to previous line Post 302979075 by RavinderSingh13 on Tuesday 9th of August 2016 02:35:33 AM
Old 08-09-2016
Hello JSKOBS,

Could you please try following and let me know if this helps you.
Code:
awk '($0 ~ /^[[:digit:]]/ && A){print A;A=""} {gsub(/^[[:space:]]+|[[:space:]]+$/,X,$0);A=A?A OFS $0:$0} END{print A}'   Input_file

Output will be as follows.
Code:
36578019,005-923887317,UNMDL,20151230,2C3CCAAG4GH135448,L,TX,20160108,62,"030916 PPT TX AFF RPRT VALID AFF IN PDP WLL FWD TO RYAN ON 031116 CB1619 ",,
36580219,611-923785453,FC,20151209,ZACCJABT9FPC19274,L,TX,20160108,83,,,
36581327,611-924085106,UNMDL,20151230,1C6RR7MT8GS151541,L,TX,20160108,62,,,

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Append line that does not contain pipe to it previous line

Hi All, I have a file which contains data as below When we see no pipe character in the line. append those lines to the previous line with pipe character till we get the next line with pipe character with ~(concat with ~) Input file looks like: 1080530944|001|john.l.bonner|Acknowledge|CN... (11 Replies)
Discussion started by: ainuddin
11 Replies

2. UNIX for Advanced & Expert Users

append the line with the previous if it not start with 1=

How to append the line with the previous if it not start with 1=. 1=ttt, 2=xxxxxx, 3=4545 44545, 4=66666, 1=ttt, 2=xxxxxx, 3=34434 3545, 4=66666, 5=ffffff 6=uuuuuuu, 7=ooooooo 1=ttt, 2=xxxxxx, 3=311343545, 4=66666 1=ttt, 2=xxxxxx, 5=XAXAXA, 7=FDFD (3 Replies)
Discussion started by: palsevlohit_123
3 Replies

3. Shell Programming and Scripting

SED or AWK "append line to the previous line"

Hi, How can I remove the line beak in the following case if the line begin with the special char “;”? TEXT Text;text ;text Text;text;text I want to convert the text to: Text;text;text Text;text;text I have already tried to use... (31 Replies)
Discussion started by: research3
31 Replies

4. Shell Programming and Scripting

Append each line to next previous line in a file

Hi all, Please help me in providing sample code to append the following 4 lines in one row. Input : A1/EXT "BAPBSC10/07B/00" 523 090530 0115 RXOCF-430 HY1711 1 EXTERNAL ALARM DOOR ALARM Output should be : A1/EXT "BAPBSC10/07B/00" 523 090530 0115 ... (8 Replies)
Discussion started by: sudhakaryadav
8 Replies

5. Shell Programming and Scripting

Append specific lines to a previous line based on sequential search criteria

I'll try explain this as best I can. Let me know if it is not clear. I have large text files that contain data as such: 143593502 09-08-20 09:02:13 xxxxxxxxxxx xxxxxxxxxxx 09-08-20 09:02:11 N line 1 test line 2 test line 3 test 143593503 09-08-20 09:02:13... (3 Replies)
Discussion started by: jesse
3 Replies

6. Shell Programming and Scripting

Append next line to previous line when one pattern not found

Hi, I need help for below scenario.I have a flat file which is having records seperated by delimiters which will represent each record for oracle table.My Control file will consider each line as one record for that table. Some of the lines are aligned in two/three lines so that records are... (4 Replies)
Discussion started by: kannansr621
4 Replies

7. Shell Programming and Scripting

Remove previous line if next & previous lines have same 4th character.

I want to remove commands having no output. In below text file. bash-3.2$ cat abc_do_it.txt grpg10so>show trunk group all status grpg11so>show trunk group all status grpg12so>show trunk group all status GCPKNYAIGT73IMO 1440 1345 0 0 94 0 0 INSERVICE 93% 0%... (4 Replies)
Discussion started by: Raza Ali
4 Replies

8. Shell Programming and Scripting

Append next line to previous lines when NF is less than 0

Hi All, This is very urgent, I've a data file with 1.7 millions rows in the file and the delimiter is cedilla and I need to format the data in such a way that if the NF in the next row is less than 1, it will append that value to previous line. Any help will be appricated. Thanks,... (17 Replies)
Discussion started by: cumeh1624
17 Replies

9. UNIX for Dummies Questions & Answers

How to remove fields space and append next line to previous line.?

awk 'BEGIN{FS = "Ç"} NR == 1 {p = $0; next} NF > 1 {print p; p = $0} NF <= 1 {p = (p " " $0)} END {print p}' input.txt > output.txt This is what the input data file looks like with broken lines Code: 29863 Ç890000000 Ç543209911 ÇCHNGOHG Ç000000001 Ç055 ... (4 Replies)
Discussion started by: cumeh1624
4 Replies

10. Shell Programming and Scripting

Remove new line starting with a numeric value and append it to the previous line

Hi, i have a file with multiple entries. After some tests with sed i managed to get the file output as follows: lsn=X-LINK-IN0,apc=661:0,state=avail,avail/links=1/1, 00,2110597,2094790,0,81,529,75649011,56435363, lsn=TM1ITP1-AM1ITP1-LS,apc=500:0,state=avail,avail/links=1/1,... (5 Replies)
Discussion started by: nms
5 Replies
Net::Google::Code(3pm)					User Contributed Perl Documentation				    Net::Google::Code(3pm)

NAME
Net::Google::Code - a simple client library for google code SYNOPSIS
use Net::Google::Code; my $project = Net::Google::Code->new( project => 'net-google-code' ); $project->load; # load its metadata, e.g. summary, owners, members, etc. print join(', ', @{ $project->owners } ); # return a Net::Google::Code::Issue object, of which the id is 30 $project->issue( id => 30 ); # return a Net::Google::Code::Download object, of which the file name is # 'FooBar-0.01.tar.gz' $project->download( name => 'FooBar-0.01.tar.gz' ); # return a Net::Google::Code::Wiki object, of which the page name is 'Test' $project->wiki( name => 'Test' ); # loads all the downloads $project->load_downloads; my $downloads = $project->downloads; # loads all the wikis $project->load_wikis; my $wikis = $project->wikis; DESCRIPTION
Net::Google::Code is a simple client library for projects hosted in Google Code. Since 0.15, Net::Google::Code offers google's official issues api support. Besides the new "Net::Google::Code::Issue::list", "Net::Google::Code::Issue::Comment::list" and <Net::Googlel::Code::Issue::load_comments> methods, which use the api from start, you can set $Net::Google::Code::Issue::USE_HYBRID to true to load, create and update issue with the api too. But the official api is not function complete yet( e.g. no attachment support, can't merge, etc. ), Net::Google::Code will back to the scraping way to accomplish those stuff. ATTRIBUTES
project the project name email, password user's email and password, used to authenticate base_url the project homepage base_svn_url the project svn url (without trunk) base_feeds_url the project feeds url summary description labels owners members INTERFACE
load load project's home page, and parse its metadata parse acturally do the parse job, for load(); load_downloads load all the downloads, and store them as an arrayref in $self->downloads load_wikis load all the wikis, and store them as an arrayref in $self->wikis issue return a new Net::Google::Code::Issue object, arguments will be passed to Net::Google::Code::Issue's new method. download return a new Net::Google::Code::Download object, arguments will be passed to Net::Google::Code::Download's new method. wiki return a new Net::Google::Code::Wiki object, arguments will be passed to Net::Google::Code::Wiki's new method. DEPENDENCIES
Any::Moose, HTML::TreeBuilder, WWW::Mechanize, Params::Validate XML::FeedPP, DateTime, JSON, URI::Escape, MIME::Types, File::MMagic INCOMPATIBILITIES
None reported. BUGS AND LIMITATIONS
No bugs have been reported. This project is very very young, and api is not stable yet, so don't use this in production, at least for now. AUTHOR
sunnavy "<sunnavy@bestpractical.com>" Fayland Lam "<fayland@gmail.com>" LICENCE AND COPYRIGHT
Copyright 2008-2010 Best Practical Solutions. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.10.1 2010-04-26 Net::Google::Code(3pm)
All times are GMT -4. The time now is 12:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy