{"action":"opened","number":51,"pull_request":{"url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls/51","id":210021272,"node_id":"MDExOlB1bGxSZXF1ZXN0MjEwMDIxMjcy","html_url":"https://github.com/MicrosoftDocs/VBA-Docs/pull/51","diff_url":"https://github.com/MicrosoftDocs/VBA-Docs/pull/51.diff","patch_url":"https://github.com/MicrosoftDocs/VBA-Docs/pull/51.patch","issue_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/issues/51","number":51,"state":"open","locked":false,"title":"Update links to glossaries","user":{"login":"Kagre","id":19843325,"node_id":"MDQ6VXNlcjE5ODQzMzI1","avatar_url":"https://avatars3.githubusercontent.com/u/19843325?v=4","gravatar_id":"","url":"https://api.github.com/users/Kagre","html_url":"https://github.com/Kagre","followers_url":"https://api.github.com/users/Kagre/followers","following_url":"https://api.github.com/users/Kagre/following{/other_user}","gists_url":"https://api.github.com/users/Kagre/gists{/gist_id}","starred_url":"https://api.github.com/users/Kagre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kagre/subscriptions","organizations_url":"https://api.github.com/users/Kagre/orgs","repos_url":"https://api.github.com/users/Kagre/repos","events_url":"https://api.github.com/users/Kagre/events{/privacy}","received_events_url":"https://api.github.com/users/Kagre/received_events","type":"User","site_admin":false},"body":"include targets into the links pointing to the glossary files.\r\n\r\n### Code: Copy/Paste \r\n\r\n```powershell\r\n#Fix glossary-links' targets\r\n$re = [regex]'(?s)\\[[^\\]]+\\]\\([^)]+(vbe-glossary.md|glossary-vba.md)\\)'\r\n$fList=@();ls *.md -recurse | %{if($re.IsMatch((gc $_) -join \"`n\")){$fList+=$_;}};$fList=($fList|sort -unique)\r\n$LookFor = '\\[(?''TargetName''[^\\]]+?)s?\\].*'\r\n$ReplaceWith = '${TargetName}'\r\nfilter fltr([switch]$Preview){\r\n   $content=(gc $_) -join \"`n\"\r\n   $mList = $re.matches($content)\r\n   if($mList.count -gt 0){\r\n      foreach($ToFind in $mList.value){\r\n         $Tag = ($ToFind -replace $LookFor,$ReplaceWith).replace(' ','-')\r\n         $ToSet = ($ToFind.substring(0,$ToFind.Length-1)+\"#$Tag)\")\r\n         $content = $content.replace($ToFind,$ToSet)\r\n      }\r\n      $pth = resolve-path $_ -relative\r\n      if($Preview){$pth = \".\\ReviewTmp\\$pth\";$null = (ni $pth -type file -force)}\r\n      sc $pth $content -force\r\n      resolve-path $pth -relative\r\n   }\r\n}\r\n#$fList[0..7] | fltr -preview | ac UpdatedFiles.txt\r\n$fList | fltr | ac UpdatedFiles.txt\r\n#$re.Matches((gc $fList[7]) -join \"`n\").value -replace $LookFor,$ReplaceWith\r\n\r\n#fix glossary terms that are supposed to end in s\r\n#$re = [regex]'(?m)^[\\s-[\\n]]*\\#\\#\\s*[^\\n]+?s[\\s-[\\n]]*$'\r\n$re = [regex]'\\#(system-color|base-clas?|clas?|date-separator|focu|in-proces?|intrinsic-constant)\\)'\r\n$fList=@();ls *.md -recurse | %{if($re.IsMatch((gc $_) -join \"`n\")){$fList+=$_;}};$fList=($fList|sort -unique)\r\n$LookFor = '\\#(?''CreamFilling''[^)]+)\\)'\r\n$ReplaceWith = '#${CreamFilling}s)'\r\nfilter fltr([switch]$Preview){\r\n   $content=(gc $_) -join \"`n\"\r\n   $mList = $re.matches($content)\r\n   if($mList.count -gt 0){\r\n      foreach($ToFind in $mList.value){\r\n         $ToSet = ($ToFind -replace $LookFor,$ReplaceWith)\r\n         $content = $content.replace($ToFind,$ToSet)\r\n      }\r\n      $pth = resolve-path $_ -relative\r\n      if($Preview){$pth = \".\\ReviewTmp\\$pth\";$null = (ni $pth -type file -force)}\r\n      sc $pth $content -force\r\n      resolve-path $pth -relative\r\n   }\r\n}\r\n$fList | fltr | ac UpdatedFiles.txt\r\n```","created_at":"2018-08-22T05:07:57Z","updated_at":"2018-08-22T05:07:57Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls/51/commits","review_comments_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls/51/comments","review_comment_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls/comments{/number}","comments_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/issues/51/comments","statuses_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/statuses/be86adffe9aaed312ff20e6ea37a961a64c38800","head":{"label":"Kagre:master","ref":"master","sha":"be86adffe9aaed312ff20e6ea37a961a64c38800","user":{"login":"Kagre","id":19843325,"node_id":"MDQ6VXNlcjE5ODQzMzI1","avatar_url":"https://avatars3.githubusercontent.com/u/19843325?v=4","gravatar_id":"","url":"https://api.github.com/users/Kagre","html_url":"https://github.com/Kagre","followers_url":"https://api.github.com/users/Kagre/followers","following_url":"https://api.github.com/users/Kagre/following{/other_user}","gists_url":"https://api.github.com/users/Kagre/gists{/gist_id}","starred_url":"https://api.github.com/users/Kagre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kagre/subscriptions","organizations_url":"https://api.github.com/users/Kagre/orgs","repos_url":"https://api.github.com/users/Kagre/repos","events_url":"https://api.github.com/users/Kagre/events{/privacy}","received_events_url":"https://api.github.com/users/Kagre/received_events","type":"User","site_admin":false},"repo":{"id":145166118,"node_id":"MDEwOlJlcG9zaXRvcnkxNDUxNjYxMTg=","name":"VBA-Docs","full_name":"Kagre/VBA-Docs","owner":{"login":"Kagre","id":19843325,"node_id":"MDQ6VXNlcjE5ODQzMzI1","avatar_url":"https://avatars3.githubusercontent.com/u/19843325?v=4","gravatar_id":"","url":"https://api.github.com/users/Kagre","html_url":"https://github.com/Kagre","followers_url":"https://api.github.com/users/Kagre/followers","following_url":"https://api.github.com/users/Kagre/following{/other_user}","gists_url":"https://api.github.com/users/Kagre/gists{/gist_id}","starred_url":"https://api.github.com/users/Kagre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kagre/subscriptions","organizations_url":"https://api.github.com/users/Kagre/orgs","repos_url":"https://api.github.com/users/Kagre/repos","events_url":"https://api.github.com/users/Kagre/events{/privacy}","received_events_url":"https://api.github.com/users/Kagre/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/Kagre/VBA-Docs","description":null,"fork":true,"url":"https://api.github.com/repos/Kagre/VBA-Docs","forks_url":"https://api.github.com/repos/Kagre/VBA-Docs/forks","keys_url":"https://api.github.com/repos/Kagre/VBA-Docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Kagre/VBA-Docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Kagre/VBA-Docs/teams","hooks_url":"https://api.github.com/repos/Kagre/VBA-Docs/hooks","issue_events_url":"https://api.github.com/repos/Kagre/VBA-Docs/issues/events{/number}","events_url":"https://api.github.com/repos/Kagre/VBA-Docs/events","assignees_url":"https://api.github.com/repos/Kagre/VBA-Docs/assignees{/user}","branches_url":"https://api.github.com/repos/Kagre/VBA-Docs/branches{/branch}","tags_url":"https://api.github.com/repos/Kagre/VBA-Docs/tags","blobs_url":"https://api.github.com/repos/Kagre/VBA-Docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Kagre/VBA-Docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Kagre/VBA-Docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/Kagre/VBA-Docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Kagre/VBA-Docs/statuses/{sha}","languages_url":"https://api.github.com/repos/Kagre/VBA-Docs/languages","stargazers_url":"https://api.github.com/repos/Kagre/VBA-Docs/stargazers","contributors_url":"https://api.github.com/repos/Kagre/VBA-Docs/contributors","subscribers_url":"https://api.github.com/repos/Kagre/VBA-Docs/subscribers","subscription_url":"https://api.github.com/repos/Kagre/VBA-Docs/subscription","commits_url":"https://api.github.com/repos/Kagre/VBA-Docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/Kagre/VBA-Docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/Kagre/VBA-Docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/Kagre/VBA-Docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/Kagre/VBA-Docs/contents/{+path}","compare_url":"https://api.github.com/repos/Kagre/VBA-Docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Kagre/VBA-Docs/merges","archive_url":"https://api.github.com/repos/Kagre/VBA-Docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Kagre/VBA-Docs/downloads","issues_url":"https://api.github.com/repos/Kagre/VBA-Docs/issues{/number}","pulls_url":"https://api.github.com/repos/Kagre/VBA-Docs/pulls{/number}","milestones_url":"https://api.github.com/repos/Kagre/VBA-Docs/milestones{/number}","notifications_url":"https://api.github.com/repos/Kagre/VBA-Docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Kagre/VBA-Docs/labels{/name}","releases_url":"https://api.github.com/repos/Kagre/VBA-Docs/releases{/id}","deployments_url":"https://api.github.com/repos/Kagre/VBA-Docs/deployments","created_at":"2018-08-17T20:59:09Z","updated_at":"2018-08-22T04:52:53Z","pushed_at":"2018-08-22T04:52:51Z","git_url":"git://github.com/Kagre/VBA-Docs.git","ssh_url":"git@github.com:Kagre/VBA-Docs.git","clone_url":"https://github.com/Kagre/VBA-Docs.git","svn_url":"https://github.com/Kagre/VBA-Docs","homepage":null,"size":68057,"stargazers_count":0,"watchers_count":0,"language":"PowerShell","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"MicrosoftDocs:master","ref":"master","sha":"54e0a75f224118db0d26fc9363ad519ad35ec788","user":{"login":"MicrosoftDocs","id":22479449,"node_id":"MDEyOk9yZ2FuaXphdGlvbjIyNDc5NDQ5","avatar_url":"https://avatars2.githubusercontent.com/u/22479449?v=4","gravatar_id":"","url":"https://api.github.com/users/MicrosoftDocs","html_url":"https://github.com/MicrosoftDocs","followers_url":"https://api.github.com/users/MicrosoftDocs/followers","following_url":"https://api.github.com/users/MicrosoftDocs/following{/other_user}","gists_url":"https://api.github.com/users/MicrosoftDocs/gists{/gist_id}","starred_url":"https://api.github.com/users/MicrosoftDocs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MicrosoftDocs/subscriptions","organizations_url":"https://api.github.com/users/MicrosoftDocs/orgs","repos_url":"https://api.github.com/users/MicrosoftDocs/repos","events_url":"https://api.github.com/users/MicrosoftDocs/events{/privacy}","received_events_url":"https://api.github.com/users/MicrosoftDocs/received_events","type":"Organization","site_admin":false},"repo":{"id":130898701,"node_id":"MDEwOlJlcG9zaXRvcnkxMzA4OTg3MDE=","name":"VBA-Docs","full_name":"MicrosoftDocs/VBA-Docs","owner":{"login":"MicrosoftDocs","id":22479449,"node_id":"MDEyOk9yZ2FuaXphdGlvbjIyNDc5NDQ5","avatar_url":"https://avatars2.githubusercontent.com/u/22479449?v=4","gravatar_id":"","url":"https://api.github.com/users/MicrosoftDocs","html_url":"https://github.com/MicrosoftDocs","followers_url":"https://api.github.com/users/MicrosoftDocs/followers","following_url":"https://api.github.com/users/MicrosoftDocs/following{/other_user}","gists_url":"https://api.github.com/users/MicrosoftDocs/gists{/gist_id}","starred_url":"https://api.github.com/users/MicrosoftDocs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MicrosoftDocs/subscriptions","organizations_url":"https://api.github.com/users/MicrosoftDocs/orgs","repos_url":"https://api.github.com/users/MicrosoftDocs/repos","events_url":"https://api.github.com/users/MicrosoftDocs/events{/privacy}","received_events_url":"https://api.github.com/users/MicrosoftDocs/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/MicrosoftDocs/VBA-Docs","description":null,"fork":false,"url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs","forks_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/forks","keys_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/teams","hooks_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/hooks","issue_events_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/issues/events{/number}","events_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/events","assignees_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/assignees{/user}","branches_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/branches{/branch}","tags_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/tags","blobs_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/statuses/{sha}","languages_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/languages","stargazers_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/stargazers","contributors_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/contributors","subscribers_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/subscribers","subscription_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/subscription","commits_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/contents/{+path}","compare_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/merges","archive_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/downloads","issues_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/issues{/number}","pulls_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls{/number}","milestones_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/milestones{/number}","notifications_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/labels{/name}","releases_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/releases{/id}","deployments_url":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/deployments","created_at":"2018-04-24T18:39:05Z","updated_at":"2018-08-22T00:58:53Z","pushed_at":"2018-08-22T03:39:49Z","git_url":"git://github.com/MicrosoftDocs/VBA-Docs.git","ssh_url":"git@github.com:MicrosoftDocs/VBA-Docs.git","clone_url":"https://github.com/MicrosoftDocs/VBA-Docs.git","svn_url":"https://github.com/MicrosoftDocs/VBA-Docs","homepage":null,"size":67005,"stargazers_count":2,"watchers_count":2,"language":"PowerShell","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":9,"mirror_url":null,"archived":false,"open_issues_count":13,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":9,"open_issues":13,"watchers":2,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls/51"},"html":{"href":"https://github.com/MicrosoftDocs/VBA-Docs/pull/51"},"issue":{"href":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/issues/51"},"comments":{"href":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/issues/51/comments"},"review_comments":{"href":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls/51/comments"},"review_comment":{"href":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/pulls/51/commits"},"statuses":{"href":"https://api.github.com/repos/MicrosoftDocs/VBA-Docs/statuses/be86adffe9aaed312ff20e6ea37a961a64c38800"}},"author_association":"CONTRIBUTOR","merged":false,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"maintainer_can_modify":true,"commits":10,"additions":2345,"deletions":2199,"changed_files":968}}
{"actor":{"display_login":"Kagre"}}