how to split

[munna_dude]

hi all
i would like split this
ID=123:one=a:two=a@yahoo.com:three=789:four=:five= 123
i tried this

echo "ID=123:one=a:two=a@yahoo.com:three=789:four=:five=123" | sed 's/\(.*=\)\(.*\):\(.*=\)\(.*\):\(.*=\)\(.*\):\(.*=\)\(.*\):\(.*=\)\(.*\):.*$/\/\/begin\
\2\
\4\
\6/'
but showing out put like this
[root@localhost giis4.1]# echo "ID=123:one=a:two=a@yahoo.com:three=789:four=:five=123" | sed 's/\(.*=\)\(.*\):\(.*=\)\(.*\):\(.*=\)\(.*\):\(.*=\)\(.*\):\(.*=\)\(.*\):.*$/\/\/begin\
> \2\
> \4\
> \6/'
'//begin
123
a
a@yahoo.com
[root@localhost giis4.1]#

i wanna output like
//begin
a
a@yahoo.com
789

123

in this four has blank
coz, it has no number.

how can can i get this

please help me

thank you in advance

[birdman]

I like sed and use it liberally but I would use cut and a bit of logic for this:

count=1
test="ID=123:one=a:two=a@yahoo.com:three=789:four=:five=123"
while [ `echo $test | cut -d: -f$count` ]
do 
    both=`echo $test | cut -d: -f$count`
    first=`echo $test | cut -d: -f$count | cut -d= -f1`
    second=`echo $test | cut -d: -f$count | cut -d= -f2`
    if [ $first == "ID" ]
    then
        echo "//begin"
    else
        echo $second
    fi
    count=$((count + 1))
done

Regards

[munna_dude]

I like sed and use it liberally but I would use cut and a bit of logic for this:

test="ID=123:one=a:two=a@yahoo.com:three=789:four=:five=123
one=b:two=b@yahoo.com:three=9:four=1:five=23
one=c:two=c@yahoo.com:three=7:four=:five=12
one=d:two=d@yahoo.com:three=:four=1:five=13
:/"

Regards

if i take like this
it is not printing any messages.
it has to be print like this
//begin
a
a@yahoo.com
789

123
//begin
b
b@yahoo.com
.........
.......
.......
like this


can you help me in this way

thank you in advance

[Saurabh0008]

count=1
test="ID=123:one=a:two=a@yahoo.com:three=789:four= :five=123"
while [ -n "$( echo $test | cut -f$count -d':' )" ]
do
x=$( echo $test | cut -f$count -d':' )
if [ "$count" -eq 1 ]
then
echo Begin
x=$( echo $x | cut -f2- -d'=' | cut -b2- )
echo $x
else
x=$( echo $x | cut -f2 -d'=')
echo $x
fi
((count=count+1))
done

[munna_dude]

count=1
count=1
test="ID=123:one=a:two=a@yahoo.com:three=789:four= :five=123"
while [ -n "$( echo $test | cut -f$count -d':' )" ]
do
x=$( echo $test | cut -f$count -d':' )
if [ "$count" -eq 1 ]
then
echo Begin
x=$( echo $x | cut -f2- -d'=' | cut -b2- )
echo $x
else
x=$( echo $x | cut -f2 -d'=')
echo $x
fi
((count=count+1))
done

it giving output like this
Begin
23
a
a@yahoo.com
789

123
i no need of getting "23" after Begin.

and the in must be
test="ID=123:one=a:two=a@yahoo.com:three=789:four= :five=123
one=b:two=b@yahoo.com:three=9:four=1:five=23
one=c:two=c@yahoo.com:three=7:four=:five=12
one=d:two=d@yahoo.com:three=:four=1:five=13
:/"

can you help me
thank you in advance

[munna_dude]

hi
i tried this also

count=1
test="list=S$ID=123:one=a:two=a@yahoo.com:three=789:four=:five=123
ID=123:one=b:two=b@yahoo.com:three=9:four=1:five=23
ID=123:one=c:two=c@yahoo.com:three=7:four=:five=12
ID=123:one=d:two=d@yahoo.com:three=:four=1:five=13"
while [ -n "$( echo $test | cut -f$count -d':' )" ]
do
x=$( echo $test | cut -f$count -d':' )
if [ "$count" -eq 1 ]
then
echo Begin
x=$( echo $x | cut -f2- -d'=' | cut -b3- )
echo $x
else
x=$( echo $x | cut -f2 -d'=')
echo $x
fi
((count=count+1))
done

it is giving output like

[root@localhost ~]# /root/Desktop/1234/ram4
Begin
123
a
a@yahoo.com
789

123 ID
b
b@yahoo.com
9
1
23 ID
c
c@yahoo.com
7

12 ID
d
d@yahoo.com

1
13
[root@localhost ~]#

i wanna have output like

Begin
a
a@yahoo.com
789

123
Begin
b
b@yahoo.com
9
1
23
Begin
c
c@yahoo.com
7

12
Begin
d
d@yahoo.com

1
13

can you help me

thank you in advance

[drl]

Hi.

One way to approach this in perl:

#!/usr/bin/perl

# @(#) p1       Demonstrate non-greedy perl match.

use warnings;
use strict;

my ($lines) = 0;
my ( $i, $j, @a );

while (<>) {
    $lines++;
    @a = ();
    s/$/:/;    # add closing delimiter
    (@a) = /.*?=(.*?):/g;    # extract =(anything):

    $j    = 0;
    $a[0] = "Begin";         # replace first element
    foreach $i (@a) {
        print $i, "\n";
        $j++;
    }
}

print STDERR " ( Lines read: $lines )\n";

exit(0);

Which produces:

% ./p1 data1
Begin
a
a@yahoo.com
789

123
Begin
b
b@yahoo.com
9
1
23
Begin
c
c@yahoo.com
7

12
Begin
d
d@yahoo.com

1
13
 ( Lines read: 4 )

Best wishes ... cheers, drl

[munna_dude]

it giving output like this
Begin
23
a
a@yahoo.com
789

123
i no need of getting "23" after Begin.

and the in must be
test="ID=123:one=a:two=a@yahoo.com:three=789:four= :five=123
one=b:two=b@yahoo.com:three=9:four=1:five=23
one=c:two=c@yahoo.com:three=7:four=:five=12
one=d:two=d@yahoo.com:three=:four=1:five=13
:/"

can you help me
thank you in advance

i tried

output is
[root@localhost ~]# /root/Desktop/1234/pearl1 /root/Desktop/1234/filename.txt
Begin
Begin
a
a@yahoo.com
789

123
Begin
b
b@yahoo.com
9
1
23
Begin
c
c@yahoo.com
7

12
Begin
d
d@yahoo.com

1
13
( Lines read: 5 )
[root@localhost ~]#
Begin coming two times (at first line),

can u help thank you in advance

[drl]

Hi.

I used this data set:

ID=123:one=a:two=a@yahoo.com:three=789:four=:five=123
ID=123:one=b:two=b@yahoo.com:three=9:four=1:five=23
ID=123:one=c:two=c@yahoo.com:three=7:four=:five=12
ID=123:one=d:two=d@yahoo.com:three=:four=1:five=13

Please post the data set you used ... cheers, drl

[Saurabh0008]

hi,
i would like to know whether ur i/p is from a file or from the terminal.and secondly is $test getting single values i.e "id=123........................................... ........:five=...." .