handling linux files

[charithainfadev]

Hi, I have a linux file that has data like this..
REQUEST_ID|text^Ctext^Ctext^C
REQUEST_ID|text^Ctext^C
REQUEST_ID|
REQUEST_ID|
REQUEST_ID|text^Ctext^Ctext^Ctext^Ctext^Ctext^C....
Where ever I see a ^C character, I need to copy the corresponding REQUEST_ID and that part of the text to a new line. so my destination file should look like this..
REQUEST_ID|text
REQUEST_ID|text
REQUEST_ID|text
.
.
How should I do this? I have no idea how to do this because I have no knowledge in unix or linux so far..

[charithainfadev]

please some one reply to my post. I need help! quick help please... i can provide any further information required..

[EINSTEIN_007]

I think that you could do that with python (.ini-Style config files): http://docs.python.org/library/configparser.html . You could just use sed with regexes, too (but forget the "easily" then, if you're not experienced a bit with sed ).

[charithainfadev]

Hi, Python??? I am very much unfamiliar...
I have been using sed. I am not that bad actually. But I have never done regexes. Can you please help me in using sed with regexes? how can I do that using sed?

[charithainfadev]

Can some one help me/ How to so this using sed regexes or awk

[dnigam]

not sure about ur exact pattern. However see if the following example helps.
I have used : as the seperator

x="12345|abc:def:u"

echo $x |sed -e 's/\([0-9]*|[a-z]*\):.*/\1/'

Hope this helps.