View previous topic :: View next topic
|
Author |
Message |
Niki
Active User
Joined: 20 Sep 2008 Posts: 106 Location: Bangalore
|
|
|
|
Hi Guys,
I have a input file in the following format:
Code: |
MEMBER20-FROM:AsfdfBC@XYZ.COM
MEMBER20-TO:DEF@XYZ.COM
MEMBER20-CC:GasdaHI@XYZ.COM
MEMBER09-FROM:ABC@XYZ.COM
MEMBER09-TO:JFGDGKL@XYZ.COM
MEMBER09-CC:MasdasdadNO@XYZ.COM
MEMBER09-CC:DasdasdEF@XYZ.COM
MEMBER09-CC:PQaR@XYZ.COM
|
The input file is FB of length 100 bytes.
I am trying to format the output as below:
Code: |
FROM TO CC
MEMBER20-AsfdfBC@XYZ.COM|DEF@XYZ.COM|GasdaHI.XYZ.COM
MEMBER09-ABC@XYZ.COM |JFGDGKL@XYZ.COM |MasdasdadNO@XYZ.COM,DasdasdEF@XYZ.COM,PQaR@XYZ.COM
|
The basic formatting needs to be done on the first 8 characters:.
If any thing in the TO/ CC/ FROM is having more than one entry then they needs to be appended as comma separated. There is no fixed length of the email ID.
Could someone please help me with this. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
Wouldn't it be simpler and flexible to do it in Cobol or any other language program of your comfort ? Why go fancy? Someone else later working on it will find it easy and maintainable if we keep it easy at first place. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Niki,
Well, regardless of the programming language you might want to think about how you are going to handle if the 'comma separated CC email ids' is too long to be accommodated in one record. Can you show such an example with the expected output? |
|
Back to top |
|
|
|