topic Re: Script Output in Operating System - HP-UX

Script Output

Dewa Negara_4 — Thu, 12 Nov 2009 09:41:28 GMT

Hi All,

Can you help below Please? Using sed command, How to convert the input as "adhn4807, adhn5326, adhn5327, adhn5328, adhn5333," to the output below?

adhn4807
adhn5326
adhn5327
adhn5328
adhn5333

Thanks alot in advance.
Regards,
Negara

Re: Script Output

R.K. # — Thu, 12 Nov 2009 10:28:23 GMT

Hi Dewa,

I am not sure about sed, but following script runs well according to you:

#################
#!/usr/bin/sh
VAR="adhn4807, adhn5326, adhn5327, adhn5328, adhn5333,"
for A in `echo $VAR | awk -F"," '{print $1,$2,$3,$4,$5}'`
do
echo $A
done
#################

Hope this helps..

Re: Script Output

Dewa Negara_4 — Thu, 12 Nov 2009 10:44:44 GMT

Thanks alot. But here there are so many servers in the list...adhn4807, adhn5326, adhn5327, adhn5328, adhn5333,...,....,.....,etc (many more)

Need to convert the output to:
adhn4807
adhn5326
adhn5327
adhn5328
adhn5333
...
...
...
etc (many more)

Regards,
Negara

Re: Script Output

R.K. # — Thu, 12 Nov 2009 11:17:00 GMT

Hi Again,

You can put the server names in a file "ex1".
Then run following command:

# awk -F", " '{ for (i = 1; i <= NF; i++) print $i}' ex1

adhn4807
adhn5326
adhn5327
adhn5328
adhn5333

Where:
#more ex1
adhn4807, adhn5326, adhn5327, adhn5328, adhn5333

Hope this will be of some help..

Re: Script Output

Jean-Luc Oudart — Thu, 12 Nov 2009 11:30:39 GMT

if this is in a file :

cat | tr "\," "\n"
or
tr "\," "\n" <

Regards
Jean-Luc

Re: Script Output

James R. Ferguson — Thu, 12 Nov 2009 13:18:40 GMT

Hi Dewa:

Your data shows that there are whitespaces following the commas. To eliminate these and produce the output you showed, use a one-process Perl instead of pipes with 'tr' and/or 'sed':

# perl -pe 's/,\s*/\n/g' file

(or)

# X="adhn4807, adhn5326, adhn5327, adhn5328, adhn5333"
# echo ${X}|perl -pe 's/,\s*/\n/g'

This code reads your file globally substituting a newline character for any comma with or without an optional whitespace (\s) following it.

If you are using a GNU 'sed' then this would work too:

# sed -e "s/,[ ]*/\n"/g file

Unfortunately, the standard HP-UX 'sed' doesn't support this syntax.

Regards!

...JRF...

Re: Script Output

Dennis Handly — Thu, 12 Nov 2009 13:34:20 GMT

You have spaces after each ","?
for word in $(sed 's/,//g' file); do
print $word
done

With vi you can change comma to newlines:
:%s/, /^V/g
(That's a control-V.)
Then a cleanup of comma without a space.

Re: Script Output

Dennis Handly — Thu, 12 Nov 2009 13:36:18 GMT

Oops:
With vi you can change comma to newlines:
:%s/, /^V^M/g
(That's a control-V followed by a enter.)
Then a cleanup of comma without a space.

Re: Script Output

Dewa Negara_4 — Thu, 12 Nov 2009 16:31:24 GMT

Hi All,

Thanks alot for your help. Got the answer. Appreciate your help.

Best Regards,
Negara