text formating/Text space padding


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers text formating/Text space padding
# 1  
Old 06-29-2005
text formating/Text space padding

Hi,

How do I format the following?
I have a for loop that retrieves me the path and file name of a file. In column fashion I would like to add the time and another variable containing the file's size. This will result in all the time being under each other and all the file size's being under each other. This is for logging purposes, so this will all go to file. The headings are not important.


File path variable time size

ex.
/path1/...... 10:00:00 30
/path2/.. 00:00:12 7000009
/path3/............. 12:12:31 2

Please assist.
# 2  
Old 06-29-2005
use this

echo " Name Time Size "

Inside the for loop try this :-

ls -lrt $file | awk '{print $9; print $8; print $5}' | tr '\n\ ' '
echo " "

where file is the file retrieved from the loop
# 3  
Old 06-29-2005
Quote:
Originally Posted by rahul123_libra
echo " Name Time Size "

Inside the for loop try this :-

ls -lrt $file | awk '{print $9; print $8; print $5}' | tr '\n\ ' '
echo " "

where file is the file retrieved from the loop
Why the tr after the awk and also the multi - print's?

Code:
ls -lrt $file | awk '{print $9 "\t" $8 "\t" $5}'

Thats a tab-delimited output.

Not tested tho'.

vino
# 4  
Old 06-29-2005
MySQL Right

U r right Vino
# 5  
Old 06-29-2005
Sorry guys, I was maybe not to clear of what is known and how it must be formated. Most of the data is retrieve by the for loop into variables.

This is the columns.
Code:
<tab>                      <tab>                            <tab>            <tab>
"File path variable"     "time for date command"    "size old var"   "size new var"
/path1/.....               23:00:00                         30                 2
/path2/.....               04:01:02                         99999999        4         
/path3/.....               01:00:55                         40                 15

Thanks a lot for you prompt response though.

Last edited by Perderabo; 06-29-2005 at 09:10 AM.. Reason: Add code tags for readability
# 6  
Old 06-29-2005
Show us a sample of the input and the the output you require.
Probably that could help.

vino
# 7  
Old 06-29-2005
This is the format of my current log file after the script has run.

/edi/iTracTEST/sessions/otherreceive/nohup.out @ 08:19:46 from 63 - 63
/edi/iTracTEST/sessions/payroll/nohup.out @ 08:19:46 from 52395 - 63
/edi/iTracTEST/sessions/payrollmsg/nohup.out @ 08:19:46 from 56931 - 63

As from the first record/line.
The path and file name is already in a variable from a the for loop in the script.
The "@" is echoed.
The time is coming from the date command.
The "from" is echoed.
The first 63 is the initial file size in bytes as from a variable in the for loop.
The "-" is echoed.
The second 63 is the current/new file size as from a variable in the for loop.

I would like the log file to look like this. !!!Notice I have swapped the sizes!!!

/edi/iTracTEST/sessions/otherreceive/nohup.out 08:19:46 63 63
/edi/iTracTEST/sessions/payroll/nohup.out 08:19:46 63 52395
/edi/iTracTEST/sessions/payrollmsg/nohup.out 08:19:46 63 56931

This just make the log file more readable.
Here is some of the code, thus far.

sess_path=/edi/iTracTEST/sessions/
ls -pl /edi/iTracTEST/sessions/ | awk '$1 ~ /^d/ $9 ~ /\/$/' | awk '{print $9}' > `pwd`/temp/`date +"%C%y%m%d"`.tmp
for nohup_loc in $(cat `pwd`/temp/`date +"%C%y%m%d"`.tmp)
do
nohup_loc2=$sess_path$nohup_loc"nohup.out"
if test -s $nohup_loc2
then
cur_fsize=`ls -l $nohup_loc2 | awk '{print $5}'`
echo !!! Reset nohup.out file at `date` !!! > $nohup_loc2
new_fsize=`ls -l $nohup_loc2 | awk '{print $5}'`
echo $nohup_loc2 @ `date +%H:%M:%S` from $cur_fsize - $new_fsize >> `pwd`/log/`date +"%C%y%m%d"`_nohup_reset.log
fi
done
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Changing only the first space to a tab in a space delimited text file

Hi, I have a space delimited text file but I only want to change the first space to a tab and keep the rest of the spaces intact. How do I go about doing that? Thanks! (3 Replies)
Discussion started by: evelibertine
3 Replies

2. Shell Programming and Scripting

Text Formating or Modifying

Hi Experts, I have a text exactly like below in a file: id item_id item_date prin_mkt_val --------------------------- --------------------------- ------------------------------- ------------------------ ... (1 Reply)
Discussion started by: apatil65
1 Replies

3. UNIX for Dummies Questions & Answers

Converting a text file with irregular spacing into a space delimited text file?

I have a text file with irregular spacing between values which makes it really difficult to manipulate. Is there an easy way to convert it into a space delimited text file so that all the spaces, double spaces, triple spaces, tabs between numbers are converted into spaces. The file looks like this:... (5 Replies)
Discussion started by: evelibertine
5 Replies

4. Shell Programming and Scripting

fixed length text file padding issues in AIX

Hi, I have a fixed length text file that needs to be cut into individual files in aix and facing padding issues. If I have multiple blank spaces in the file it is just making it one while cutting the files.. Eg:- $ - blank space filename:file.txt ... (2 Replies)
Discussion started by: techmoris
2 Replies

5. Shell Programming and Scripting

Text formating issue

Hi, I am trying to format the output of my script in a tabular format using the html code in my shell script. I am using html code for the first time in a shell script.I am trying to execute this script in Ksh but it is not getting executed. Can you please help me in figuring this out.... (6 Replies)
Discussion started by: isaacsam
6 Replies

6. Shell Programming and Scripting

Text formating

Dear all I had input file as mention below and want op as mention. Kindly let me knw possible ways. Regards Jaydeep INPUT: RXOTX-48-1 2A 34 2B 35 RXOTX-499-2 2C 32 RXOTX-4-1 2D 23 OUTPUT: (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies

7. Shell Programming and Scripting

TEXT formating using script

Dear All I am facing problem while extracting data from below mention input file. My op should be like this.Required field display in red in file. Request you all to help. OP: RXOTX-46-5 1B4 RXOTX-46-4 2B5 INPUT FILE: <RXMFP:MO=RXOTX-46-5; RADIO X-CEIVER ADMINISTRATION... (4 Replies)
Discussion started by: jaydeep_sadaria
4 Replies

8. UNIX for Dummies Questions & Answers

batch formating filenames with zero padding

My little script for producing pseudo random file names works OK; but I need the file names to be formatted with zero padding, probably %05d here's the script so far #!/bin/bash ls *.jpg > list for i in `cat list` do rnd=$RANDOM mv "$i" "$rnd" done I've been trying printf but can't... (2 Replies)
Discussion started by: platz
2 Replies

9. Forum Support Area for Unregistered Users & Account Problems

Formating mailx text file for Lotus Notes users

We use AIX mailx or sendmail. How can I format a text file so that lotus notes users can see diferent fonts and highlighting. Or can a gif file (company logo..) be sent along with a text file and the Lotus notes user would see the logo and text displayed at the same time and not as an attachment? (0 Replies)
Discussion started by: lidoiwo
0 Replies

10. UNIX for Dummies Questions & Answers

Formating text from a script into a log file

Using a for loop I am able to get the following log file below. I would like o change the format a bit as is indicated lower down. I have looked at awk and sed but somehow is not getting any joy. I am a bit new to ksh scripting. Please assist. This is the format of my current log file after the... (1 Reply)
Discussion started by: hugow
1 Replies
Login or Register to Ask a Question