I need to remove low values in my field

shymala · New User Joined: 26 Jul 2018 Posts: 5 Location: india

Hi All,

I have a file which has a detail records and i am extracting the data for a particular field of pic x(16) which contains data+low values. The data in the field is varying for each record. If i do HEX ON i can see hexadecimal values in that. If I open the file in browse mode i can see the data as 123456789-12.....

o/p - i need to write only the data part(123456789-12) in the output file.

As of now i am using the solution as

1.inspect with replacing all low values by spaces
2. using reverse function i am trying to retrieview only the data part but i am failing at the count part.

Can anyone provide me the solution along with the code or explanation.

Thanks
Shyamala

Pandora-Box · Posted: Sun Jul 29, 2018 2:12 pm

Your explanation is not clear at all

Rohit Umarjikar · Posted: Sun Jul 29, 2018 6:49 pm

First of all if you want to keep the same variable and just need to replace low-values by spaces then you don’t need anything but just inspect and if you want to extract the number part and would like to move it to another field then use substring after replacing low-values to spaces.

shymala · New User Joined: 26 Jul 2018 Posts: 5 Location: india

Hi Rohit,

How to use substring can you give me one example of the code.

Thanks
Shymala

Nic Clouston · Posted: Mon Jul 30, 2018 4:37 am

Is it so hard to look in the index of the COBOL Language Refernce manual for Substring and then go the the linked page?

Marso · Posted: Mon Jul 30, 2018 7:25 pm

You have to explain yourself better than that.

What do you mean by 'data'. Everything, including low-values, can be data !
Is the 'data' you need a number or is it alphanumeric ?
This means nothing: (you can look at low-values in hexa and you will see hexadecimal values as well)

Quote:

If i do HEX ON i can see hexadecimal values in that
What does that mean ?

Quote:

... 123456789-12 .....

RahulG31 · Active User Joined: 20 Dec 2014 Posts: 446 Location: USA

This should also work:

shymala · New User Joined: 26 Jul 2018 Posts: 5 Location: india

Hi all,

I have resolved my issue by using function reverse. Thanks all of you for responding to my question.But now I need 1 more info let me explain.

I need to concatenate 2 fields in my o/p file.
as of now I am getting the o/p as

{12345678} {1:1234:456}
I have a gap in b/w these 2 fields because of varying length of field1 the actual o/p should be
{12345678}{1:1234:456}

the important thing here is field 1 will be having varying length. say for example
{123}
{12345}
the 1st field length is 16 characters.

can anyone help me in solving this problem

Nic Clouston · Posted: Wed Aug 01, 2018 7:23 pm

Please start a new topic for a new question.
When doing so please specify if that is the only space in your data (between fields) or can your actual data contain spaces?
Also show what you have tried. You actually have a possible solution, using substring (reference modification in COBOL terminology), in a previous post in this topic.