IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Reformat and relocate content
IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
vice_versa
Warnings : 1
New User


Joined: 26 Feb 2006
Posts: 19
Location: usa
PostPosted: Tue Dec 27, 2022 12:33 pm
 Reply with quote
Hi all,
The input file as blow :
Code:
 input:                                                                                            
input:                                                                                            
9988383883890612099       # 20220101# 00234539# 9999#10000#2816.22#+1000049901#                   
3282373778033667999         # 20220101# 00234543# 6696#257800#1406323.98#+3783733657117#           
2347347723773276149      # 20220101# 00234540# 9999#4641#4368.03#+23690#                         
3832832823837275101      # 20220101# 00234551# 9999#500#252.95#+1330039801#                     
3732732727373777774      # 20220101# 00234558# 9999#10#.10#+31054101#                           
                                                                                                 
output:                                                                                         
                                                                                                 
9988383883890612099      # 20220101# 00234539# 9999#   100.00    #      2816.22     #+1000049901   #
3282373778033667999      # 20220101# 00234543# 6696#  2578.00    # 1406323.98     #+3783733657117#
2347347723773276149      # 20220101# 00234540# 9999#    46.41     #    4368.03     #+23690        #
3832832823837275101      # 20220101# 00234551# 9999#     5.00      #      252.95     #+1330039801   #
3732732727373777774      # 20220101# 00234558# 9999#     0.10      #        0.10      #+31054101     #

 



how can do it? thanks in advance. [/list]
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1255
Location: Bamberg, Germany
PostPosted: Tue Dec 27, 2022 1:00 pm
 Reply with quote
Update your samples. I don't think they look like this.
Back to top
View user's profile Send private message
vice_versa
Warnings : 1
New User


Joined: 26 Feb 2006
Posts: 19
Location: usa
PostPosted: Tue Dec 27, 2022 2:02 pm
 Reply with quote
Joerg.Findeisen wrote:
Update your samples. I don't think they look like this.

    Code:

    Input:
    9988383883890612099      # 20220101# 00234539# 9999#10000#2816.22#+1000049901#                         
    3282373778033667999      # 20220101# 00234543# 6696#257800#1406323.98#+3783733657117#                 
    2347347723773276149      # 20220101# 00234540# 9999#4641#4368.03#+23690#                               
    3832832823837275101      # 20220101# 00234551# 9999#500#252.95#+1330039801#                           
    3732732727373777774      # 20220101# 00234558# 9999#10#.10#+31054101#                                 
                                                                                                           
    output:                                                                                                           
                                                                                                                     
    9988383883890612099      # 20220101# 00234539# 9999#   100.00        #          2816.22       #+1000049901      #
    3282373778033667999      # 20220101# 00234543# 6696#  2578.00        #       1406323.98       #+3783733657117   #
    2347347723773276149      # 20220101# 00234540# 9999#    46.41        #          4368.03       #+23690           #
    3832832823837275101      # 20220101# 00234551# 9999#     5.00        #           252.95       #+1330039801      #
    3732732727373777774      # 20220101# 00234558# 9999#     0.10        #             0.10       #+31054101        #

Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1255
Location: Bamberg, Germany
PostPosted: Tue Dec 27, 2022 3:50 pm
 Reply with quote
Use INREC PARSE to split the fields by delimiter, then rebuild as needed.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2023
Location: USA
PostPosted: Tue Dec 27, 2022 6:06 pm
 Reply with quote
Please, read this:

Using %nnn, %nn and %n Parsed Fields with BUILD and OVERLAY
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 

Similar Topics
Topic Forum Replies
No new posts How to Reformat a file using File Man... All Other Mainframe Topics 14
No new posts Setting CA7 user variable from data s... CA Products 7
No new posts REXX table content on panel will be r... CLIST & REXX 6
No new posts How to modify file content using REXX CLIST & REXX 3
No new posts Reformat for VB file SYNCSORT 11
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us