| Author |
Message
|
| james2005 |
 Posted: Mon Jan 23, 2006 4:20 am Post subject: TDS MESSAGE SET MODELLING |
 |
|
Apprentice
Joined: 18 Sep 2005
Posts: 31
|
TDS MESSAGE SET
---------------------
I HAVE A REQUIREMENT TO MODEL A TDS MESSAGE SET FOR MY PROJECT.I HAVE A FILE
THAT LOOKS LIKE THIS
HEAD EXPENSES20040107214623ANZ
00221351 964P000959
00221351 991P036695
00221351 993P002770
00221604 964P000959
00221604 993P002770
00221604 99DP006005
00221604 99EP010165
00221604 99LP023852
TRAILEXPENSES2004010721462301611
DATA AFTER MODELLING SHOULD LOOK LIKE THIS (IN THE TREE STR)
HEADERRECORD
|- TITLE = HEAD EXPENSES ( LENGTH IS 1-13)
|- CREATEDATE = 2004010 ( LENGTH IS 14-21)
|- CREATETIME = 7214623 ( LENGTH IS 22-27)
|- ANZ = ANZ ( LENGTH IS 28-30)
DEATILRECOED
|- GROUPNO = 002 ( LENGTH IS 1-3)
|- EMPNO = 21351 ( LENGTH IS 4-
|- DATACODE = 964 ( LENGTH IS 11-13)
|- VALUE = P000959 ( LENGTH IS 14-21)
TRAILRECORD
|- TITLE = TRAILEXPENSES ( LENGTH IS 1-13)
|- CREATEDATE = 2004010 ( LENGTH IS 14-21)
|- CREATETIME = 72146230 ( LENGTH IS 22-27)
|- NOOFENTRY = 1611 ( LENGTH IS 28-32)
PLEASE DO ADVISE HOW TO GO ABOUT IT. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Jan 23, 2006 5:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I'd advise the following steps.
1) Do not post in all caps.
2) Do not post a requirement. You're getting paid by someone to fulfill that requirement. We're not. It's your job to fulfill that requirement, and not ours.
3) Do read the documentation.
4) Do post what you have tried to do.
5) Do post the error messages you have received.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| dipankar |
| Posted: Mon Jan 23, 2006 9:28 pm Post subject: |
|
|
Disciple
Joined: 03 Feb 2005
Posts: 171
|
Try to use Tag delimiter
_________________
Regards |
|
| Back to top |
|
|
| javaforvivek |
| Posted: Fri Jan 27, 2006 3:39 am Post subject: |
|
|
Master
Joined: 14 Jun 2002
Posts: 282
Location: Pune,India
|
Hi,
Just for my own sake, I tried to build the required message definition. But I am confused at one thing.
In line
00221351 964P000959
The elements are:
DETAILRECORD
|
-GROUPNO = 002 ( LENGTH IS 1-3)
|
-EMPNO = 21351 ( LENGTH IS 4- ?)
|
-DATACODE = 964 ( LENGTH IS 11-13)
|
-VALUE = P000959 ( LENGTH IS 14-21)
So EmpNo can either be of length 7 or can be marked as the element starting from fourth place till the first white space occurs.
How to build this element?
Rest is working fine.
_________________
Vivek
------------------------------------------------------
...when you have eliminated the impossible, whatever remains, however improbable, must be the truth. |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Jan 27, 2006 8:42 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi javaforvivek,
I think you will have to just specify the length....you cannot be sure of getting a space everytime....the emp no might just be "21351x"
Regards. |
|
| Back to top |
|
|
|
|
