Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

File formating with lines

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers File formating with lines
# 1  
Old 01-19-2017
File formating with lines
Hi All,

Need to modify a file basically join the extra line to one I am having a file like below

Quote:
A10
Records of transfer
File received
X,X,X,X,1,1,1,0,A.10,B.10,C.10,D.10,E.10,
F.10
X,X,X,X,1,1,1,0,A.11,B.11,C.11,D.11,E.11,
F.11
X,X,X,X,1,1,1,0,A.12,B.13,C.14,D.14,E.14,
F.14
And would like to make it as below .


Quote:
A10
Records of transfer
File received
X,X,X,X,1,1,1,0,A.10,B.10,C.10,D.10,E.10,F.10
X,X,X,X,1,1,1,0,A.11,B.11,C.11,D.11,E.11,F.11
X,X,X,X,1,1,1,0,A.12,B.12,C.12,D.12,E.12,F.12
# 2  
Old 01-19-2017
First try, just looking for lines ending in comma to join together:
Code:
$ awk '/,$/ { S=$0 ; getline ; $0=S $0 } 1' inputfile

A10
Records of transfer
File received
X,X,X,X,1,1,1,0,A.10,B.10,C.10,D.10,E.10,F.10
X,X,X,X,1,1,1,0,A.11,B.11,C.11,D.11,E.11,F.11
X,X,X,X,1,1,1,0,A.12,B.13,C.14,D.14,E.14,F.14

$

This User Gave Thanks to Corona688 For This Post:
arunkumar_mca
# 3  
Old 01-19-2017
Sorry missed header records. It is also having commas there too. So going by , wont work I think. Will the below awk work if find the starting X and transfer the line

Code:
$ awk '/^X/ { S=$0 ; getline ; $0=S $0 } 1' inputfile
A10
Records of transfer
File received
P195,P195,P15,
C195,C195,C15,
X,X,X,X,1,1,1,0,A.10,B.10,C.10,D.10,E.10,
F.10
X,X,X,X,1,1,1,0,A.11,B.11,C.11,D.11,E.11,
F.11
X,X,X,X,1,1,1,0,A.12,B.13,C.14,D.14,E.14,
F.14

# 4  
Old 01-19-2017
It does for me, does it for you?
This User Gave Thanks to Corona688 For This Post:
arunkumar_mca
# 5  
Old 01-19-2017
Yes it worked... Thanks a lot
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with ... Formating the file using awk

I have a file like below position1 0 7802 7802 0 client1 - - position1 8 8032 8032 0 client1 ... (7 Replies)
Discussion started by: manas_ranjan
7 Replies

2. Shell Programming and Scripting

File formating

I need to create a fixed width file based on the column lengths. lets assume I have six(this may be dynamic) fields each are of different length column1=6 #size of the column column2=3 column3=2 column4=3 column5=4 column6=5 I tried below code snippet but it is not working echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies

3. UNIX for Beginners Questions & Answers

File formating help

Hi all, I am having the file below I need that as below Thanks, Arun (12 Replies)
Discussion started by: arunkumar_mca
12 Replies

4. Shell Programming and Scripting

Help in formating a file with field separator

hi thanks a lot But pls help me if my input file is the below format: Name priya 2010-09-21 10:43:49 TEXT ID 1 hi TEXT ID 2 how TEXT ID 3 r TEXT ID 4 u Name2 priya2 2010-09-21 10:43:49 TEXT ID 1 hi1 TEXT ID 2 how1 TEXT ID 3 r1 (4 Replies)
Discussion started by: bha148
4 Replies

5. Shell Programming and Scripting

Help in formating a txt file

Pls help in formatting a txt file using shell scripting Input file format: Name priya 2010-09-21 10:43:49 TEXT ID 1 hi TEXT ID 2 how TEXT ID 3 r TEXT ID 4 u Output required: name priya hi how r u (4 Replies)
Discussion started by: bha148
4 Replies

6. Shell Programming and Scripting

File formating (sed command)

I am new ot unix. Is there one or two lines of command (sed may be) to format a file. My source is.. <tag1> <tag2> <datatag1> data1 </datatag1> <datatag2> data2 </datatag2> <datatag3> data3 </datatag3> <datatag4> data1 </datatag3> </tag2> </tag1> (2 Replies)
Discussion started by: reachsam11
2 Replies

7. UNIX for Dummies Questions & Answers

File formating help needed.

I have a file called vm.cfg . content of file. acpi = 1 apic = 1 builder = 'hvm' How would i write a script which will add boot = 'd' at 3rd line. For example. after running the script the file should be like below. acpi = 1 apic = 1 boot = 'd' builder = 'hvm' I dont want to... (3 Replies)
Discussion started by: pinga123
3 Replies

8. Shell Programming and Scripting

file formating in Perl

Hi, I am new to unix , I have a requirement for formating the input file and generate the output file as per the downstream requirement .. My application receiving a text input file having 4 field and my application need to check each field and if some value of a field is blank ..then it need... (1 Reply)
Discussion started by: julirani
1 Replies

9. Shell Programming and Scripting

File formating question.

Hi, I have a file with only data 1 row: AA#?BB#?CC#?DD Assume '#?' is the delimiter, i want the output in another file to be: AA BB CC DD Pls let me know if this is possible by sed ? Thanks in advance. (3 Replies)
Discussion started by: smc3
3 Replies

10. UNIX for Dummies Questions & Answers

Help required on file formating

I have two files file1 and file2 as shown below: file1: name nameabc bcd nameabcdefg file2: age age1111 age2345 age6743 I have pasted one file on the other with the delimiter "|" and the resulttant file is: name|age nameabc|age1111 bcd|age2345 nameabcdefg|age6743 (1 Reply)
Discussion started by: udiptya
1 Replies
Login or Register to Ask a Question