Math Function in Xlate

This topic has 12 replies, 5 voices, and was last updated 11 years, 7 months ago by Shannon Laughlin.

Creator

Topic
March 20, 2014 at 5:19 pm #54109
Shannon Laughlin
Participant
Hello!

I need to add code to an existing xlate that checks the value in FT1;4 to see if it’s older than 183 days. The date is being sent as 20130830 in FT1;4.

Does anyone have ideas as to how I can accomplish this? I’m assuming I need to use a math function but I’ve never used one before. Any help would be greatly appreciated!

Best Regards,

Shannon
Creator

Topic

Viewing 11 reply threads

Author

Replies
- March 20, 2014 at 6:01 pm #80185
  Keith McLeod
  Participant
  How about using something like:
  
  lindex $xlateInVals 0 (represents your ft1:4 value)
  
  if {[clock scan [lindex $xlateInVals 0]] > [clock scan “183 days ago”]} {
  
  echo “It is less than 183 days ago”
  
  set xlateOutVals
- March 21, 2014 at 5:32 pm #80186
  Shannon Laughlin
  Participant
  Hi Keith! Thanks for your suggestion. I need to suppress any message that is not older than 183 days so would I put the code you provided within the IF statement or does this go in a tcl proc? I’m a little confused on where to place the code exactly. Thanks again for yourh help!
  
  Best Regards,
  
  Shannon
- March 21, 2014 at 6:44 pm #80187
  Keith McLeod
  Participant
  Shannon,
  
  If your objective is to filter the message, I generally would put it into a tps tclproc and use it in the PreXlate location by setting your message disposition to either kill or continue.
  
  If you want to use it in the xlate, I would suggest the preproc location with FT1:4 as your source. Some folks use code snippets here or place this code into xltp tcl procs. I have added a few attachments that may help….
  
  Either way, you may want to think about the FT1 segment can repeat. Are you planning on killing the message if one occurrence is older than 183 days….?
  
  Hope this helps…
- March 21, 2014 at 7:10 pm #80188
  Shannon Laughlin
  Participant
  Thank you very much! Also, good call on the fact that FT1;4 repeats! I will take that into consideration upon deciding where to place the code. I greatly apprecaite your help!
  
  Best Regards,
  
  Shannon
- March 24, 2014 at 4:32 pm #80189
  Shannon Laughlin
  Participant
  Hi Keith,
  
  I tried using the code you provided but I’m getting an error. Have you seen this error before?
  
  RUNNING INBOUND TPS IN START MODE
  
  DONE STARTING INBOUND TPS
  
  out is -> 3
  
  xlateInVals=201308301400
  
  xlateInVals=20130830
  
  xlateInVals=40630386
  
  [xlt :xlat:ERR /0: UNNAMED_TID:03/24/2014 09:29:54] [0.0.4] Xlate ‘stjo_dft_cer_6mtn_report_xlate.xlt’ failed: Tcl callout error
  
  if {[clock scan[lindex $xlateInVals 0]] > [clock scan “183 days ago”]}
  
  {echo “It is less than 183 days ago”
  
  set xlateOutVals
- } else {
  echo “It is greaer than 183 days ago”
  
  set xlateOutVals
- }:
  errorCode: NONE
  
  errorInfo:
  
  bad option “scan20130830”: must be clicks, format, scan, or seconds
  
  while executing
  
  “clock scan[lindex $xlateInVals 0]”