View previous topic :: View next topic
|
Author |
Message |
picus_mf Warnings : 1 New User
Joined: 09 Jun 2006 Posts: 52
|
|
|
|
Hi,
I am trying to use the character data as numeric from the file I receive.
Code: |
TOTAL LOSS IN - 139,454.00-
|
The value always comes at column 41. My shop has SYNCSORT.
I could manage few things like converting from csv to regular flat file and removal of low-values to spaces. As this is a new requirement and there is no other business logic involved I am trying this in sort. Can you guide me to resolve this?
regards |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Since you have Syncsort, this should be in the JCL forum, not the DFSORT forum.
You have a Signed Free Format number. Look in your Syncsort manual for how to make that into the format you require. You can also do a search in the JCL forum for SFF to get some examples. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
picus_mf wrote: |
I am trying to use the character data as numeric from the file I receive. |
Once the data is treated as "numeric", what is next? Are you done with it, at the moment? |
|
Back to top |
|
|
|