Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems.. It's 100% free, no registration required.

This is the error I am getting and it's failing because of a variable whose value is supposed to be 2 (I am getting this using a select * from tabel). I am getting spaces in that variable.

+ 0 != 
         2
./setjobs[19]: 0:  not found.

How do I remove all those spaces or a newline from that variable? Can tr, sed, or anything help?

This what I am doing:

set_jobs_count=$(echo  "set heading off;
      select count(*) from oppar_db
      where ( oppar_db_job_name, oppar_db_job_rec ) in ($var) ;" | \
  sqlplus -s ${OP_ORA_USER}/${OP_ORA_PASS}@$OPERATIONAL_DB_NAME)

This works as suggested:

| sed 's/[[:space:]]//g'

But I still obtain a value like :

  set_jobs_count=
  2
share|improve this question
    
You can cast a string to an int in the select statement. How that is done depends on database, Sybase, Oracle, MySQL, etc. –  bdowning Feb 24 '12 at 13:05
    
how do i do that, i have oracle 9i –  munish Feb 24 '12 at 13:11
    
using sed it's | sed 's/[[:space:]]//g' to collapse whitespace –  bdowning Feb 24 '12 at 14:06
    
thanks works up to some extent but still the values of variable comes like set_jobs_count= 2 –  munish Feb 24 '12 at 14:37
    
i got it thanks –  munish Feb 24 '12 at 15:14

2 Answers 2

up vote 7 down vote accepted

You can use tr, as in tr -d '\040\011\012\015', which will remove spaces, tabs, carriage returns and newlines.

share|improve this answer
    
@magixx Thanks for the correction. –  Kyle Jones Apr 30 '13 at 1:07

In ksh, bash or zsh:

set_jobs_count=…
set_jobs_count=${set_jobs_count//[[:space:]]/}

In any shell, you can remove leading and trailing whitespace and normalize all intermediate whitespace to a single space like this:

set +f
set -- $set_jobs_count
set_jobs_count=$*
set -f

set +f turns off globbing; if you know that the data contains none of the characters \[?*, you can omit it.

share|improve this answer
    
interesting answer +1 –  munish Mar 1 '12 at 15:02

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.