View previous topic :: View next topic
|
Author |
Message |
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Hi,
1. I need to convert YYYY-MM-DD to YYYYMMDD.
2. Input field lenght = 6
Input values Expected output
-------------------------------------------------
4578 +04578
256 +00256
-8985 -08985
Need to padd with leading zeros with sign. |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Sorry for posting again, due to web constraints, it is not that clear for 2nd query.
Input values
--------------
4578
256
-8985
Expected output
-------------------
+04578
+00256
-08985 |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
Hi all,
First issue is solved using
OUTREC FIELDS = (1:1,4,5:6,2,7:9,2)
But can anyone give solution for 2. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
For 2, you can use these DFSORT control statements:
Code: |
OPTION COPY
INREC BUILD=(1,5,SFF,M26,LENGTH=6)
|
For complete details on DFSORT's SFF format, see:
Use [URL] BBCode for External Links |
|
Back to top |
|
|
|