View previous topic :: View next topic
|
Author |
Message |
beruoist
New User
Joined: 14 Nov 2007 Posts: 70 Location: mumbai
|
|
|
|
Actually the requirement is to put a seperator value in the FILLER A1
as H'05' . I have never encountered such thing previously.
Can anyone help me on this.
Regards
beruoist |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
Is it something related to Natural? MQ? Can you elaborate more, maybe with some sample?
O. |
|
Back to top |
|
|
acevedo
Active User
Joined: 11 May 2005 Posts: 344 Location: Spain
|
|
|
|
the value is x'05' not h'05'. |
|
Back to top |
|
|
beruoist
New User
Joined: 14 Nov 2007 Posts: 70 Location: mumbai
|
|
|
|
No,Its something related to creating tabs(purpose can be downloading it to excel) .Not sure why they asked us to code like that.But below is the thing what i found out.
1 SOME-DATA (A10)
1 Redefine SOME-DATA
2 A-data (A2)
2 Filler1 (A1)
2 B-data (A2)
2 filler2 (A1)
2 C-data (A4)
move H'05' to Filler1 Filler2
Move 'AB' to A-data
move 'CD' to B-data
move 'EFGH' to C-data
write work file 1 some-data
The data will look as follows in browse mode
AB.CD.EFGH
and in edit mode
AB BC EFGH
PLEASE REVIEW AND POST YOUR SUGGESTIONS |
|
Back to top |
|
|
beruoist
New User
Joined: 14 Nov 2007 Posts: 70 Location: mumbai
|
|
|
|
Ofer,
It is related to creating reports,though there are many other easier and known ways to create tabs,they asked me to do in thier own way.
Can't help as i had never heard of it.The requirement says
Field variable Pos Length Database field Remark
#VAR-A 5 A3 XYZ
# FILLER-1 6 A1 H’05’ Excel separator
Thanks
beruoist |
|
Back to top |
|
|
helga
New User
Joined: 11 Sep 2006 Posts: 23
|
|
|
|
Quote: |
the value is x'05' not h'05'. |
Not true. It's H'05' in Natural.
...which is what we're talking about here. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
It is related to creating reports,though there are many other easier and known ways to create tabs,they asked me to do in thier own way. |
When you download data to use in a pc application (like a spreadsheet), it is most common to download a "tab-delimited" file.
The Hex'05' is the tab character.
When you become familiar/comfortable with this approach, you will find it may be the easiest way to create data to download for win-based reporting/loading. |
|
Back to top |
|
|
|