String manipulation problem

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting String manipulation problem
# 1  
Old 02-29-2008
String manipulation problem

Hi all
I am new to this forum. Here is my problem. I have a log file created by syncsort which looks something like this. The Left and Right are Previous days data file and Current days data file respectively

left source: /u01/filename1
right source: /u01/filename2
records left : 2334
records right: 3345
records paired : 445
records unpaired : 334

I need to gather pick only the information from the right side of the ':' and put it into one string like this with a pipe delimiter '|'

/u01/filename1 | /uo1/filename2 | 2334 | 3345 | 445 | 334

How do I achieve the above using shell scripting. I need to have this in a file and use this file as an input to oracle utility sqlloader to insert the six values into a record in oracle table.

I really appreciate any help in this aspect.

Thanks a lot
# 2  
Old 02-29-2008
Assume the log is named "logfile.log"

I'm sure there's a way to simplify my way. I welcome any improvements:

cut -f3- -d ' ' logfile.log | sed 's/://;s/[ \t]*//' | awk '{output = output $1 " | "} END {print output}' > logdata.dat

Last edited by matt.d; 02-29-2008 at 06:48 PM.. Reason: Redirected output
# 3  
Old 02-29-2008
Re: String manipulation problem

RESULT_STR=`awk -F":" '{printf $2 " | "}' $LOG_FILE`
# 4  
Old 02-29-2008
Hahaha -- now that's just embarrasing. Smilie

Good job
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

String Manipulation

I'm making a little game in Perl, and I am trying to remove the first instance of a character in an arbitrary string. For example, if the string is "cupcakes"and the user enters another string that contains letters from "cupcake" e.g: "sake"the original string will now look like this (below)... (3 Replies)
Discussion started by: whyte_rhyno
3 Replies

2. Shell Programming and Scripting

String manipulation

Hi , I am getting a string like aaa,bbb,sdsdad,sdfsdf,sdfsdfdsf,rtyrtyr,45654654,ddfdfdfgdfg,dfgdfgdg........... Now what I need is to format it. So after each nth comma I need one newline. So the above will look like when n=3 aaa,bbb,sdsdad, sdfsdf,sdfsdfdsf,rtyrtyr,... (4 Replies)
Discussion started by: Anupam_Halder
4 Replies

3. Shell Programming and Scripting

Deleting part of a string : string manipulation

i have something like this... echo "teCertificateId" | awk -F'Id' '{ print $1 }' | awk -F'te' '{ print $2 }' Certifica the awk should remove 'te' only if it is present at the start of the string.. anywhere else it should ignore it. expected output is Certificate (7 Replies)
Discussion started by: vivek d r
7 Replies

4. UNIX for Dummies Questions & Answers

Help with String manipulation

Discussion started by: pawannoel
13 Replies

5. Shell Programming and Scripting

string manipulation

if I have two string variable, how do I add one to anther. like a= "a" b="b" c=$a+$b but that doesn't work. Is there anyway to solve it. (2 Replies)
Discussion started by: programAngel
2 Replies

6. Shell Programming and Scripting

string manipulation

Hi all, see i have a script that takes few arguments. first one is command we do on file, next is file (mostly txt file with lot of data) third is destination where we do something with data in file. Since im new in scripting, and im learning as i go, i need some hint how to manipulate that... (3 Replies)
Discussion started by: ajemrunner
3 Replies

7. Shell Programming and Scripting

I need help with string manipulation

First of all I am VERY new to this so bare with me and try and explain everything even if it seems simple. Basically I want to read a line of text from a html file. See if the line of text has a certain string in it. copy an unknown number of characters (the last 4 characters wiil be ".jpg" the... (1 Reply)
Discussion started by: c3lica
1 Replies

8. Shell Programming and Scripting

String manipulation

Hi, i am just gettin exposed to UNIX. Could anyone of u help me out with dis problem..? i have a variable 'act' which has the value as follows, echo $act gives -0- -0- -----0---- 2008-06-04 -0- -0- echo "$act" | awk '{print ($act)}' gives, -0- -0- -----0---- 2008-06-04 -0- -0- I... (2 Replies)
Discussion started by: jerrynimrod
2 Replies

9. Shell Programming and Scripting

string manipulation

Hi, I have searched this long and hard and don't seem to see another post on this issue. I have two strings each with the same characters but in a different order. String1=”word” String2=”dwor” I want to test them to show their similarity. Unfortunately I can't do a sort so that they will... (9 Replies)
Discussion started by: Cactus Jack
9 Replies

10. Shell Programming and Scripting

string manipulation

Hello, I have a korn shell string variable str1 = "A,B,Z" I would like to create another korn shell string variable str2 = "letter = 'A' or letter = 'B' or letter = 'Z' " Please help! Thanks in advance an UNIX newbie! (13 Replies)
Discussion started by: hai1973
13 Replies
Login or Register to Ask a Question