View previous topic :: View next topic
|
Author |
Message |
Nitin Bhargava
New User
Joined: 22 May 2012 Posts: 32 Location: india
|
|
|
|
Hi All,
I am having a file which is as follows:
Code: |
S.N LN FN MIDDLE COUNTRY PIN
001 FYKE,THOMAS L INDIA 450010
002 NITESH, JHA KUMAR US 458-96
003 ROHIT, SIGHAI S INDIA 456101 |
The output expected is as per below rules
Sequence number should start from 1st position.
Name present before "," is last name and in output it should start from 10th position.
Field after last name is first name and should start from 30th position (it could start with spaces or from a character).
Middle name and last name are seperated by a single space.
If Middle name is only for one character then it should be populated in 50th postion. if it is more than one character it should dtart from 60th position.
rest of the record will start from 70 th position.
Its a FB with record lenght 1000.
The output will look like
Code: |
001 FYKE THOMAS L INDIA 450010
002 NITESH JHA KUMAR US 458-96
003 ROHIT SIGHAI S INDIA 456101 |
Regards
Nitin bhargava |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You need to post the expected output using that sample input (in addition to just posting the "rules").
Note: The requested info has been added to the original post . . . |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
Nitin Bhargava,
Counting characters or just parsing the input and placing in fixed positions?. I believe this is an extension of another topic about dates. |
|
Back to top |
|
|
Nitin Bhargava
New User
Joined: 22 May 2012 Posts: 32 Location: india
|
|
|
|
nopes its different this time, |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
nopes its different this time, |
Is there any use to this reply
What about answering the question Kolusu asked
@Kolusu,
The link above appears to be a self-reference to this topic? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Nitin Bhargava wrote: |
nopes its different this time, |
'so give me my solution, now!' |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
dick scherrer wrote: |
Hello,
Quote: |
nopes its different this time, |
Is there any use to this reply
What about answering the question Kolusu asked
@Kolusu,
The link above appears to be a self-reference to this topic? |
dick scherrer,
I was referring to this topic by Nitin Bhargava
ibmmainframes.com/about59707.html |
|
Back to top |
|
|
Nitin Bhargava
New User
Joined: 22 May 2012 Posts: 32 Location: india
|
|
|
|
Hi,
Do we have any option to do it?
Regards
Nitin Bhargava |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Yes. You've been asked, more than once, for more information. I'm not sure anyone is going to do anything until you provide it. |
|
Back to top |
|
|
|