|
View previous topic :: View next topic
|
| Author |
Message |
sriram_motamarri
Warnings : 1
New User
.jpg)
Joined: 14 Sep 2006
Posts: 11
Location: Chennai
|
|
|
|
I have a file which is basically coma delimited file.
I want to extract the fileds of it.
One of the field is some units, in the file the value is 7.323
I read it in the program as S9(3)V9(6).
The output field as defined as S9(3)V9(6).
But i am getting S0c7 while moving them.
Please help |
|
| Back to top |
|
 |
Bill O'Boyle
CICS Moderator
Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA
|
|
|
|
Are you saying that the decimal-point is implied or is actually present in the CSV file?
If it is actually present (a/k/a an edit-pattern field), then you need place this value into an edited-field (999.999999) then move this edit-pattern field into a field defined as S9(03)V9(06). This is sometimes known as "de-editing".
I'm also assuming that the data-length is always 09-bytes.
Will the decimal-data always be positive? If so, then there's no need to define the field as signed display-numeric.
Bill |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
I'm also assuming that the data-length is always 09-bytes.
|
If the units value might contain less than 10 positions (999.999999) or 11 if there is a possible negative value, you might consider doing the UNSTRING into a pic x field and then using NUMVAL to move the units value to the 999v(9) field. The sample value posted is only 5 positions in length.
As Bill mentioned, if the value cannot ever be negative, there is no need to make the target field signed. |
|
| Back to top |
|
|
Bill O'Boyle
CICS Moderator
Joined: 14 Jan 2008
Posts: 2501
Location: Atlanta, Georgia, USA
|
|
|
|
| Quote: |
I'm also assuming that the data-length is always 09-bytes.
|
Dick,
I do my best counting after Thanksgiving. Altryptophan overdose ya know 
Bill |
|
| Back to top |
|
|
sriram_motamarri
Warnings : 1
New User
Joined: 14 Sep 2006
Posts: 11
Location: Chennai
|
|
|
|
Hi Bill,
Yes the decimal point is implied in the CSV file.
Please tell me how i need to read it and move.
Let say the value is 7.233
The field i want in the output file is +007233000
i.e.,S9(3)V9(6)
Thanks,
Sriram |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
As i mentioned previously, define the receiving field from the unstring as pic x(10) or x(11) depending on whether there might be a negative value and then use the NUMVAL function.
NUMVAL is fully documented in the cobol language reference available vie the "IBM Manuals" link at the top of the page.
You will find that you receive faster "help" if you follow suggestions when they are initially posted. . .  |
|
| Back to top |
|
|
|
|
