How to strip strins


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to strip strins
# 1  
Old 03-23-2006
Question How to strip strins

Guys,

Please can someone tell me how to strip each string from the following ?

TABLE1||METHOD||TYPE||STATUS||DATE

What i need is to assign each value to the variable

TABLE1 to var1
METHOD to var2
and so on

If there is NULL in one of them, something like A||B||||C||
I want the third to be displayed as a space

I am using ksh by the way

Thanks
Ganesh
# 2  
Old 03-23-2006
go for awk

do man awk for more info
# 3  
Old 03-23-2006
Quote:
Originally Posted by gauravgoel
go for awk

do man awk for more info

Don't quite understand AWK.. I think there is lot to learn in awk ? Is it possible to give an example ?
# 4  
Old 03-23-2006
the thing is it seems loke a homework problem, otherwise would have deinitely helped you

ok atleast post what have u tried so far
# 5  
Old 03-23-2006
Quote:
Originally Posted by gauravgoel
the thing is it seems loke a homework problem, otherwise would have deinitely helped you

ok atleast post what have u tried so far

Ok thanks.. Definitely not home work.. I am working and this is what i wrote

runsql_analyze_db() {
echo "I am in runsql_analyze_db and the parameter is $1"
statement=$1
echo " The process id in SQL is $$"
echoLog "$statement started at `date`"
sqlResult=`$BINDIR/sqlplus -s <<SQL
######/#######
WHENEVER SQLERROR exit 10
set feedback off
set heading off
set pagesize 100
exec dbms_stats.gather_table_stats($statement
exit
SQL
`
echo "SQL RESULT is $sqlResult"
echoLog "Completed at `date`"
checkORA "$sqlResult" $2
}


submit()
{
chk_process=1
stmt1="update analyze_table set status = NULL;"
echo " The process id in submit is $$"
echo "Now i am in submit"
for collect_stat in `$BINDIR/sqlplus -s <<EOF
xchtbl/xchtblint3
set heading off
set feedback off
set linesize 132
set pagesize 100
select 'ownname=>''' || owner
||''',tabname=>''' || table_name
||''',granularity=>''' || granularity
||''',cascade=>' || cascade
||',method_opt=>''' || NVL(method_opt,'''')
||');'
from analyze_table;
exit
EOF
`
do


I am planning to take the table name from above and fetch rest of the records in the SQL plus to analyze a table. I am running out of ideas.

Thanks
# 6  
Old 03-23-2006
ok

Quote:
var1=`echo $variablecontainingthestring | awk -F '||' '{print $1}'`
similarly $2 for var2
$3 for var3 and so on
this should work.
if still some problem post back

Gaurav
# 7  
Old 03-23-2006
Quote:
Originally Posted by gauravgoel
ok



similarly $2 for var2
$3 for var3 and so on
this should work.
if still some problem post back

Gaurav

Thanks Gaurav.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Strip First few Characters

I want to strip first few characters from each record until a proper datesamp is found. Request for getNextPage.................06/29/12 07:49:30 VVUKOVIC@67.208.166.131{7A805FEF76A62FCBB23EA78B5380EF95.tomcat1}TP-Processor14 LogExchUsage: ERROR:: isprof=false : exch=NSDQ output should be... (2 Replies)
Discussion started by: ratheeshjulk
2 Replies

2. Solaris

strip error

Hi I am getting the below error while using strip command. strip: libelf error. Request error: no string table strip: a.out: file not manipulated Could somebody please let me know what might be the solution?? It is in ksh and solaris 10. Thanks in advance (4 Replies)
Discussion started by: vali__
4 Replies

3. Shell Programming and Scripting

Strip out the string

awk -F"\t" -vOFS="\t" '{print $1"\t-\t-","",$6,$7"\t-"$8"\t-\t-\t"$15}' file.tsv > output.tsv Using the above command how to remove the string www.abc.com from the $7 value. (7 Replies)
Discussion started by: sandy1028
7 Replies

4. Shell Programming and Scripting

Strip a string in sh

I have a list of servers that I need my script to ping however this list also has the env they belong too such as SIT, PRD, warehouse and so on. The break character for each section is : A value in my list would look like this... brutus.grhq.xxx.com:warehouse Where brutus.grhq.gfs.com is... (13 Replies)
Discussion started by: LRoberts
13 Replies

5. Programming

Strip command

I am new in Unix. I go through the man strip. But did not understand that, why when we have -G (debug and release ) option in the compiler, than using strip command to strip the debug information from the objects. i want to binary for teh production i will compile it without debug option. What the... (4 Replies)
Discussion started by: Saurabh78
4 Replies

6. UNIX for Advanced & Expert Users

strip command

I have created one binary with the debug option debug.out and another without it is production.out. Now, i use stripe on the debug.out. Now, both binary will be same? or have any differences. (1 Reply)
Discussion started by: Saurabh78
1 Replies

7. Shell Programming and Scripting

Need to strip few letters

Hey guys.. Can experts help me in achieving my purpose.. I have a file which contains email address of some 100 to 1000 domains, I need only the domain names.. Eg: abc@yahoo.com hd@gamil.com ed@hotmail.com The output should contain only Yahoo.com ... (5 Replies)
Discussion started by: achararun
5 Replies

8. Shell Programming and Scripting

Need to strip a string

I have a file that looks like this: /home/fred/opt/bin /opt/usr/bin /usr/sbin/var/opt I need a way to chop of everything after the last occurance of the / sign including the /. So the file above will now look like this below. /home/fred/opt /opt/usr /usr/sbin/var I tried using... (6 Replies)
Discussion started by: x96riley3
6 Replies

9. Shell Programming and Scripting

Strip all non-alphanumerics

Hi, Can someone let me know how do I strip out any non-alphanumeric character in string tomake it alphanumeric? i.e abc def ghi ->abcdefghi abc-def-ghi ->abcdefghi abc#def-ghi->abcdefghi Thanks in advance (3 Replies)
Discussion started by: braindrain
3 Replies
Login or Register to Ask a Question