topic Re: Formatting File in Operating System - HP-UX

Formatting File

Sanjay Tailor — Tue, 29 Aug 2000 17:38:32 GMT

Hello,

I have an ASCII flat file which has a lot of white space ( spaces ) in between the fields. The field separators are quoted comma ( "," ). How can I remove these spaces between the field separators using something like sed, awk or tr?
A specific example or answer would be nice.

Thanks,
Sanjay.

Re: Formatting File

James R. Ferguson — Tue, 29 Aug 2000 17:47:35 GMT

Sanjay:

You can "squeeze" multiple blanks down to one with 'tr'. For example"

# echo "xxx yyy zzz"|tr -s " " " "

yields "xxx yyy zzz"

...JRF...

Re: Formatting File

Tracey — Tue, 29 Aug 2000 17:49:00 GMT

I use the following to remove the tilde ~ sign at the end of each ascii row:

sed "s/~$//p" INFILE > OUTFILE

Re: Formatting File

Leslie Chaim — Tue, 29 Aug 2000 17:58:25 GMT

With tr and the -s option the second argument is not needed.

echo "aaa bbb ccc" yeilds
aaa bbb ccc
echo "aaa bbb ccc" | tr -s " " yeilds
aaa bbb ccc

Re: Formatting File

Vikas Khator — Tue, 29 Aug 2000 18:26:21 GMT

Hi ,

Can you attach a small file so that we can get you the right solution.

Re: Formatting File

Anthony deRito — Tue, 29 Aug 2000 18:40:23 GMT

Sanjay, so you have a file called FILE1 with strings that look like this:

field1 "," field2 "," field3 "," filed4

You can use the command:

sed 's/ //g' FILE1

to yeild the output:

field1","field2","field3","filed4","

Tony

Re: Formatting File

Sanjay Tailor — Tue, 29 Aug 2000 18:47:06 GMT

Hello Anthony,

With the suggestion from James, I got the fileds down form multiple to single spaces. I tried what you suggested using sed and it did work. Yet one of my fields is a title ( example "The Calculus Book." When I ran sed it got rid of all the spaces including the one in the title. Like I said my field separators are "," My spaces are on either sides of these. Can write something in sed to just take out the spaces here?

Thanks,

Sanjay.

Re: Formatting File

Alan Riggs — Tue, 29 Aug 2000 18:56:18 GMT

try:

sed 's/[ ]*,[ ]*/ , /g' t

Re: Formatting File

Alan Riggs — Tue, 29 Aug 2000 18:57:27 GMT

Or:

sed 's/[ ]*,[ ]*/,/g' t

if you want no spaces at all around the commas

Re: Formatting File

Leslie Chaim — Tue, 29 Aug 2000 18:58:58 GMT

Sanjay,

Try this

sed -e 's/ *(",") */1/g' inpfile > outfile

Re: Formatting File

Anthony deRito — Tue, 29 Aug 2000 18:59:52 GMT

Hmmm, I see the problem. You would not want the spaces to go away in the title of the book. Anyone else...

Tony

Re: Formatting File

Sanjay Tailor — Tue, 29 Aug 2000 19:06:13 GMT

Hello All,

I tried what Anthony suggested and got the spaces removed everywhere. I then tried:
sed 's/ "," /","/g' file1 > file2

And it worked!!! This seems to be the format I am looking for.

Thank you.
Sanjay.