Sponsored Content
Top Forums UNIX for Dummies Questions & Answers JOINING MULTIPLE LINES IN A TEXT FILE USING GAWK Post 302425292 by KANNI786 on Thursday 27th of May 2010 02:45:09 PM
Old 05-27-2010
JOINING MULTIPLE LINES IN A TEXT FILE USING GAWK

sir... am having a data file of customer master., containing some important fields as a set one line after another.,

what i want is to have one set of these fields(rows) one after another in line.........then the second set... and so on... till the last set completed.





I WANT THE DATA TO LOOK LIKE.....


Code:
Customer No :   10000  RAMAKRISHNA REDDY 
Address     :      FLAT NO101     
                       RK  MANSIONS                                 
                       PARK ROAD COLONY
City        :BLG                  PIN : 560009                                                                                              
Dt Established :  01/01/2000    Dt since Cust of Bank :    01/01/2001      
Individual/Others :  INDIVIDUAL             Constitution Cd : ******* Profession Cd :  NOT AVAILABLE           
FREEZE Type : TOTAL FREEZE             FREEZE Reason : OTHERS                                                        
----------------------------------------------------------------------
Customer No :   10001  RAMAKRISHNA RAO 
Address     :      FLAT NO333      
                       SLN MANSIONS                                 
                      PARK ROAD COLONY
City        :BANGALORE                 PIN : 560009                                                                                              
Dt Established :  01/01/2001    Dt since Cust of Bank :    01/01/2003      
Individual/Others :  INDIVIDUAL     Constitution Cd : ******* Profession Cd :  NOT AVAILABLE           
FREEZE Type : TOTAL FREEZE             FREEZE Reason : OTHERS                                                        
----------------------------------------------------------------------


HAVING THE FIELDS:
CUSTOMER NO:ADDRESS: (FIELD1, FIELD2, FIELD3)CITY:PINSmiliet Established: Dt since Cust of Bank :
THE DATA IS TO APPEAR AS :
Code:
10000 RAMAKRISHNA REDDY FLAT NO333  SLN MANSIONS PARK ROAD COLONY BANGALORE  560009   01/01/2000  01/01/2001 
10000 RAMAKRISHNA REDDY FLAT NO333  SLN MANSIONS PARK ROAD COLONY BANGALORE  560009   01/01/2000  01/01/2001

pl.. help by providing script in gawk
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Joining multiple lines

I have data of the following form. It starts its first line with a '{' and ends the last line with a '}'. What I need to do is to join every line starting with the '{' and ending with the '} into one line in the output file. If it was just this one block, I could do a 13 joins in vi, however it... (4 Replies)
Discussion started by: beilstwh
4 Replies

2. Shell Programming and Scripting

[bash help]Adding multiple lines of text into a specific spot into a text file

I am attempting to insert multiple lines of text into a specific place in a text file based on the lines above or below it. For example, Here is a portion of a zone file. IN NS ns1.domain.tld. IN NS ns2.domain.tld. IN ... (2 Replies)
Discussion started by: cdn_humbucker
2 Replies

3. UNIX for Dummies Questions & Answers

Joining lines of a text file using GAWK

sir... am having a data file of customer master., containing some important fields as a set one line after another., what i want is to have one set of these fields(rows) one after another in line.........then the second set... and so on... till the last set completed. ... (0 Replies)
Discussion started by: KANNI786
0 Replies

4. Shell Programming and Scripting

Joining contents in multiple lines to a single line

I do have a file with contents splited into multiple lines ADSLHLJASHGLJSKAGHJJGAJSLGAHLSGHSAKBV AJHALHALHGLAGLHGBJVFBJVLFDHADAH GFJAGJAGAJFGAKGAKGFAK AJHFAGAKAGAGKAKAKGKAGFGJDGDJJDGJDJDFAG ... ... .... 100's of lines I would like to rearrange the content of this file so it will be a... (1 Reply)
Discussion started by: Lucky Ali
1 Replies

5. UNIX for Dummies Questions & Answers

How to generate multiple lines in a text file?

Hello, I want to create a file whose content is multiple lines of strings. The string has the following pattern: aaaa/bbbb/A-B.txt A is a variable ranges from A1 to A2 B is a variable ranges from B1 to B2 Any ideas? Thanks. (17 Replies)
Discussion started by: vic005
17 Replies

6. Shell Programming and Scripting

Joining lines in a text file using AWK or SED

Hi All I'm struggling a bit here :( I need a way of joining lines contained in a text file. I've seen numerous SED and AWK examples and none of them seem to be working for me. The text file has 4 lines: DELL1427 DOC 30189342 79 Now bear with me on this one as I'm actually... (4 Replies)
Discussion started by: huskie69
4 Replies

7. Windows & DOS: Issues & Discussions

Gawk on Windows: Joining lines only if 1st field matches

Hi.. i have two files:: file_1:: mOnkey huMAnfile_2:: Human:hates:banana i:like:*** Monkey:loves:banana dogs:kill:catsdesired output:: Monkey:loves:banana Human:hates:bananaso only when the 1st field matches from both files print it from file_2 ((case-sensitive)) i also would like... (21 Replies)
Discussion started by: M@LIK
21 Replies

8. UNIX for Dummies Questions & Answers

How to grep multiple lines from a text file using another text file?

I would like to use grep to select multiple lines from a text file using a single-column text file. Basically I want to only select lines from the first text file where the second column of the first text file matches the second text file. How do I go about doing that? Thanks! (5 Replies)
Discussion started by: evelibertine
5 Replies

9. UNIX for Advanced & Expert Users

Text formatting - joining lines

I have large file with data as below, in unix using sed or some cammand how to get output as below. cat 1.txt Normal data 1|AA|NN 4|BB|NNN C|DDD|N //Additional details 9C|12C|8N Specific Details 12N|JIN|KK\NY1\ 345\ABC1\KKK 90|ENO0|NDO 17|NO921|NCOKL output shoud be as below ... (10 Replies)
Discussion started by: Tecnical_help12
10 Replies

10. Shell Programming and Scripting

awk joining multiple lines based on field count

Hi Folks, I have a file with fields as follows which has last field in multiple lines. I would like to combine a line which has three fields with single field line for as shown in expected output. Please help. INPUT hname01 windows appnamec1eda_p1, ... (5 Replies)
Discussion started by: shunya
5 Replies
getvfsent(3C)						   Standard C Library Functions 					     getvfsent(3C)

NAME
getvfsent, getvfsfile, getvfsspec, getvfsany - get vfstab file entry SYNOPSIS
#include <stdio.h> #include <sys/vfstab.h> int getvfsent(FILE *fp, struct vfstab *vp); int getvfsfile(FILE *fp, struct vfstab *vp, char *file); int getvfsspec(FILE *, struct vfstab *vp, char *spec); int getvfsany(FILE *, struct vfstab *vp, struct vfstab *vref); DESCRIPTION
The getvfsent(), getvfsfile(), getvfsspec(), and getvfsany() functions each fill in the structure pointed to by vp with the broken-out fields of a line in the /etc/vfstab file. Each line in the file contains a vfstab structure, declared in the <sys/vfstab.h> header, whose following members are described on the vfstab(4) manual page: char *vfs_special; char *vfs_fsckdev; char *vfs_mountp; char *vfs_fstype; char *vfs_fsckpass; char *vfs_automnt; char *vfs_mntopts; The getvfsent() function returns a pointer to the next vfstab structure in the file; so successive calls can be used to search the entire file. The getvfsfile() function searches the file referenced by fp until a mount point matching file is found and fills vp with the fields from the line in the file. The getvfsspec() function searches the file referenced by fp until a special device matching spec is found and fills vp with the fields from the line in the file. The spec argument will try to match on device type (block or character special) and major and minor device num- bers. If it cannot match in this manner, then it compares the strings. The getvfsany() function searches the file referenced by fp until a match is found between a line in the file and vref. A match occurrs if all non-null entries in vref match the corresponding fields in the file. Note that these functions do not open, close, or rewind the file. RETURN VALUES
If the next entry is successfully read by getvfsent() or a match is found with getvfsfile(), getvfsspec(), or getvfsany(), 0 is returned. If an end-of-file is encountered on reading, these functions return -1. If an error is encountered, a value greater than 0 is returned. The possible error values are: VFS_TOOLONG A line in the file exceeded the internal buffer size of VFS_LINE_MAX. VFS_TOOMANY A line in the file contains too many fields. VFS_TOOFEW A line in the file contains too few fields. FILES
/etc/vfstab ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |MT-Level |Safe | +-----------------------------+-----------------------------+ SEE ALSO
vfstab(4), attributes(5) NOTES
The members of the vfstab structure point to information contained in a static area, so it must be copied if it is to be saved. SunOS 5.11 12 Mar 1997 getvfsent(3C)
All times are GMT -4. The time now is 08:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy