IBM Mainframe Forum

Hi All,

I want to extract numeric data from a record.

Input Record format is as follows
--------------------------------------
Loaded 138 rows into database
Loaded 12345 rows into database
Loaded 1 row into database
Loaded 1234567 rows into database

i want to extract only counts from these records

Expected Output
-------------------
00000138
00012345
00000001
01234567

Can any one please let me know how to get this by using sort card.. Thanks in advance

Tammire,

You can try this code



Note:- Tested on Synsort 1.4.0.1R.

Hi Trinadh,

I have tried with the sort card which you have provided. But the thing is counts are not populating correctly in output file.

Please find below the input,output and sort card details

Input:
------
Loaded 13 rows into the database
Loaded 98 rows into the database
Loaded 3 rows into the database
Loaded 94 rows into the database
Loaded 1 rows into the database
Loaded 7 rows into the database
Loaded 51 rows into the database
Loaded 1 rows into the database
Loaded 8 rows into the database

Output:
--------
01309662
09809662
30966209
09409662
10966209
70966209
05109662
10966209
80966209

Sort Card
------------


Please let me know where am doing wrong. Thank You

Code'd.

Output



Can you show us your input and output with codetags on before complaining?

"Rows" is in mixed-case, "ROW" on your Sort control card is in upper-case.

When you see unexpected results, try to understand then in the context of what is known. Look at those repeating values. Ask yourself where they come from. What has the same value and follows your numbers, in the data? What are the hex values of whatever follows it, and the values you'd get if you treat them as numbers?

These users thanked the author BillyBoyo for the post:

Pandora-Box (Tue Nov 27, 2012 2:15 pm)

Thanks for providing the solution.. Problem is with UPPER CASE.. now its working fine.. Thanks you

You can also try with this:



Have a look at the documentation for UFF and see why it works.

This is overly complex:



Here is a simpler version:

Thanks Billyboyo.. Both the sort cards you have provided are working...But need one more help..

My input is like this

Input:



Expected Output: Need output in below format



Can anyone please help me on this.. it would be very helpfull if we can get output by using sort card.. Thank You

Code'd

Have a look at PARSE in you manual. Have a look at WHEN=GROUP. With PARSE you can isolate the 2nd-to-last element of that first line, and with WHEN=GROUP you can PUSH that element so that it is available when processing the next line, from where you then get the number and output the two together. You'll need OUTFIL with OMIT/INCLUDE to get rid of any excess lines (you have two input, for each one output).