Useful RegEx patterns

Hi Friends,

Today I am not writing something about the SharePoint, but this will be more useful for the client side development. So in many scenarios we need to validate the input string eg valid email address and more.



I have found some of the common used validations which we can validate using the regular expressions. I'll be adding more to these as I encounter more and feel free to let me know if you need any more.



Commonly used Regular Expressions
Title Description Regular Expression
Date Time Format Regular expression will match the dates with dashes or slashes or spaces. eg: dd-mm-yyy or dd/mm/yyy and optional time separated by space or dash eg: dd-mm-yyy-hh:mm:ss /^(0?[1-9]|[12][0-9]|3[01])([ \/\-])(0?[1-9]|1[012])\2([0-9][0-9][0-9][0-9])(([ -])([0-1]?[0-9]|2[0-3]):[0-5]?[0-9]:[0-5]?[0-9])?$/
24 hour time format Regular expression to matches time in 24 hour format /^([01]?[0-9]|2[0-3]):[0-5][0-9]$/
ISO 8601 format for Date and Time Regular expression will match the valid ISO-8601 date and time format /^(?![+-]?\d{4,5}-?(?:\d{2}|W\d{2})T)(?:|(\d{4}|[+-]\d{5})-?(?:|(0\d|1[0-2])(?:|-?([0-2]\d|3[0-1]))|([0-2]\d{2}|3[0-5]\d|36[0-6])|W([0-4]\d|5[0-3])(?:|-?([1-7])))(?:(?!\d)|T(?=\d)))(?:|([01]\d|2[0-4])(?:|:?([0-5]\d)(?:|:?([0-5]\d)(?:|\.(\d{3})))(?:|[zZ]|([+-](?:[01]\d|2[0-4]))(?:|:?([0-5]\d)))))$/
HTML tags Regular expression to match opening and closing HTML tags with content between /^<([a-z1-6]+)([^<]+)*(?:>(.*)<\/\1>| *\/>)$/
Password Regular expression to validate string between 3 and 16 characters, allowing alphanumeric characters and hyphens and underscores /^[a-zA-Z0-9_-]{3,16}$/
Hex Color Value Regular expression to validate the hex color /^#?([a-fA-F0-9]{6}|[a-fA-F0-9]{3})$/
Email Regular expression to verify if there is '@' in the email address mentioned /^.+@.+$/
Source of an image Regular expression which matches the src attribute of an image HTML tag /^<\s*img[^>]+src\s*=\s*(["'])(.*?)\1[^>]*>$/
Positive Integer Regular expression for positive integer /^\d+$/
Negative Integer Regular expression for negative integer /^-\d+$/
Integer Regular expression for integer /^-?\d+$/
Number Regular expression for Integer or float which are positive as well as negative /^-?\d*\.?\d+$/
Positive Number Regular expression for Integer or float which are positive /^-\d*\.?\d+$/
Negative Number Regular expression for Integer or float which are negative /^\d*\.?\d+$/
New Line Regular expression for new line in the text /[\r\n]|$/
CSS Comments Regular expression to match the standard CSS comments /\/\*[^*]*\*+([^\/*][^*]*\*+)*\//


Happy Validating
- Sumit Kanchan

Comments

Post a Comment

Popular posts from this blog

Rename Folder using Microsoft Flow / Power Automate in a Document Library in SharePoint Online

Image
Hi Friends, Today blog is about renaming the folder in the document library using the MS FLOW or MS Power Automate. When I started working on this it seems to be an easy job, but if you look into the connectors you'll find it really difficult as there is no straight forwards connector to do the job. Issues encountered If you try using the " Get Folder Metadata " connector, you'll not be able to get the ID of the folder as it is returning as the negative value. If you get the ID somehow and try to update the folder name using the " Update File Properties " connector, you'll end up renaming only the title of the folder, but it will still have the old name as the display name which in case is again a failure. There is no other connector which can be utilized to achieve the task of renaming the folder in a document library directly. Solution The solution is a simple three-step (at least in this example). Step 1: Initialize variables In case you are computing
Read more

Power Automate: How to Add "New Line" to the text in SharePoint multiline text field

Image
  Q. How to add "New Line", while adding the text to the SharePoint multiline text field?  A . In order to add the new line while adding a text to the multiline SharePoint field, I will demonstrate the simplest approach. Although you can find multiple approaches, but this one seems to be very easy and quick. You need to append the below expression to the text to make it to the new line: decodeUriComponent('%0A') If you are adding any array, then join the array using this expression or if you are building this string, then append this expression to the string. Step 1:  Add a variable and add the below expression (Write the code under the Expression tab) STEP 2: This is how your variable will look like      STEP 3: Output of the Address columns which is of Type Multiline text field Happy Coding..!! #Microsft #SharePointWidgets #PowerAutomate
Read more

Power Automate: Rename file in SharePoint Online

Image
  We often get to change the name of the file, so in this article, I will explain how to rename the file in SharePoint Online using Microsoft Power Automate. Below is the file which I will be renaming. Step 1: Get the file properties We only need to have the SharePoint item id, for which we want to rename the file Step 2: Update the File Name Add the "Send an HTTP request to SharePoint" connector, and update the following properties Method : POST Uri : _api/web/lists/GetByTitle(' <LIBRARY TITLE> ')/items( <ITEM ID> )/ValidateUpdateListItem Body: {     "formValues" :[         {             "FieldName" : "FileLeafRef" ,             "FieldValue" : "<New File Name>"         }     ] } Execute the flow, and the file will be renamed Happy Automating..!! #PowerAutomate #SharePointWidgets #Microsoft
Read more