Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
theone1987

New User

Joined: 14 Sep 2009
Posts: 60
Location: Milan

Posted: Mon Oct 25, 2010 2:48 pm    Post subject: Conversion to editable format using SORT

Hi everyone,
i have a number in this format
 Code: ÷      E000000 1830001

i want convert in this format
 Code: 1080300000001

how can i do it whit sort?

thank you
L

Arun Raj

Moderator

Joined: 17 Oct 2006
Posts: 2361
Location: @my desk

 Posted: Mon Oct 25, 2010 3:59 pm    Post subject: theone1987, Your input has only X'080300000001' preceded by X'E1' ie., '÷' symbol. Where did the prefix '1' in the expected output come from?
theone1987

New User

Joined: 14 Sep 2009
Posts: 60
Location: Milan

Posted: Mon Oct 25, 2010 4:06 pm    Post subject:

 Arun Raj wrote: theone1987, Where did the prefix '1' in the expected output come from?

I thought that X'E1' = 1 (otherwise how could I convert X'E1'?)
Arun Raj

Moderator

Joined: 17 Oct 2006
Posts: 2361
Location: @my desk

Posted: Mon Oct 25, 2010 4:46 pm    Post subject:

 theone1987 wrote: I thought that X'E1' = 1 (otherwise how could I convert X'E1'?)
How did you arrive at this conclusion!! You need to be clear on what you're trying to achieve.
dick scherrer

Site Director

Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

Posted: Mon Oct 25, 2010 7:24 pm    Post subject:

Hello,

 Quote: I thought that X'E1' = 1 (otherwise how could I convert X'E1'?)
Hex F1 is a one (1).

Suggest you edit a new little member and type in the alphabet (Upper case) and numbers zero thru nine. Then look at these in hex (HEX ON).

For more good info, entering the data in hex, create 16 lines with the hex values from 00-0F thru F0-FF. You will be able to see all 256 characters and the value they display on your terminal.
Frank Yaeger

DFSORT Moderator

Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

 Posted: Mon Oct 25, 2010 10:51 pm    Post subject: Theone1987, The single hexadecimal value you show is NOT any standard type of numeric. It's not PD - it's not ZD - I have no idea what it is. It's impossible to discern a pattern from one example. You need to explain the rules for converting this non-standard type of numeric before anyone can help you.
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics To remove spaces from a VB file using... Selvarajars DFSORT/ICETOOL 5 Thu Jun 21, 2018 6:57 pm Sort numeric fields with trailing spaces sancraig16 SYNCSORT 7 Tue Apr 03, 2018 1:21 am Find & Replace string in CA-SORT mrgnndhmk CA Products 1 Fri Mar 30, 2018 12:58 am SORT 3 files,extract specific fields ... Kiransr DFSORT/ICETOOL 13 Fri Mar 23, 2018 10:54 am How to Generate JCL using Sort naveen katkuri DFSORT/ICETOOL 7 Tue Mar 13, 2018 3:50 pm

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us