Hi Timo,
I'm trying to extract the data from the global, take specific pieces out, and put them in a spreadsheet. The issue is the string contains multiple "$lb" references and control characters.
for example, in one node the data looks like:
=$lb("",0,0,"","",0,67229,"Switches the journal file at midnight every day","",,,0,"","Success","%SYS.Task.SwitchJournal",1,"","","",0,"67228,0","67228,0","67228,0","Switch Journal","%SYS",,0,"","",0,1,,"",63259,"1",0,0,0,"",1,0,,,1,"BE25EA0C-AA13-11E3-A20D-10604BA47730","","_SYSTEM","",3,0)

and in another:
$lb("","0",0,0,"","0","","Back load ADA/Bureau Assignments and Summary Table","",,,0,"","","%SYS.Task.RunLegacyTask",0,"","","",0,0,0,0,"BackLoadAssign","CONVERT",,0,"","",0,0,,"",63476,"1",0,"",5,"","1",2,,,1,"59CB1202-54B9-11E4-84ED-10604BA47730","","molan1",$lb("ExecuteCode","Q  ; D:$g(^LOG.AssignmentSummaryD)<1 FixBurCodeToName^VBASSIGNMENTS2,STEP1^VBASSIGNMENTS,STEP2^VBASSIGNMENTS,STEP4^VBASSIGNMENTS2,STEP5^VBASSIGNMENTS,STEP6^VBASSIGNMENTS,STEP7^VBASSIGNMENTS,STEP9^VBASSIGNMENTS"),1,0)
 

that doesn't generate the .int from the .mac, only the existing .mac

just an fyi. when the .mac's are generated they do not create the associated .int's

thanks!

I tried that one before but it never makes it all the way through because of to many errors