Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Preserving file format and spacing in output file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Preserving file format and spacing in output file
# 1  
Old 04-27-2012
Preserving file format and spacing in output file
Hi

I have a file with the following structure
Code:
"VATTENFALL GLOBAL"                        "Vattenfall Tray"  
"BARCLAYS BANK LONDON"                   "Capula"                      
"P1 AGEAS GLOBAL COMPANY"              "AAC - Optiver"

The requirement is like this

1) Take 2 input from user, 1st the string to replace and 2nd new string.
2) Serach the 1st string in the file and replace it with second string.
3) The alignment and spacing between the columns should not be altered if there is difference between the old string and new string.

How can i preserve the alignment of the columns. Any help is welcomed.

Thanks,
Sudeep
Last edited by radoulov; 04-27-2012 at 10:45 AM.. Reason: Code tags!
# 2  
Old 04-27-2012
What have you tried so far?
# 3  
Old 04-27-2012
Code:
 
SCRIPTS>cat input_file
"VATTENFALL GLOBAL" "Vattenfall Tray"
"BARCLAYS BANK LONDON" "Capula"
"P1 AGEAS GLOBAL COMPANY" "AAC - Optiver"

SCRIPTS>v1="Hello man"

SCRIPTS>v2="GLOBAL"

SCRIPTS>sed "s/$v2/$v1/" input_file
"VATTENFALL Hello man" "Vattenfall Tray"
"BARCLAYS BANK LONDON" "Capula"
"P1 AGEAS Hello man COMPANY" "AAC - Optiver"

# 4  
Old 04-27-2012
Quote:
Originally Posted by panyam
Code:
 
SCRIPTS>cat input_file
"VATTENFALL GLOBAL" "Vattenfall Tray"
"BARCLAYS BANK LONDON" "Capula"
"P1 AGEAS GLOBAL COMPANY" "AAC - Optiver"
 
SCRIPTS>v1="Hello man"
 
SCRIPTS>v2="GLOBAL"
 
SCRIPTS>sed "s/$v2/$v1/" input_file
"VATTENFALL Hello man" "Vattenfall Tray"
"BARCLAYS BANK LONDON" "Capula"
"P1 AGEAS Hello man COMPANY" "AAC - Optiver"

With the above code, the string would be replaced but the alignment would not be preserverd. What I require is suppose column 1 is 45 chars and col 2 starts from 46th chars, even after substitution of the string the col 2 should start from 46th char only.
# 5  
Old 04-27-2012
What have you tried so far?
# 6  
Old 04-27-2012
Code:
 
With the above code, the string would be replaced but the alignment would not be preserverd. What I require is suppose column 1 is 45 chars and col 2 starts from 46th chars, even after substitution of the string the col 2 should start from 46th char only.

What if the new string which will replace column1 is more than "45" charactes in length?

Post a sample output on what exactly you are expecting.
# 7  
Old 04-27-2012
Quote:
Originally Posted by Scrutinizer
What have you tried so far?

I have tried sed and awk but the alignment is getting compromised.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Help with printing output format from a file

Hi, I need help in printing data in below format from file extensions with .dml, i have listed details below file name is test_temp.dml, location in /home/users/test01/test_temp.dml file content: sample_type= record decimal(",") test_type; date("DD-MM-YYYY")(",") test_date... (2 Replies)
Discussion started by: AAHinka
2 Replies

2. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

3. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

4. Shell Programming and Scripting

format a file to this output

hi i need some help over here.. please help i have a log file as per below --------------------------------------------------------------------------------------------------------- JOB START DATE : 20110510204513 JOB ID : us2cap3ds9... (6 Replies)
Discussion started by: sitaldip
6 Replies

5. Shell Programming and Scripting

Dynamic output file generation using a input text file with predefined output format

Hi, I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format. Example: File.txt AP|{SSHA}VEEg42CNCghUnGhCVg== APVG3|{SSHA}XK|"password" AP3|{SSHA}XK|"This is test" .... etc --------- test.sh has... (1 Reply)
Discussion started by: hudson03051nh
1 Replies

6. Shell Programming and Scripting

Change file output format

I have a file which has following contents usmtnz-dinfsi19 62 61 18400 18800 99.7 usmtnz-dinfsi19 62 61 18400 18800 99.7 i want the o/p to be like date (7 Replies)
Discussion started by: fugitive
7 Replies

7. Shell Programming and Scripting

format file output

Hi, I am trying to put a script together that allows for a command to be executed and then the output goes to a .html file. I am running the script on HPUX. I run: /var/fl/user/lmutil lmstat -a -c license_lic.dat > /web/results.html This saves the command to a .html file but the text is... (1 Reply)
Discussion started by: zerbitated
1 Replies

8. Shell Programming and Scripting

format the output from a file

hi , i need to format the output which is availble in a file file output is Following are the Process_Scheduler Domains running in the server Ram-pc VPORCL Following are the Application Server domains running in the server Ram-pc VPORCL01 VPORCL02 these value VPORCL,VPORCL01...... (5 Replies)
Discussion started by: becksram123
5 Replies

9. Shell Programming and Scripting

Output format - comparison with I/p file

Hi, I have a file which contains more than 1 lakh records like following: a. name, id, city, state, country, phone (Expected I/P file format) name, id, city,, state, country, phone (Current I/P file format ) I want to achieve following tasks, a, Remove the extra comma in the... (1 Reply)
Discussion started by: velappangs
1 Replies

10. Shell Programming and Scripting

Format the output of file

hello all Script and example of file #!/bin/sh #sh gdata.sh /users/testsuite/db/appl/ DATE=`date '+20%y-%m-%d'` echo $DATE for i in ${1}/$DATE/* ; do find $i -name daily -prune -o -name run.log -print -exec grep -c ! {} \; done > test.log. The test.log contains output like this ... (9 Replies)
Discussion started by: getdpg
9 Replies
Login or Register to Ask a Question