Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to remove tab space if any in a variable?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to remove tab space if any in a variable?
# 1  
Old 07-03-2014
How to remove tab space if any in a variable?
I have a variable sumOfJEOutputFile which is the output file of an SQL command which contains the output of that SQL. The output looks like below:
Code:
-----------
          58

I am using following code to manipulate the output:
Code:
(sed 1,2d $sumOfJEOutputFile > $newTemp1 | sed '$d' $newTemp1) > $newTemp2
count=$(cat $newTemp2)
thresholdValue=40000
if [[ $count -le $thresholdValue ]]; then
echo "JE count for today is less than 40000" | mailx -s "The JE count for- `date` is $count " "akanksha.kumari@abc.com"
echo "success"
else
echo "JE count for today is more than 40000" | mailx -s "The JE count for- `date` is $count " "akanksha.kumari@abc.com"
echo "More JE"
fi

Mail which I am getting has the subject as below:
Code:
The JE count for- Thu Jul  3 04:46:34 EDT 2014 is           58

I want to remove the space which is coming before 58 so that the subject looks like:
Code:
The JE count for- Thu Jul  3 04:46:34 EDT 2014 is 58

How can I achieve this?
# 2  
Old 07-03-2014
Change the count variable
Code:
count=$(cat $newTemp2 | tr -s "\t" " ")

This User Gave Thanks to SriniShoo For This Post:
Sharma331
# 3  
Old 07-03-2014
Quote:
Originally Posted by SriniShoo
Change the count variable
Code:
count=$(cat $newTemp2 | tr -s "\t" " ")

Do we have space between every thing?
# 4  
Old 07-03-2014
Quote:
Originally Posted by Sharma331
Do we have space between every thing?
yes
# 5  
Old 07-03-2014
Quote:
Originally Posted by SriniShoo
Change the count variable
Code:
count=$(cat $newTemp2 | tr -s "\t" " ")

Thank you!! It works for me now
This User Gave Thanks to Sharma331 For This Post:
chandu123
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Replace space by tAB

My file looks like 3 33 210.01.10.0 2.1 1211 560 26 45 1298 98763451112 15412323499 INPUT OK 3 233 40.01.10.0 2.1 1451 780 54 99 1876 78787878784 15423210199 CANCEL OK Aim is to replace the spaces in each line by tab Used: sed -e 's/ */\t/g' But I get output like this... (3 Replies)
Discussion started by: sa@@
3 Replies

2. Shell Programming and Scripting

How to remove alphabets/special characters/space in the 5th field of a tab delimited file?

Thank you for 4 looking this post. We have a tab delimited file where we are facing problem in a lot of funny character. I have tried using awk but failed that is not working. In the 5th field ID which is supposed to be a integer only of that file, we are getting corrupted data as below. I... (12 Replies)
Discussion started by: Srithar
12 Replies

3. 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

4. Shell Programming and Scripting

how to remove tab space only in the column of a specific row

Hi, I need help to remove tab delimited space in the $2 of a specific row. My file is like this:- file1.txt No_1 4 139 156 No_1 5 161 205 No_4 91 227 212 No_19 254 243 263 No_19 645 249 258 No_19 101 2492 2635 No_90 8 277 288... (5 Replies)
Discussion started by: redse171
5 Replies

5. Shell Programming and Scripting

how to keep tab from being converted to space

Hi, I want to read lines from a file, and I'm using two methods 1 use while read line do done<filename 2 use line=`sed -n '3p' filename` however, in both of them, I notice that the tab between fields are automatically converted to space because I want to use awk over the... (10 Replies)
Discussion started by: esolvepolito
10 Replies

6. Shell Programming and Scripting

How to remove tab space and new line from a file using sed?

i am using the default sed package that comes with solaris. (11 Replies)
Discussion started by: chidori
11 Replies

7. UNIX for Dummies Questions & Answers

Delimiter: Tab or Space?

Hello, Is there a direct command to check if the delimiter in your file is a tab or a space? And how can they be converted from one to another. Thanks, G (4 Replies)
Discussion started by: Gussifinknottle
4 Replies

8. Shell Programming and Scripting

need help in tab space !

i have a commad that display the total each directory size in KB.Below the commad and o/p: ls -ltr | grep ^d | awk '{print $9}' | xargs du -sk output: what i want is the proper tab space b/w value and dir.? how to get that. thanks in advance (10 Replies)
Discussion started by: ali560045
10 Replies

9. Shell Programming and Scripting

How to echo a <tab> space?

I've tried this: echo "${bold}User${norm} : u"\t"${bold}All Users ${norm} : a\t" and i got this output: Specific User : u\tAll User: a\t (14 Replies)
Discussion started by: laila63
14 Replies

10. UNIX Desktop Questions & Answers

replace tab with space

How do I replace a tab with a space in scripts using sed/awk ? (1 Reply)
Discussion started by: avnerht
1 Replies
Login or Register to Ask a Question