stripping white space...


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting stripping white space...
# 1  
Old 10-05-2007
stripping white space...

Hi All;

Having a problem with a file..

the file contains the following data... (a snapshot)

1331F9E9DB7C2BB80EAEDE3A8F043B94,AL7 1DZ,M,50
186FDF93E1303DBA217279EC3671EA91,NG5 1JU,M,24
3783FFAF602015056A8CD21104B1AAAF,CH42 4NQ,M,17

It has 3 columns sepreated by a ,
the second column as a space in the middle of it..

1331F9E9DB7C2BB80EAEDE3A8F043B94,AL7 1DZ,M,50
I want to run a script against the file to strip that white space. Not really where to start.

Any pointers will greatly appericated

Thanks
# 2  
Old 10-05-2007
Code:
awk 'BEGIN{OFS=FS=","}{ gsub(" ","",$2) }1' "file"

# 3  
Old 10-05-2007
Hi

Thanks very much for the prompt reply.. I tried running the command you gave me on command line I'm getting a few errors

> awk 'BEGIN{OFS=FS=","}{ gsub(" ","",$2) }1' "user.db"
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: bailing out near line 1
>

I'm running on solaris 9.
# 4  
Old 10-05-2007
As always...... use 'nawk' instead of plain old 'awk' on Solaris...
# 5  
Old 10-05-2007
Gentlemen,

I'm humbled by your knowledge Smilie
# 6  
Old 10-09-2007
U can Try this also!!!!!!!!!!!!!!!!!!!!!!!!!


cat filename | tr -s ' ' ','

Regards,
aajan
# 7  
Old 10-09-2007
hey i have taken one line of your test file as follows,
var1="1331F9E9DB7C2BB80EAEDE3A8F043B94,AL7 1DZ,M,50"
then
echo $var1 | tr -d " "
o/p:1331F9E9DB7C2BB80EAEDE3A8F043B94,AL71DZ,M,50

surely it might help you out, if a blank space/tab is there .
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add white space

hi guys how can i add spacein file name with sed if strings have no space around dash input 19-20 ( 18-19 ) ABC-EFG output after add white space 19 - 20 (18 - 19 ) ABC - EFG thx in advance (2 Replies)
Discussion started by: mhs
2 Replies

2. UNIX for Dummies Questions & Answers

insert white space between numbers

Hello all, I have a file with several lines like this: (1,1) (4,10) (8,23) (17, 4) (6,8) etc. and I need this: ( 1 , 1 ) ( 4 , 10 ) ( 8 , 23 ) ( 17 , 4 ) ( 6 , 8 ) How do I insert a space between the left parenthesis and the first number, between the first number and the comma,... (2 Replies)
Discussion started by: MDeBiasse
2 Replies

3. UNIX for Dummies Questions & Answers

filename with white space

our user creates a text file with a white space on the filename. this same file is transfered to unix via automation tool. i have a korn shell script that reads these files on a input directory and connects to oracle database to run the oracle procedures which will load the data from each of the... (2 Replies)
Discussion started by: wtolentino
2 Replies

4. Shell Programming and Scripting

Delete white space using sed

Hi , I have a file with contents as below group1 = aaaaa, bbbbb, ccccc, aaa group2=aaa, bbbbb, ccccc, aaaaa group3 = bbbbb, aaa, ccccc, aaaaa group4 = bbbbb, aaa,ccccc, aaaaa I want to search for "aaa" and the output should be as below group1 = aaaaa, bbbbb, ccccc group2= bbbbb, ccccc,... (3 Replies)
Discussion started by: anil8103
3 Replies

5. Shell Programming and Scripting

sed + white space

Hi, What sed command (if sed is the right command) can remove ALL white space from my file. I have a csv, except I want to remove all white space between commas and characters. My idea (without testing) sed 's/ //g' Is there a better way? (18 Replies)
Discussion started by: mcclunyboy
18 Replies

6. Shell Programming and Scripting

Stripping out more than a space from a line, but keep single space.

Hi all, Is there a way to perform the above, I am trying to strip out more than one space from a line, but keep the single space. See below output example. My Name is test test2 test3 test4 test5 My Name is test test2 test3 test4 test5 Please note that the lines would contain... (7 Replies)
Discussion started by: eo29
7 Replies

7. Shell Programming and Scripting

Matching white space through Grep

Hello All, I am trying to match white space in patterns through - Grep I tried ] & ] but none of them worked. Then I tried Perl extension '\s' and it worked. So just wanted to know if ] & ] are still supported or have they become deprecated. However they have been mentioned in the... (3 Replies)
Discussion started by: paragkalra
3 Replies

8. UNIX for Dummies Questions & Answers

Problem with Trimming of white space

Dear Members, Following is the code which i am using: integer i=7 while ((i <= 10 )); do param=`echo $TEST_OUT | cut -d"^" -f$i` a=`echo ${param}` echo `echo $a | sed 's/+/ /g'` (( i = i + 1)); done From the above code TEST_OUT is a variable which has the following value: ... (1 Reply)
Discussion started by: sandeep_1105
1 Replies

9. UNIX for Dummies Questions & Answers

SED with White Space

Dear Members, Suppose i have a variable test which stores a string as below: test='John drives+++++++++a+++++car' now i want to use sed on the above variable and replace + with a white space, so that i get echo $test should give me 'john drives a car' Between... (1 Reply)
Discussion started by: sandeep_1105
1 Replies

10. Shell Programming and Scripting

How to keep white space is being deleted using read

I am using Posix shell to write a script. The problem I am having is that when I use the read command to go through a file I lose the tabs. How can I keep this from happening? (1 Reply)
Discussion started by: keelba
1 Replies
Login or Register to Ask a Question