Jump to content
Macro Express Forums

Help Requested


Recommended Posts

I'm pulling what hair is left, out...LOL


There are 3 pieces of unwanted text in my output that I cannot get rid of. I've tried padding, replacing, etc. If someone can take a peek and give some advice that would be swell. I have 8 others just like the attached but with different generation dataset names. Thanks in advance





<CLEARVAR1:T:ALL><CLEARVAR1:N:ALL><DOFILE:08:NN:c:\hisp1.txt>><BTFBEG:001:000001:000000:c:\hisp.txt><IFVAR2:1:01:8:IDCAMS SYSTEM SERVICES><TMVAR2:21:01:01:000:000:IDCAMS SYSTEM SERVICES ><ENDIF><IFVAR2:1:01:7:HISP><IFVAR2:1:01:8:HIST><IVAR2:01:13:1:HISP.TSI.GMC.EXTRACT1.INPAT.><TMVAR2:10:02:01:016:051:><TMVAR2:20:02:00:000:000:C:\hisp1.txtF><ENDIF><ENDIF><IFVAR2:1:01:7:CREATION--------><IFVAR2:1:01:8:HIST><IVAR2:01:13:1:CREATION--------><TMVAR2:10:04:01:053:060:><TMVAR2:04:04:00:000:000:><TMVAR2:10:06:01:058:060:><TVAR2:03:01: ><IFVAR2:1:06:4:308><TMVAR2:20:03:00:000:000:C:\hisp1.txtF><TMVAR2:20:04:00:000:000:C:\hisp1.txtF><ELSE><TMVAR2:20:03:00:000:000:C:\hisp1.txtF><TMVAR2:20:04:00:000:000:C:\hisp1.txtT><ENDIF><ENDIF><ENDIF><IFVAR2:1:01:7:STATUS------------><IFVAR2:1:01:8:HIST><IVAR2:01:13:1:STATUS------------><TMVAR2:10:05:01:026:031:><TMVAR2:04:05:00:000:000:><TMVAR2:20:03:00:000:000:C:\hisp1.txtF><TMVAR2:20:05:00:000:000:C:\hisp1.txtT><ENDIF><ENDIF><BTFEND>


Link to comment
Share on other sites


1. Slow, using vbs; are you in a rush? [** Assuming the 3 digits are day number of year and NOT after today!]

Variable Set String %T11% "210"

Variable Modify String: Save %T11% to Environment Variable

Variable Set String %T12% "2005"

Variable Modify String: Save %T12% to Environment Variable

Macro Run: DateSerialDiffVBS

Date/Time: Save "yyyyMMdd" into %T1%

Text Box Display:



Date in T1=%T1%>

Needs attached macro imported to you current mex library;


[cf previous post for example macro]

EDIT; Of course, you only have to run this slow vbs once, because it gives you today's "Day of yaer" as sum of original number plus returned "%DateDiff%" from that; so you can

a. calculate any further differences from today's day number of year for the 3 digit

b. put them into N1,

c. put them in the "days back" from today


Best, Randall


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...