{"id":9454,"date":"2021-10-28T10:28:02","date_gmt":"2021-10-28T09:28:02","guid":{"rendered":"https:\/\/support.overnetdata.com\/?post_type=ht_kb&p=9454"},"modified":"2022-09-23T13:02:53","modified_gmt":"2022-09-23T12:02:53","slug":"how-do-i-use-regex-with-edulink-one","status":"publish","type":"ht_kb","link":"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/","title":{"rendered":"How Do I Use RegEx with Edulink One?"},"content":{"rendered":"\n

Edulink One has some functions that are compatible with RegEx to help narrow down the patterns of your search. <\/p>\n\n\n\n

RegEx stands for Regular Expression. It is a powerful tool you can use to make matches when searching in certain fields within Edulink One, such as the Load User Accounts<\/strong> table in the Login tab<\/a> and the Exclude Documents by Summary<\/strong> function within the Documents tab<\/a>. It is a programming language ( Python, Java, Javascript) that follows syntax to help the computer search for what you are looking for within specific patterns of text. <\/p>\n\n\n\n

\"Documents<\/figure>\n\n\n\n

RegEx is character-based rather than word-based, but it is heavily related to grammar. Each individual character or operation that is used has a meaning and purpose. There are literal characters (literally the individual character you are typing, e.g. A) and special characters that have a specific meaning. <\/p>\n\n\n\n

Literal Characters<\/h2>\n\n\n\n

You can search for simple characters using RegEx: abcdefg, 123456 and so on. For example, if you search for the characters Year, RegEx will search for the character Y followed by ear respectively. RegEx will look for this exact combination of letters and is case sensitive. If you search for Year 9 RegEx will look for Y followed by ear, then a white space (\\s) and then number 9 in this exact order. <\/p>\n\n\n\n

One way you can use literal characters to search is by using the letter N (code is not case sensitive here) and it will bring up a list of employees, parents and learners that have never logged in. You can write the whole word ‘Never’ but the character ‘N’ works as well. <\/p>\n\n\n\n

\"N<\/figure>\n\n\n\n

Special Characters within Literal Characters<\/h2>\n\n\n\n

Within the literal characters category, there are special characters with specific meanings. Normally, if you have used any of these characters, you will need to ‘escape’ them so the computer reads them as literal and not the special meaning. <\/p>\n\n\n\n

Character<\/strong><\/td>Meaning<\/strong><\/td><\/tr>
.<\/td>The full stop means to search for all characters, but not newline spaces.<\/td><\/tr>
\\<\/td>The backslash is very important because it allows you to ‘escape’ the special meaning of the characters. If you want a full stop to read as a full stop to the computer, you need to include the backslash before the full stop to cancel out the special meaning, e.g. \\. . This will allow the computer to read your full stop as literal.

\"Regular<\/td><\/tr>
\\\\<\/td>Much like any special character, if you want a backslash to read as a backslash you must include the ‘escape’ before it \\\\.<\/td><\/tr>
\\d<\/td>Means a digit (0-9) and will search for any digit in your text.<\/td><\/tr>
\\D<\/td>Not a digit (0-9) and will look for any other character include letters, spaces and special characters.<\/td><\/tr>
\\w<\/td>Word character (a-z, A-Z, 0-9, _) will look for letters, digits and underscores.<\/td><\/tr>
\\W<\/td>Anything that is not a word character, mostly special characters and spaces.<\/td><\/tr>
\\s<\/td>Whitespace (spaces, tab, newline).<\/td><\/tr>
\\S<\/td>Anything that is not a white space.<\/td><\/tr>
@<\/td>Searches for email addresses (useful in our Login Tab in the Load Accounts table\u2014 just type @ in the Email<\/strong> field).

\"@<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Anchors<\/h2>\n\n\n\n

Anchors are characters that help map out positions before or after new characters. This is helpful if you are searching for the start or end of something. <\/p>\n\n\n\n

Character <\/strong><\/td>Meaning<\/strong><\/td><\/tr>
\\b<\/td>A word boundary. This will literally search for the beginning of a line, e.g. \\b Reports will search for any line beginning with the characters Reports (remember it looks for each individual letter and not the word as a whole; it is also case sensitive). If you type in \\b reports\\b it will look for reports at the beginning and end of a line.<\/td><\/tr>
\\B<\/td>Searches for characters at the end of a line only. If you type in \\B Year 9 Reports, the computer will only look for the characters for Year 9 Reports at the end of a line.<\/td><\/tr>
!<\/td>Negates a search, meaning it will look for something that is not there. In Load User Accounts<\/strong> in Login, one of the useful regular expressions you can use is !@ which will search for any person without an email. If you type this in the Email <\/strong>field, it will then bring up a list of all employees, learners and parents without an email address.

\"No
!, will filter out parents with more than one child in the Children column.

\"\"<\/td><\/tr>
^<\/td>Looks for the beginning of a string (line) (similar to \\b).<\/td><\/tr>
$<\/td>Looks for the end of a string(line) (similar to \\B).<\/td><\/tr>
|<\/td>Using a pipe means you are looking for a particular thing |(or) another thing, e.g. Year 11 Mock Results|UCAS. This looks for Year 11 Mock Results or UCAS. In our Exclude Documents by Summary<\/strong> function in the Documents Tab<\/a>, you can exclude documents from being visible to parents and learners by using RegEx like the example above. This would hide Year 11 Mock Results and UCAS documents from these groups until you are ready.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Metacharacters<\/h2>\n\n\n\n

Metacharacters are made up of literal characters, special characters (part of literal characters) and character sets. A character set is made with an open square bracket [ and a closed square bracket ]. If you have used these characters when you have created documents, you will need to escape them \\ if you want them to read as a square bracket. <\/p>\n\n\n\n

The square brackets are useful because it narrows down what you are searching for and protects it\u2014 only looking for the characters within it. <\/p>\n\n\n\n

For example, 08[00|08]\\s\\d\\d\\d\\d\\d\\d\\d\\ will look for 0800 or 0808 numbers (though this is probably a bit too long and complex for practical use). Another example is if you type in ^.* Year ([8-9]) meaning the computer will look for all Year 8 and Year 9 students. <\/p>\n\n\n\n

Character<\/strong><\/td>Meaning<\/strong><\/td><\/tr>
[1-9]<\/td>Specifies a range of numbers between 1 and 9.<\/td><\/tr>
[a-z]<\/td>Specifies a lowercase character set.<\/td><\/tr>
[A-Z]<\/td>Specifies an uppercase character set.<\/td><\/tr>
[a-z A-Z]<\/td>Specifies the whole alphabet with all cases.<\/td><\/tr>
[^]<\/td>If you use a caret ^ within<\/em> the square brackets, it acts as a negator; for example [^a-z] matches everything BUT lowercase characters.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Quantifiers<\/h2>\n\n\n\n

Quantifier characters in RegEx tell the computer the number of something to look for. <\/p>\n\n\n\n

Character<\/strong><\/td>Meaning<\/strong><\/td><\/tr>
*<\/td>0 or more<\/td><\/tr>
+<\/td>1 or more<\/td><\/tr>
?<\/td>0 or 1. This character essentially lets you search for options.<\/td><\/tr>
{ }<\/td>Exactly this number. The curved brackets with a number inside, e.g. {8} looks for exactly for 8 of something.<\/td><\/tr>
{ , }<\/td>Min and Max. For example, if you write {3,6} you are looking for a minimum of 3 and a maximum of 6 of something.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Most of the time you will need to escape quantifiers in Edulink One if you include them in your text. If you need to escape a quantifier in a document title, simply add a backslash \\ before the quantifier. <\/p>\n\n\n\n

An example of where it might be useful is if you are looking for a title and names such as Mr, Mr., Mrs, Mrs., Ms, Miss, Msr etc… This can be using brackets to help group the different options you can search for, allowing the computer to match them all. <\/p>\n\n\n\n

E.g.<\/p>\n\n\n\n

M(r|s|rs|iss|rs)\\.?\\s[A-Z]\\w* <\/p>\n\n\n\n

This expression searches for the title of the person, with or without a full stop \\.?, a space \\s and then a capital letter and any other character \\w (letters) with 0 or more letters *. <\/p>\n\n\n\n

This is a basic outline of regular expressions and how we might use them in Edulink One. Most of the time you will likely be searching for basic things like email @, no email !@, or Year groups ^.* Year([7-13]). You might also be using the pipe to separate documents you wish to exclude Year 8 Autumn Reports | Year 11 A2L Autumn or the backslash \\ to escape special characters. <\/p>\n\n\n\n

This guide is giving you a bit more information and an overview of how regular expressions work. For more information, there are articles and tutorials online to help you further. <\/p>\n","protected":false},"excerpt":{"rendered":"

Edulink One has some functions that are compatible with RegEx to help narrow down the patterns of your search. RegEx stands for Regular Expression. It is a powerful tool you can use to make matches when searching in certain fields within Edulink One, such as the Load User Accounts table…<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"ht-kb-category":[337,35],"ht-kb-tag":[163,398,75,391],"acf":[],"yoast_head":"\nHow Do I Use RegEx with Edulink One? - Edulink One Knowledge Hub - Overnet Data Support<\/title>\n<meta name=\"description\" content=\"Learn a bit more about basic RegEx, what certain characters and expressions mean and how you might use them in Edulink One.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Use RegEx with Edulink One? - Edulink One Knowledge Hub - Overnet Data Support\" \/>\n<meta property=\"og:description\" content=\"Learn a bit more about basic RegEx, what certain characters and expressions mean and how you might use them in Edulink One.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/\" \/>\n<meta property=\"og:site_name\" content=\"Edulink One Knowledge Hub - Overnet Data Support\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-23T12:02:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/support.overnetdata.com\/wp-content\/uploads\/2021\/10\/documents-icon-1-1024x178.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/\",\"url\":\"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/\",\"name\":\"How Do I Use RegEx with Edulink One? - Edulink One Knowledge Hub - Overnet Data Support\",\"isPartOf\":{\"@id\":\"https:\/\/support.overnetdata.com\/#website\"},\"datePublished\":\"2021-10-28T09:28:02+00:00\",\"dateModified\":\"2022-09-23T12:02:53+00:00\",\"description\":\"Learn a bit more about basic RegEx, what certain characters and expressions mean and how you might use them in Edulink One.\",\"breadcrumb\":{\"@id\":\"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.overnetdata.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Use RegEx with Edulink One?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/support.overnetdata.com\/#website\",\"url\":\"https:\/\/support.overnetdata.com\/\",\"name\":\"Edulink One Knowledge Hub - Overnet Data Support\",\"description\":\"Online user guide for Edulink One from Overnet Data's Support Team\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.overnetdata.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Use RegEx with Edulink One? - Edulink One Knowledge Hub - Overnet Data Support","description":"Learn a bit more about basic RegEx, what certain characters and expressions mean and how you might use them in Edulink One.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/","og_locale":"en_GB","og_type":"article","og_title":"How Do I Use RegEx with Edulink One? - Edulink One Knowledge Hub - Overnet Data Support","og_description":"Learn a bit more about basic RegEx, what certain characters and expressions mean and how you might use them in Edulink One.","og_url":"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/","og_site_name":"Edulink One Knowledge Hub - Overnet Data Support","article_modified_time":"2022-09-23T12:02:53+00:00","og_image":[{"url":"https:\/\/support.overnetdata.com\/wp-content\/uploads\/2021\/10\/documents-icon-1-1024x178.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/","url":"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/","name":"How Do I Use RegEx with Edulink One? - Edulink One Knowledge Hub - Overnet Data Support","isPartOf":{"@id":"https:\/\/support.overnetdata.com\/#website"},"datePublished":"2021-10-28T09:28:02+00:00","dateModified":"2022-09-23T12:02:53+00:00","description":"Learn a bit more about basic RegEx, what certain characters and expressions mean and how you might use them in Edulink One.","breadcrumb":{"@id":"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/support.overnetdata.com\/knowledge-base\/how-do-i-use-regex-with-edulink-one\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.overnetdata.com\/"},{"@type":"ListItem","position":2,"name":"How Do I Use RegEx with Edulink One?"}]},{"@type":"WebSite","@id":"https:\/\/support.overnetdata.com\/#website","url":"https:\/\/support.overnetdata.com\/","name":"Edulink One Knowledge Hub - Overnet Data Support","description":"Online user guide for Edulink One from Overnet Data's Support Team","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.overnetdata.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/ht-kb\/9454"}],"collection":[{"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/comments?post=9454"}],"version-history":[{"count":59,"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/ht-kb\/9454\/revisions"}],"predecessor-version":[{"id":15667,"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/ht-kb\/9454\/revisions\/15667"}],"wp:attachment":[{"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/media?parent=9454"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/ht-kb-category?post=9454"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.overnetdata.com\/wp-json\/wp\/v2\/ht-kb-tag?post=9454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}