Regex.IsMatch & Regex.Matches- get the Matched words - Matches

Regex.IsMatch   - it will return true or false.

&  Regex.Matches -  get the Matched words - Matches


var filterWords = GetTermsFromSPlist(log, secureUsrPwd);
                    try
                    {
                        string profanePattern = "";
                        bool isFirst = true;
                        filterWords.ToList().ForEach(i =>
                        {
                            if (isFirst)
                            {
                                profanePattern = "\\b" + i + "\\b";
                                isFirst = false;
                            }
                            else
                                profanePattern += "|\\b" + i + "\\b";
                        });
                        //Write Regex method
                        IsBlockedProfanity = Regex.IsMatch(htmltotext, profanePattern, RegexOptions.IgnoreCase);




                       
                        if (IsBlockedProfanity)
                        {
                            var matches = Regex.Matches(htmltotext, profanePattern, RegexOptions.IgnoreCase);
                            string flaggedTermsString1 = string.Empty;
                            if (matches.Count > 0)
                            {
                                foreach (var bWord in matches)
                                {
                                    flaggedTermsString1 += $"{bWord},";
                                }
                            }
}

Read site page contents in Sharepoint using CSOM

In Site Pages library (list type of ListTemplateType.WebPageLibrary) the content for list item depending on the underling the content type could be extracted from:

• WikiField field in case of Wiki Page
• CanvasContent1 field in case of Site Page (aka "modern" page)

Example

var listTitle = "Site Pages";
var list = ctx.Web.Lists.GetByTitle(listTitle);
var items = list.GetItems(CamlQuery.CreateAllItemsQuery());
ctx.Load(items, icol => icol.Include( i => i["WikiField"], i => i["CanvasContent1"], i => i["FileRef"], i => i.ContentType));
ctx.ExecuteQuery();
foreach (var item in items)
{
     Console.WriteLine(">>> {0}", item["FileRef"]);
     switch (item.ContentType.Name)
     {
        case "Site Page":
          Console.WriteLine(item["CanvasContent1"]);
          break;
        case "Wiki Page":
          Console.WriteLine(item["WikiField"]);
          break;

     }    
 }

#region ReadModernPageData
            void ReadingModernPageData()
            {
                bool IsAzureProfanity = false;
                bool IsBlockedProfanity = false;
                using (var postPageCtx = new ClientContext(pageSiteUrl))
                {
                    SecureString secureUsrPwd = new SecureString();
                    foreach (char p in password)
                    {
                        secureUsrPwd.AppendChar(p);
                    }
                    secureUsrPwd.MakeReadOnly();
                    string postBody = string.Empty;
                    TextModerationResults1 demoModeration = new TextModerationResults1();
                    IList<string> returnOutPut = new List<string>();
                    List<string> finalOutPut = new List<string>();
                    byte[] postBodyByteArray;
                    postPageCtx.Credentials = new SharePointOnlineCredentials(userName, secureUsrPwd);
                    var list = postPageCtx.Web.Lists.GetByTitle(pageLibName);
                    var item = list.GetItemById(pageItemID);
                    postPageCtx.Load(item);
                    postPageCtx.ExecuteQuery();
                    var fieldVals = item.FieldValues;

                    var htmltotext = HtmlToNormalizedPlainText(fieldVals["CanvasContent1"].ToString().ToLower());
                    var postPageUrl = pageSiteUrl + "/SitePages/" + fieldVals["FileLeafRef"].ToString();
                    string postTitle = fieldVals["Title"].ToString();
                    log.Info(postPageUrl);
                    //var Author = fieldVals["Author"];
                    FieldUserValue Author = (FieldUserValue)item["Author"];
                    var user = postPageCtx.Web.EnsureUser(Author.LookupValue);
                    // load the data with the context               
                    postPageCtx.Load(user);
                    postPageCtx.ExecuteQuery();
                    var createdBy = user.Email; //+ ";" + hubManagersEmail;

                    var filterWords = GetTermsFromSPlist(log, secureUsrPwd);
                    try
                    {
                        string profanePattern = "";
                        bool isFirst = true;
                        filterWords.ToList().ForEach(i =>
                        {
                            if (isFirst)
                            {
                                profanePattern = "\\b" + i + "\\b";
                                isFirst = false;
                            }
                            else
                                profanePattern += "|\\b" + i + "\\b";
                        });
                        //Write Regex method
                        IsBlockedProfanity = Regex.IsMatch(htmltotext, profanePattern, RegexOptions.IgnoreCase);
                        if (IsBlockedProfanity)
                        {
                            ClientContext invReportCtx = GetSiteContext(inv_SiteUrl, userName, secureUsrPwd);
                            //AddToReportedContent(invReportCtx, inv_ReportedContentLstNm, pageSiteUrl, postPageUrl, "Blocked Words Found", "ARContent", "inProgress");
                            //Send email via exchange server
                            // var isSentEmail = SendMail(userName, password, createdBy, postTitle, "Blocked Words Profanity Found & Terms are :", postPageUrl);
                            var isSentEmail=SendMailViaCtx(postPageCtx, userName, password, createdBy,hubManagersEmail, "Warning! | Blocked Words Found in post | " + postTitle, "Blocked Words Profanity Found & Terms are :", postPageUrl);
                           
                        }
                    }

                    catch (Exception)
                    {
                        log.Info("Error while checking profanity using RegEx");
                    }


                    if (htmltotext.Length <= 1024)
                    {
                        postBody = htmltotext;
                        postBodyByteArray = Encoding.UTF8.GetBytes(postBody);
                        postBodyMemoryStream = new MemoryStream(postBodyByteArray);
                        returnOutPut.Clear();
                        (demoModeration, returnOutPut, IsAzureProfanity) = TextContentModeration1.CheckContentForModeration(postBodyMemoryStream, log);
                        if (IsAzureProfanity)
                        {
                            IsAzureProfanityFinal = true;
                        }
                        finalOutPut.AddRange(returnOutPut.Distinct());
                    }
                    else
                    {
                        char[] delimiters = new char[] { ',', ';', '.' };
                        string[] splittedSentence = htmltotext.Split(delimiters, StringSplitOptions.RemoveEmptyEntries);
                        string normalizedText1024Char = string.Empty;
                        int screenTextLength = 0;
                        int splittedSentenceIndexCounter = 0;
                        foreach (string sentence in splittedSentence)
                        {
                            splittedSentenceIndexCounter++;
                            screenTextLength = normalizedText1024Char.Length + sentence.Length;
                            if (screenTextLength <= 1024)
                            {
                                normalizedText1024Char += sentence;
                                if (splittedSentenceIndexCounter == splittedSentence.Length)
                                {
                                    postBody = normalizedText1024Char;
                                    postBodyByteArray = Encoding.UTF8.GetBytes(postBody);
                                    postBodyMemoryStream = new MemoryStream(postBodyByteArray);
                                    returnOutPut.Clear();
                                    (demoModeration, returnOutPut, IsAzureProfanity) = TextContentModeration1.CheckContentForModeration(postBodyMemoryStream, log);
                                    if (IsAzureProfanity)
                                    {
                                        IsAzureProfanityFinal = true;
                                    }
                                    finalOutPut.AddRange(returnOutPut.Distinct());
                                }
                            }
                            else
                            {
                                postBody = normalizedText1024Char;
                                postBodyByteArray = Encoding.UTF8.GetBytes(postBody);
                                postBodyMemoryStream = new MemoryStream(postBodyByteArray);
                                returnOutPut.Clear();
                                (demoModeration, returnOutPut, IsAzureProfanity) = TextContentModeration1.CheckContentForModeration(postBodyMemoryStream, log);
                                if (IsAzureProfanity)
                                {
                                    IsAzureProfanityFinal = true;
                                }
                                finalOutPut.AddRange(returnOutPut.Distinct());
                                screenTextLength = 0;
                                normalizedText1024Char = string.Empty;
                                screenTextLength = sentence.Length;
                                normalizedText1024Char = sentence;
                                // very few scenarios - last sentence will validate in below code
                                if (splittedSentenceIndexCounter == splittedSentence.Length)
                                {
                                    postBody = normalizedText1024Char;
                                    postBodyByteArray = Encoding.UTF8.GetBytes(postBody);
                                    postBodyMemoryStream = new MemoryStream(postBodyByteArray);
                                    returnOutPut.Clear();
                                    (demoModeration, returnOutPut, IsAzureProfanity) = TextContentModeration1.CheckContentForModeration(postBodyMemoryStream, log);
                                    if (IsAzureProfanity)
                                    {
                                        IsAzureProfanityFinal = true;
                                    }
                                    finalOutPut.AddRange(returnOutPut.Distinct());
                                }
                            }
                        }
                    }
                    // add to Inv_RequestContent list
                    string flaggedTermsString = string.Empty;

                    foreach (var distinctITem in finalOutPut.Distinct())
                    {
                        flaggedTermsString += $"{distinctITem},";
                    }

                    log.Info(finalOutPut.Distinct().Count().ToString());

                    if (finalOutPut.Distinct().Count() > 0)
                    {
                        //Update List Item:
                        ClientContext invReportCtx = GetSiteContext(inv_SiteUrl, userName, secureUsrPwd);
                        AddToReportedContent(invReportCtx, inv_ReportedContentLstNm, pageSiteUrl, postPageUrl, "Azure Profanity & Terms are :" + flaggedTermsString, "ARContent", "inProgress");

                        //Send email via exchange server
                        var isSentEmail = SendMailViaCtx(postPageCtx, userName, password, createdBy,hubManagersEmail, "Profanity Alert! Azure Profanity found in Post ! "+postTitle, "Azure Profanity & Terms are :" + flaggedTermsString, postPageUrl);

                    }
                    else
                    {
                        log.Info("Page doesn't have data");
                    }

                }
                #endregion

Azure CLI

Azure CLI

Featured snippet from the web

The Azure CLI is a command-line tool

providing a great experience for managing Azure resources. The CLI is designed to make scripting easy, query data, support long-running operations, and more. 

 The current version of the Azure CLI is 2.0.70

Install Azure CLI on Windows

https://docs.microsoft.com/en-us/cli/azure/install-azure-cli-windows?view=azure-cli-latest

https://aka.ms/installazurecliwindows

Invoke-WebRequest -Uri https://aka.ms/installazurecliwindows -OutFile .\AzureCLI.msi; Start-Process msiexec.exe -Wait -ArgumentList '/I AzureCLI.msi /quiet'

STEP 1 : Install the Azure CLI

https://docs.microsoft.com/en-us/cli/azure/install-azure-cli-windows?view=azure-cli-latest

OR You can also install the Azure CLI using PowerShell. Start PowerShell as administrator and run the following command

Invoke-WebRequest -Uri https://aka.ms/installazurecliwindows -OutFile .\AzureCLI.msi; Start-Process msiexec.exe -Wait -ArgumentList '/I AzureCLI.msi /quiet'

Restart the Powershell

 Note : To use below  command, you must use Azure CLI version 2.0.21 or later. To see what Azure CLI version you are using, use the az --version command.

STEP 2: -   Download your function app files

Login in chrome browser to portal.azure.com

And then copy paste below Url by replacing function_app name.

https://<function_app>.scm.azurewebsites.net/api/zip/site/wwwroot/

Step 3: -

In the following command, replace the <zip_file_path> placeholder with the path to the location of your .zip file. Also, replace <app_name> with the unique name of your function app.

az functionapp deployment source config-zip  -g myResourceGroup -n \ <app_name> --src <zip_file_path>

To get all commands of Azure CLI

Visit  https://aka.ms/cli

Optimize the performance and reliability of Azure Function

https://docs.microsoft.com/en-us/azure/azure-functions/functions-best-practices

https://docs.microsoft.com/en-us/cli/azure/install-azure-cli-windows?view=azure-cli-latest#code-try-1

Getting the Page URL of a File in CSOM If title & Name was different in Site Pages Library

postPageCtx.Credentials = new SharePointOnlineCredentials(un, securePwd);

var list = postPageCtx.Web.Lists.GetByTitle(pageLibName);

var item = list.GetItemById(pageItemID);

postPageCtx.Load(item);

postPageCtx.ExecuteQuery();

var fieldVals = item.FieldValues;

var postPageUrl = pageSiteUrl + "/SitePages/" + fieldVals["FileLeafRef"].ToString();

LIST OF INTERNAL NAMES FOR SHAREPOINT FIELDS

In order to reference a column or field using the SharePoint object model, you often need to know its internal name. For example, when creating a CAML query, you can specify the field on which to search by providing its internal name. As opposed to the display name, which can be changed in the UI, the internal name is immutable. While the default display name and the internal name are often identical or similar, they can also be very different. The difference isn’t always consistent. For example, spaces in the display name can be removed, such as IsCheckedoutToLocal, or replaced with the hexadecimal equivalent, such as HTML_x0020_File_x0020_Type. Furthermore, the display name can be the same for more than one fields, so the internal name is the only way to distinguish between them.

You can quickly determine the internal name of a field using the UI:

1. Open the List Settings page
2. Under the Columns section, select a column to view the Edit Column page
3. The URL of this page includes the internal name in the query string. For example, the URL for the Created By field includes the following query string List=%7BF641CEF1%2DCDE2%2D49E1%2D9800%2D861A408EF890%7D&Field=Author. The value for the Field parameter, Author, is the internal name for Created By.

However, this approach isn’t always convenient. If the column you want doesn’t already belong to the list, you’d have to first add it.

For reference purpose, below is the list of the display name and corresponding internal name for the default fields of a Document Library.

TITLE	INTERNAL NAME
Approval Status	_ModerationStatus
Approver Comments	_ModerationComments
Check In Comment	_CheckinComment
Checked Out To	CheckoutUser
Checked Out To	CheckedOutTitle
Checked Out To	LinkCheckedOutTitle
Content Type	ContentType
Content Type ID	ContentTypeId
Copy Source	_CopySource
Created	Created
Created	Created_x0020_Date
Created By	Author
Document Created By	Created_x0020_By
Document Modified By	Modified_x0020_By
Edit	Edit
Edit Menu Table End	_EditMenuTableEnd
Edit Menu Table Start	_EditMenuTableStart
Effective Permissions Mask	PermMask
Encoded Absolute URL	EncodedAbsUrl
File Size	File_x0020_Size
File Size	FileSizeDisplay
File Type	File_x0020_Type
GUID	GUID
Has Copy Destinations	_HasCopyDestinations
Html File Link	xd_ProgID
HTML File Type	HTML_x0020_File_x0020_Type
ID	ID
ID of the User who has the item Checked Out	CheckedOutUserId
Instance ID	InstanceID
Is Checked out to local	IsCheckedoutToLocal
Is Current Version	_IsCurrentVersion
Is Signed	xd_Signature
Item Type	FSObjType
Level	_Level
Merge	Combine
Modified	Modified
Modified	Last_x0020_Modified
Modified By	Editor
Name	FileLeafRef
Name	LinkFilenameNoMenu
Name	LinkFilename
Name	BaseName
Order	Order
owshiddenversion	owshiddenversion
Path	FileDirRef
ProgId	ProgId
Property Bag	MetaInfo
Relink	RepairDocument
ScopeId	ScopeId
Select	SelectTitle
Select	SelectFilename
Server Relative URL	ServerUrl
Shared File Index	_SharedFileIndex
Source Name (Converted Document)	ParentLeafName
Source Url	_SourceUrl
Source Version (Converted Document)	ParentVersionString
Template Link	TemplateUrl
Title	Title
Type	DocIcon
UI Version	_UIVersion
Unique Id	UniqueId
URL Path	FileRef
Version	_UIVersionString
Virus Status	VirusStatus
Workflow Instance ID	WorkflowInstanceID
Workflow Version	WorkflowVersion

In my case, I’m interested in the Name field. I wouldn’t have guessed that it would be mapped to FileLeafRef.

Referenced Link : 

https://blog.softartisans.com/2009/12/08/list-of-internal-names-for-sharepoint-fields/

My code for CSOM as given Below.

postPageCtx.Credentials = new SharePointOnlineCredentials(userName, secureUsrPwd);

                    var list = postPageCtx.Web.Lists.GetByTitle(pageLibName);

                    var item = list.GetItemById(pageItemID);

                    postPageCtx.Load(item);

                    postPageCtx.ExecuteQuery();

                    var fieldVals = item.FieldValues;

var postPageUrl = pageSiteUrl + "/SitePages/" + fieldVals["FileLeafRef"].ToString();