Shell scripting for file manupilations


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell scripting for file manupilations
# 1  
Old 05-08-2014
Shell scripting for file manupilations

Hi linux users,

I have a file with following format.
Code:
{
     Name        shiva;
     location     Delhi;
     travelID     IDNumber; 
}  
4 
( 
(0.1 0.2 0.3) 1234 
(1.1 1.2 1.3) 12345 
(2.1 2.2 2.3) 12354 
(3.1 3.2 3.3) 123667 
)

now i wanted to write this data in separate files as followes
file1

Code:
{
     Name        shiva;
     location     Bangalore;
     travelID     IDNumber;
} 
IDNumber_coord 4 
( 
(0.1 0.2 0.3)  
(1.1 1.2 1.3)  
(2.1 2.2 2.3)  
(3.1 3.2 3.3)  
);

file2
Code:
{     
Name        shiva;     
location     Bangalore;     
travelID     IDNumber; 
}  

IDNumber_ID 4 
( 
1234 
12345 
12354 
123667 
); 

Can some body help me?

Regards,
linuxUser_
# 2  
Old 05-08-2014
This will work - to a certain degree - for exactly the input file you have given, and it will need adaption/correction were it to be applied to other files or structures:
Code:
awk     '/location/     {$2="Bangalore"}
         /travelID/     {TID=$2; sub(";", "", TID)}
         /^[0-9]+/      {H1=TID"_coord ";H2=TID"_ID "}
         /^\) *$/       {L=0; $0=$0 ";";FS=" "}
                        {print H1(L?$1")":$0) >"file1"
                         print H2(L?$2:$0) >"file2"   
                         H1=H2=""}
         /^\( *$/       {L=1; FS="\) "}
        ' OFS="\t" file

This User Gave Thanks to RudiC For This Post:
# 3  
Old 05-08-2014
awesome. worked perfectly Smilie
Thank you

Regards,
linuxUser_
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read csv file, convert the data and make one text file in UNIX shell scripting

I have input data looks like this which is a part of a csv file 7,1265,76548,"0102:04" 8,1266,76545,"0112:04" I need to make the output data should look like this and the output data will be part of text file: 7|1265000 |7654899 |A| 8|12660000 |76545999 |B| The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies

2. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies

3. Shell Programming and Scripting

Display the First and Last name from a file using shell scripting

I am new to shell scripting and doing a similar thing @ work Stan:Smith:Detroit:MI Jim:Jones:Farmington Hills:MI Jack:Frost:Denver:CO Sue:Apple:New York:NY Cindy:Thompson:Battle Creek:MI John:Smith:Denver:CO George:Jones:New York:NY Need to create a shell script This script will display... (1 Reply)
Discussion started by: jakemathew
1 Replies

4. Shell Programming and Scripting

Shell scripting - need to arrange the columns from multiple file into a single file

Hi friends please help me on below, i have 5 files like below file1 is x 10 y 20 z 15 file2 is x 100 z 245 file3 is y 78 z 23 file4 is x 100 (3 Replies)
Discussion started by: siva kumar
3 Replies

5. Shell Programming and Scripting

file operations in shell scripting

hi All, my query... 1.I Have to search for the files in the root directory. 2.i have to search for a pattern in all the files in the root directory and then replace them with a new pattern. 3.Rename the file Explanation: if ABC is the root folder and has 3 subfolders and there are 15... (9 Replies)
Discussion started by: adityamahi
9 Replies

6. Shell Programming and Scripting

Need to create file from shell scripting

Hi, I want to create a file from a shell script. the data for the file will come from variables. that is the file format is like, var1-value var2_value ... that is, var1_value should be placed in first 10 spaces and var2_value should be placed in next 8 columns like that. is there... (4 Replies)
Discussion started by: smr_rashmy
4 Replies

7. Shell Programming and Scripting

file permissions using shell scripting

Hi I am trying to use shell script to display file permissions, and I can do it fine for the current user logged in, but now I want to view all file permissions for the Owner of the file, Group users and everyone, so it will look something like this: -----------------READ WRITE EXECUTE OWNER... (11 Replies)
Discussion started by: barbus
11 Replies

8. Shell Programming and Scripting

.def file in HP-UX Shell scripting

Hi Pals, I need some information related .def file in HP-Ux shell scripting. What actaully a .def file contains. It is having all definitions of some functions. But what is the relationship between a .def file and shell script. Can anyone give some examples. Thanks in Advance. Best... (1 Reply)
Discussion started by: manu.vmr
1 Replies

9. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

10. UNIX for Dummies Questions & Answers

file activity (open/closed) file descriptor info using KORN shell scripting

I am trying to find a way to check the current status of a file. Such as some cron job processes are dependent on the completion of others. if a file is currently being accessed / modified or simply open state I will wait until it is done being processed before attempting the next process on that... (3 Replies)
Discussion started by: Gary Dunn
3 Replies
Login or Register to Ask a Question