SH string formatting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting SH string formatting
# 1  
Old 01-20-2010
SH string formatting

Hi all,
my syslog.txt is a file like this:

Code:
Jan 20 10:55:19 cerbero | process1: process1.--: [ID 379539 local1.info] |Info |xyxyxyxyxyxyxx |
Jan 20 10:59:45 cerbero | processlong2 : threadlong1.0 : [ID 379539 local1.info] |Info |ughxueeughxueeuxexuexueuxexuexue |

I need a .sh script to print to screen something like this.
Code:
Jan 20 10:55:19 | process1: ___________process1.--: ___________|Info  |xyxyxyxyxyxyxx |
Jan 20 10:59:45 | processlong2  : _____threadlong1.0 : ________|Info  |ughxueeuxexuexueughxueeuxexuexue |

I'm not able to display here spaces instead of "_" but I need space-padding (i.e. 20 space char)

Thanks to all,
Riccardo
# 2  
Old 01-20-2010
will this work?

Code:
sed -e 's/: /:            /g' -e 's/: .*\]/:            /g' file

# 3  
Old 01-20-2010
something like
Code:
cut syslog.txt -d'|' -f2 | sed 's/\[.*\]//g' | awk -F=":" '{printf ("%15s %15s\n", $1, $2); }'

SmilieIs not complete but works on what needs to be modified in the file.

Last edited by frans; 01-20-2010 at 08:27 AM..
# 4  
Old 01-21-2010
Hi all, thanks for suggestion.

I need to split all the rows using as field separator " " or ":" or "|" or "[" or "]"

For example:
Jan 20 10:55:19 cerbero | process1: process1.--: [ID 379539 local1.info] |Info |xyxyxyxyxyxyxx |

Jan
20
10
55
19
cerbero
process1
process1.--
ID
379539
local1.info
....

By this way I can use awk and printf to create a new custom line...

When I use AKW FS = [ \|\[\]:] I don't have to expected result...

Riccardo
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies

2. Shell Programming and Scripting

to extract string from main string and string comparison

continuing from my previous post, whose link is given below as a reference https://www.unix.com/shell-programming-scripting/171076-shell-scripting.html#post302573569 consider there is create table commands in a file for eg: CREATE TABLE `Blahblahblah` ( `id` int(11) NOT NULL... (2 Replies)
Discussion started by: vivek d r
2 Replies

3. Shell Programming and Scripting

help formatting

I need to format a txt file and convert it in CSV. Any "future" column is separated by a newline. FROM: XS1 1.43294 0.0 XS2 1.21824 0.0 TO: XS1,XS2 (2 Replies)
Discussion started by: alfreale
2 Replies

4. UNIX for Dummies Questions & Answers

string formatting

how can I format this so the output looks like so: 811420 -rwx------ 1 cw33221 student 8952 Jan 26 2011 a.out I keep getting this 811420 -rwx------ 1 cw33221 student 8952 Jan 26 17:31 a.out Here's the code I want to minuplate: printf( "%d\t" , info_p->st_ino); (4 Replies)
Discussion started by: l flipboi l
4 Replies

5. Shell Programming and Scripting

Formatting a string

hi, i am relatively new to unix. i have a doubt i have a string in the format "2010-10-27 15:03:56" i need to format that to "10/27/2010 15:03:56" this format how to do that in unix script ? any help is appreciated.. (7 Replies)
Discussion started by: mssajith
7 Replies

6. Shell Programming and Scripting

String formatting using awk printf

Hi Friends, I am trying to insert lines of the below format in a file: # x3a4914 Joe 2010/04/07 # seh Lane 2010/04/07 # IN01379 Larry 2010/04/07 I am formatting the strings as follows using awk printf: awk 'printf "# %s %9s %18s\n", $2,$3,$4}' ... (2 Replies)
Discussion started by: sugan
2 Replies

7. Shell Programming and Scripting

String formatting using AWK

Hi, I need to insert a line at a particular line number. I am using the below code: sed $REV_LINO_NO" i\\ # $CURRENT_DATE $NAME Changed pwd for cindy\'s id" file > file1 This code works, but the formatting is not as I expected. For example, I get lines as shown below... (2 Replies)
Discussion started by: sugan
2 Replies

8. Shell Programming and Scripting

Help formatting a string. Something like printf?

Hi I'm having a problem with converting a file: ID X 1 7 1 8 1 3 2 5 2 7 2 2 To something like this: ID X1 X2 X3 1 7 8 3 2 5 7 2 I've tried the following loop: for i in `cat tst.csv| awk -F "," '{print $1}'| uniq`;do grep -h $i... (4 Replies)
Discussion started by: flotsam
4 Replies

9. Shell Programming and Scripting

awk printf formatting using string format specifier.

Hi all, My simple AWK code does C = A - B If C can be a negative number, how awk printf formating handles it using string format specifier. Thanks in advance Kanu :confused: (9 Replies)
Discussion started by: kanu_pathak
9 Replies

10. UNIX for Dummies Questions & Answers

formatting

Hi Again Guys , Please i installed linux RH 6.1 on Toshiba , 10G , RAM=128 , 600 MHZ . After i installed linux i got many error messages , seems it was not installed correctly , also when i finished installation it did not ask me for the 2nd installation CD , and when i logged as root , i... (5 Replies)
Discussion started by: tamemi
5 Replies
Login or Register to Ask a Question