Text Alignment

Hi All,
I am newbie to Perl and wanted to achive the below goal.
I have a text file which is an output of export file, due to some
reasons all the notes fields in the export file is giving as mutliple
fields.

ex: "Developer Notes: PKAIRA: 1/23/2006 6:38:30 PM: Two digit value is
being retrived from the host itself.","Developer Notes: MGEAMAN:
6/23/2006 4:22:27 PM: Confirmed by BA that this is not an issue for
Profile. See attached email thread.","Investigation Note: DWILLIAMS:
11/24/2004 8:38:28 AM:”

Multiple line delimiter is ","

I want the result as below.

"Developer Notes: PKAIRA: 1/23/2006 6:38:30 PM: Two digit value is
being retrived from the host itself.
Developer Notes: MGEAMAN: 6/23/2006 4:22:27 PM: Confirmed by BA that
this is not an issue for Profile. See attached email thread.
Investigation Note: DWILLIAMS: 11/24/2004 8:38:28 AM:”

So that while importing i can make it as a one filed.

Thanks in Advance
Raju


--
gvsraju2k6
------------------------------------------------------------ ------------
gvsraju2k6's Profile: http://techiegroups.com/member.php?userid=118
View this thread: http://www.techiegroups.com/showthread.php?t=112134

Re: Text Alignment

gvsraju2k6 wrote:
> I am newbie to Perl and wanted to achive the below goal.
> I have a text file which is an output of export file, due to some
> reasons all the notes fields in the export file is giving as mutliple
> fields.
>
> ex: "Developer Notes: PKAIRA: 1/23/2006 6:38:30 PM: Two digit value is
> being retrived from the host itself.","Developer Notes: MGEAMAN:
> 6/23/2006 4:22:27 PM: Confirmed by BA that this is not an issue for
> Profile. See attached email thread.","Investigation Note: DWILLIAMS:
> 11/24/2004 8:38:28 AM:"
>
> Multiple line delimiter is ","
>
> I want the result as below.
>
> "Developer Notes: PKAIRA: 1/23/2006 6:38:30 PM: Two digit value is
> being retrived from the host itself.
> Developer Notes: MGEAMAN: 6/23/2006 4:22:27 PM: Confirmed by BA that
> this is not an issue for Profile. See attached email thread.
> Investigation Note: DWILLIAMS: 11/24/2004 8:38:28 AM:"
>
> So that while importing i can make it as a one filed.

You will get much more help if you attempt to "speak Perl" rather than
speak English. Show exactly what your input is, and how your program
is reading, storing, and processing it. Show exactly what your output
is, and how your program is generating it.

As a guess to waht you want, try to split the big field on the comma,
and then join the resulting strings with the newline.

perldoc -f split
perldoc -f join

for more information.

Paul Lalli