First, i think you requirements are not well defined:
Suppose you enter "GLOBAL" as your search string and "x" as replacement. Now suppose you have the following file contents (exact formatting not preserved):
Should only the first line be changed? The first and the second? All three? Depending on your answer the necessary sed-script will look differently.
Second, here is how to preserve the formatting of tabular data with spaces with sed:
First identify the lines that have to be changed. See above, it is not clear yet how this should be done. All the other lines can pass unchanged.
Then, identify the lines where the "second field" has to be changed. (If this is part of the requirement, i.e. if the third line in the above example has to be changed.) These lines are the easiest, because there is no following field where the formatting has to be preserved. These lines are simply changed by a substitution-directive the way you did it already. s/pattern/replacement/ With these lines you are done now.
Then you tackle the lines which need replacement in the first field. Apply the following procedure to these:
Do your pattern replacement as usual.
Replace the spaces between the fields with exactly 45 spaces (the width of your first column, as i recall).
Do a substitution on the line with the following pattern: The first 45 characters plus all following characters beginning at the first non-whitespace. This effectively cuts out the excessive spaces and reformats the line.
You might ask why you have to first delete all the spaces, then enter some and lastly cut some of them out again. This is necessary because the replacement string could be shorter than the original. This way you make sure you have excessive spaces in the line so that the last step always "trims down" the line.
In fact, if you follow the above procedure, you will see that every paragraph i wrote matches exactly one sed-statement. So, get you sed man-page and start trying. If you have trouble writing the sed-script show what you did and we will help you gladly.
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)