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
# 36  
Old 05-27-2010
I have multiple spaces between IIT and chennai, but its not displaying in the screen as above

---------- Post updated at 07:07 PM ---------- Previous update was at 07:06 PM ----------

Sorry, in the terminal i can able to see the multiple spaces, but while pasting the spaces are trimmed between IIT and chennai.

---------- Post updated at 07:11 PM ---------- Previous update was at 07:07 PM ----------

its not a scenario that i shouldn't use awk. But i need it in the script because, i need to extract all "IIT chennai" as it is occuring in source file and i need to print both college tag value and the name value. please pass me if awk suits to above requirement, i will replace it in the code.
Thanks

---------- Post updated at 07:12 PM ---------- Previous update was at 07:11 PM ----------

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 >> $targetfile
else
echo "No match found"
fi;
done< ${file}

In the above code, pls update me where do i need to use awk command.
# 37  
Old 05-27-2010
Quote:
Originally Posted by Sekar1
...Sorry, in the terminal i can able to see the multiple spaces, but while pasting the spaces are trimmed between IIT and chennai.
...
That's okay.
If your shell script is "my_script.sh", then run the following commands and copy/paste the output from your Terminal screen.

Code:
rm final.txt
cat my_script.sh
. my_script.sh
cat final.txt

If your shell script is named something other than "my_script.sh", then put that name in the 2nd and 3rd command above.

tyler_durden
# 38  
Old 05-27-2010
Pls find the details.

Code:
$ cat source.txt
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh   suderam</name><college>IIT                    Chennai   </college>
$ rm final.txt
$. ./css2.sh
$ cat final.txt
IIT Chennai

# 39  
Old 05-27-2010
Pls do the following and post the output within code tags:
Code:
cat -vet source.txt

# 40  
Old 05-27-2010
$ cat -vet source.txt
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh suderam</name><college>IIT Chennai </college> $

---------- Post updated at 07:29 PM ---------- Previous update was at 07:29 PM ----------

sorry, pls find the output

Code:
 $ cat -vet source.txt
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh   suderam</name><college>IIT                    Chennai   </college> $

# 41  
Old 05-27-2010
Quote:
Originally Posted by Sekar1
Pls find the details.

Code:
$ cat source.txt
<Record><sno>1</sno><empid>E0001</empid><name>Rejsh   suderam</name><college>IIT                    Chennai   </college>
$ rm final.txt
$. ./css2.sh
$ cat final.txt
IIT Chennai

Ok, open the file "css2.sh" in your favorite text editor and edit it so that it looks like this -

Code:
file=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
else
echo "No match found"
fi
done< ${file}

The text in bold, red color are the differences from your current "css2.sh" script. I have also removed the redundant semi-colons at the end of a few lines.

You could wipe out your entire script and copy/paste it from here.
Or you could update just the individual lines.

And then run the sequence of commands again:

Code:
rm final.txt
cat css2.sh
. css2.sh
cat final.txt

And copy/paste your Terminal session here.

tyler_durden
# 42  
Old 05-27-2010
$ rm final.txt

---------- Post updated at 07:39 PM ---------- Previous update was at 07:37 PM ----------

Hi I got the output :-)
Code:
$ rm final.txt
$ . ./css2.sh
$ cat final.txt
IIT                    Chennai

Requesting you to please explain me what changes you did.
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