Ask The Expert Series on April 26, 2022 
Monarch & Monarch Server(Automator)

The Session began with a brief overview of Floating Traps in Monarch Complete v.2021 before diving into the LIVE Questions. 


The Session began with our Expert reviewing the following:

• Session began with Mo providing overview of the Monarch "Trapping" technique to identify certain lines within a Report(s) per Trapping Rules(instructions). {Covered within approximately the first 30-mins of the Session}  
  
  • Touched on Trapping Rules
  • Templates
  • Character Types
• Reviewed Standard Trap
• Reviewed Floating Trap - in how the data shifts around.
  
  • The KEY is to locate the consistent pattern to create the trapping pattern(rules)
    
    

LIVE Questions submitted:

Monarch:
1.  I have built a data prep workspace blending 2 files hoping to generate a properly formatted SDF file.  When I build the workspace into a visual process in Automator and then build out the export, I can get the export to export the file in SDF format but I always loose the column size formats, it has to be space delimited and each column has to be a particular length when the resulting SDF file is generated.  Can the experts provide any advice on how to resolve this?

• Mo reviewed & demonstrated how to correct this experience.  Will create a separate Post/KB to include the steps to resolve the above. 
  
  

2. Do floating traps work when the report is complex with the trap moving within a multiple line inspection?  

• Unfortunately, not.  Standard and Floating traps can only be applied to a single line.  It may be possible using RegEx trapping, but the order and consistency of the CR/LF would be important.

3.  The sub-functionality that Mo spoke to after selecting fields when trap on Line 1 is?

• If referring to splitting the last line into City, State, Zip?  One will utilize the split function available by right clicking in the prepare window.  There is a specific function for City, State, Zip and several other generic functions.

 
4.  Another issue also cropped up, we need a “CR” or carriage return that marks the end of the file and it’s format is a row of “9999”, do the experts have any idea how to end a file with a single row of all 99999999’s?   That is what I meant, 99999999999s that are the CR – Sounds like a total of 510 ‘9’ – basically the width of the file ?

• Ran out of time to review within the session.  Will create a separate Post/KB to include the steps to resolve the above. 

 

Additional Resources:

Using the Floating Trap - DPS     Using the Floating Trap- Classic      Split Address into Parts- DPS