Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Include white spaces while using CUT command

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Include white spaces while using CUT command
# 15  
Old 05-27-2010
I have space in the input tag college. The tag college holds the value as "IIT Chennai " and i want the output exaclty with the spaces given in input between IIT and chennai

Expected OUTPUT
---------------
"IIT Chennai"
# 16  
Old 05-27-2010
Again, can't you use awk ??

Code:
$ awk -F "<name>|</name>" '{print $2}' x
Rejsh suderam
Rejsh suderam
Rejsh suderam
Rejsh suderam
$ cat x
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT Chennai </college>
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT Chennai </college>
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT Chennai </college>
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT Chennai </college>
$



---------- Post updated at 05:17 PM ---------- Previous update was at 05:14 PM ----------

If "IIT Chennai":

Code:
$ awk -F "<college>|</college>" '{print $2}' x
IIT Chennai 
IIT Chennai 
IIT Chennai 
IIT Chennai 
$

# 17  
Old 05-27-2010
I did as you mentioned. Please review.
Code:
while read c_line
do
echo $c_line >> $targetfile
var1=`echo $c_line | grep -c "IIT   Chennai"`
#echo $var1 >> $targetfile
if [ $var1 -ge 1 ]
then
#val=`cut -c7-75 $$c_line`
#val=`echo $$c_line | cut -c78-94 `
val=`awk -F "<college>|</college>" '{print $2}'`
echo $var >> $targetfile
fi
done<${c_line}

I am not getting any output while executing the script file.

#cat source.txt
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT Chennai </college>

output
--------
$ cat final.txt
$
# 18  
Old 05-27-2010
Code:
while read line; 
do if [ `echo $line | grep -c "IIT Chennai"` -gt 0 ]; then 
var=`echo $line | sed 's/.*<college>\(.*\) <\/college>$/\1/'`; 
echo $var; 
fi; 
done< file


cheers,
Devaraj Takhellambam
# 19  
Old 05-27-2010
Quote:
Originally Posted by Sekar1
I did as you mentioned. Please review.

I am not getting any output while executing the script file.

#cat source.txt
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT Chennai </college>

output
--------
$ cat final.txt
$
You don't need to read the file if you are using awk.

if you want the output as

Code:
<input line 1>
IIT Chennai 
<input line 2>
IIT Chennai


try just:

Code:
awk -F "<college>|</college>" '{print $0"\n"$2}' source.txt > final.txt

# 20  
Old 05-27-2010
You can as well do just but i wrote the script using sed above just as yu wanted.

Code:
sed 's/.*<college>\(.*\) <\/college>$/\1/' file

# 21  
Old 05-27-2010
Hi Thanks for your response. But eventhough i didn't get the expected output
I am pasting you for your reference.

bash: file: No such file or directory

---------- Post updated at 06:01 PM ---------- Previous update was at 06:00 PM ----------

i got the above output. I corrected my code as per your suggestion.

file=/apps/source.txt
targetfile="final.txt"
while read line;
do if [ `echo $line | grep -c "IIT Chennai"` -gt 0 ]; then
var=`echo $line | sed 's/.*<college>\(.*\) <\/college>$/\1/'`;
echo $var >> $targetfile;
fi;
done< file
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Include information and change column order while maintaing white spaces

I need to change the order of the columns of data that looks like this: The original data is in 6 tab-separated columns. FACTSHEET factsheet NN 1 5 DEP WHAT what WP 2 3 SBJ IS be VBZ 3 1 NMOD AIDS AIDS NP ... (1 Reply)
Discussion started by: owwow14
1 Replies

2. Shell Programming and Scripting

Shell command to Strip white spaces at specific location

Hello, I have a Comma separated input file with one of the sample records as below: -9223372036854477528,"834","834003325515BXNI00101012013C","5","PLAN_VALUE","PPO, General Cable","C",20130101,99991231,"A","2012-12-25-13.58.14.434000","ZPL2 ","2012-12-25-13.58.14.434000","ZPL2 ... (4 Replies)
Discussion started by: Praveenkulkarni
4 Replies

3. Shell Programming and Scripting

Leading white spaces

Hi, I am having problem in deleting the leading spaces:- cat x.csv baseball,NULL,8798765,Most played baseball,NULL,8928192,Most played baseball,NULL,5678945,Most played cricket,NOTNULL,125782,Usually played cricket,NOTNULL,678921,Usually played $ nawk 'BEGIN{FS=","}!a... (2 Replies)
Discussion started by: scripter12
2 Replies

4. Shell Programming and Scripting

Cut command skips spaces

Hi everyone I have a file looks like this X01 1 JOE 20100312 X02 TOD 20100312 X03 3 SAM 20100312 I wrote a script to assign the values in 5 columns to 5 variables. When I use cut command to assign column 2 or 3, it skips it if it is a space (see below) ... (3 Replies)
Discussion started by: nimo
3 Replies

5. Shell Programming and Scripting

How to Use Sed Command to replace white spaces with comma from between two fields - Mayank

SHELL SCRIPT Hi I have a file in the following format Mayank Sushant Dheeraj Kunal ARUN Samir How can i replace the white space in between and replace them with a comma?? The resultant output should be Mayank,Sushant Dheeraj,Kunal ARUN,Samir i tried using sed -e... (8 Replies)
Discussion started by: mayanksargoch
8 Replies

6. UNIX for Dummies Questions & Answers

Removing Double Spaces for cut command

Hi I have a shell script that looks for running processes in order to kill them. The script (ksh) gets the PID of these processes using the following: PROCS=`ps -fu ${USERID} | egrep "MONITOR" | grep -v grep | cut -d" " -f4` However, I spotted an issue where PID's of different lengths... (3 Replies)
Discussion started by: mikem22
3 Replies

7. Shell Programming and Scripting

Two or more white spaces in string

Hi, Can anybody suggest me how to combine two strings with two or more white spaces and assign it to a variable? E.g. first=HAI second=HELLO third="$first $second" # appending strings with more than one white spaces echo $third this would print HAI HELLO Output appears... (2 Replies)
Discussion started by: harish_oty
2 Replies

8. Shell Programming and Scripting

trimming white spaces

I have a variable that calls in a string from txt file. Problem is the string comes with an abundance of white spaces trailing it. Is there any easy way to trim the tailing white spaces off at the end? Thanks in advance. (9 Replies)
Discussion started by: briskbaby
9 Replies

9. Shell Programming and Scripting

delete white spaces

hi all... i have the next question: i have a flat file with a lot of records (lines). Each record has 10 fields, which are separated by pipe (|). My problem is what sometimes, in the first record, there are white spaces (no values, nothing) in the beginning of the record, like this: ws ws... (2 Replies)
Discussion started by: DebianJ
2 Replies

10. UNIX for Dummies Questions & Answers

deleting white spaces

How would I delete white spaces in a specified file? Also, I'd like to know what command I would use to take something off a regular expression, and put it onto another. ie. . . . expression1 <take_off> . . . expression2 (put here) . . . Any help would be great, thanks! (10 Replies)
Discussion started by: cary530
10 Replies
Login or Register to Ask a Question