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

thanks!

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

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

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)