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
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. UNIX for Dummies Questions & Answers
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
3. UNIX for Dummies Questions & Answers
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
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
8. UNIX for Dummies Questions & Answers
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
9. UNIX for Dummies Questions & Answers
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
10. Shell Programming and Scripting
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
LEARN ABOUT NETBSD
getopt
GETOPT(1) BSD General Commands Manual GETOPT(1)
NAME
getopt -- parse command options
SYNOPSIS
args=`getopt optstring $*`
set -- `getopt optstring $*`
DESCRIPTION
getopt is used to break up options in command lines for easy parsing by shell procedures, and to check for legal options. [Optstring] is a
string of recognized option letters (see getopt(3)); if a letter is followed by a colon, the option is expected to have an argument which may
or may not be separated from it by white space. The special option ``--'' is used to delimit the end of the options. getopt will place
``--'' in the arguments at the end of the options, or recognize it if used explicitly. The shell arguments ($1, $2, ...) are reset so that
each option is preceded by a ``-'' and in its own shell argument; each option argument is also in its own shell argument.
getopt should not be used in new scripts; use the shell builtin getopts instead.
EXAMPLES
The following code fragment shows how one might process the arguments for a command that can take the options [a] and [b], and the option
[c], which requires an argument.
args=`getopt abc: $*`
if [ $? -ne 0 ]; then
echo 'Usage: ...'
exit 2
fi
set -- $args
while [ $# -gt 0 ]; do
case "$1" in
-a|-b)
flag=$1
;;
-c)
carg=$2; shift
;;
--)
shift; break
;;
esac
shift
done
This code will accept any of the following as equivalent:
cmd -acarg file file
cmd -a -c arg file file
cmd -carg -a file file
cmd -a -carg -- file file
IEEE Std 1003.2 (``POSIX.2'') mandates that the sh(1) set command return the value of 0 for the exit status. Therefore, the exit status of
the getopt command is lost when getopt and the sh(1) set command are used on the same line. The example given is one way to detect errors
found by getopt.
DIAGNOSTICS
getopt prints an error message on the standard error output when it encounters an option letter not included in [optstring].
SEE ALSO
sh(1), getopt(3)
HISTORY
Written by Henry Spencer, working from a Bell Labs manual page. Behavior believed identical to the Bell version.
BUGS
Whatever getopt(3) has.
Arguments containing white space or embedded shell metacharacters generally will not survive intact; this looks easy to fix but isn't.
The error message for an invalid option is identified as coming from getopt rather than from the shell procedure containing the invocation of
getopt; this again is hard to fix.
The precise best way to use the set command to set the arguments without disrupting the value(s) of shell options varies from one shell ver-
sion to another.
BSD
November 28, 2009 BSD