function
13 TopicsMake Share function in Edge more useful
posting from latest available Edge Version 82.0.418.0 (Official build) canary (64-bit) the Share looks like this so it expects user to have the UWP apps installed. there are problems with that: UWP is not available on all platforms. on Windows 8.1, on Mac, and soon on Linux. also some popular apps like Instagram, their UWP version haven't been updated in ages. Facebook app is also old. also my installed app list in Edge (PWAs) look like this: You see, I've added my favorite social network websites as apps in Edge, PWAs are better, they do not require installation and experience is the same in all platforms. so now when I want to share something on Twitter, Facebook, Reddit etc, I have to use the method that I've been using since 15 years ago. the old copy paste method. because the Share functionality is totally useless at the current state. my suggestion: make Share functionality in Edge to detect the installed PWA apps, websites added as an app, and then offer them on the Share window as options. when I have Twitter added as PWA in Edge, I obviously don't want it double on my system by installing the UWP version. the same applies to the rest of the social networks.Solved4.4KViews9likes13CommentsStruggling with Rich Text Field
Hello Community, I have a SQL table which has a column containing rich text field tags. I am trying for 2 days now to get rid of the tags but nothing is working for me. <div class="ExternalClass00D082CB77D043AC975C783B3BC9B418">PR approval process complete, currently with procurement. EU to provide the Scope and SSJ. Else Procurement with reject the PR.</div> Below is how the text appears while in the actual website, the data appears like this: The removal process cannot be hard-coded because every record tags are different from another. For example see the below example: <div class="ExternalClass156752DF6D8A4BBF84D75235021E4A45">Demand status updated to Under Tech. Procurement - Pending PR Creation <div class="ExternalClass1A849FEC18A44CCE90E425ED0F54A1A2"><html> <p>One time Support Request.<br></p></html></div> </div> *I have attached the actual output of this from website If anyone can help me on how to clean the characters with a SQL function or maybe a C# code that will be very helpful. I have tried the below links and they do not solve my problem. https://www.codeproject.com/Tips/821281/Convert-RTF-to-Plain-Text-Revised-Again https://social.msdn.microsoft.com/Forums/en-US/143abeb5-f98a-4b47-a746-dd141bdd6df7/sql-query-to-retrieve-a-rich-text-memo-field?forum=sqlgetstarted Any help on this issue will be very much appreciated.1.8KViews0likes0CommentsFinding the data and to color code it
Hi, I have a excel where i need to find data from Crtl+F and I have to color code that cell in green. i have to manually search that data and do the process. How i can do in one go? Please reply with any of your thoughts. It might be helpful for me.1.4KViews0likes3CommentsCalculated column help
=IF([Chemical Name]="Dioxane","Yes",IF([Chemical Name]="Tetrahydrofuran","Yes",IF([Chemical Name]="2-Propanol","Yes",""))) Is there an easier way to write the function above? I have a list of 20 chemicals that I would like this column to "search for" and show a "Yes" if it finds a match to [Chemical Name].1.3KViews0likes1CommentHistorical Backups of $Profile
Just curious if/how anyone else out there stores backups of their $Profile for POSH/ISE. After losing a few modifications a while back, I created and Backup-Profile function to copy my live $Profile into my OneDrive. Wasn't sure if anyone else had anything more elegant - but here is what I have shoved at the bottom of my $Profile. It provides a historical backup every time I open ISE. I have it set to 100 historical copies - you can obviously tweak it to suit your needs - While 100 copies may be excessive, I have enough things in my profile that I may not use certain things for a long time. Function Backup-Profile { #region Varibles $BackupPath = 'C:\users\<username>\OneDrive\PowerShell\__Profile\'; $HistoricalCount = 100 #endregion Variables #Ensure our BackupPath is a folder that exists. New-Item $BackupPath ` -ItemType Directory ` -Force ` -ErrorAction SilentlyContinue ; $StorageLocation = $BackupPath; $basename = (Get-Item $profile).baseName $files = ($HistoricalCount..1); #Remove 100 [String]$currentCopy = $basename + ".$HistoricalCount"; Remove-Item $StorageLocation\$currentCopy.ps1 -Force ; foreach ($file in $files) { if ($file -eq $HistoricalCount) { #Skip the 100 entry } ELSE { #Move the nth entry to the nth+1 file name #EX Backup 99 now becomes backup 100. # Backup 98 now becomes backup 99. # Backup 97 now becomes backup 98. # Store the 'destination' numbering $newitem = $file + 1 # Move the current file to the destination number Move-Item "$StorageLocation\$basename.$file.ps1" ` -Destination "$StorageLocation\$basename.$newitem.ps1" } } # Move the most recent backup to the .1 backup Move-Item $StorageLocation\$basename.ps1 $StorageLocation\$basename.1.ps1 # Finally copy the current profile to the newest backup. Copy $profile $StorageLocation } # Now Run our actual backup Backup-Profile1.1KViews0likes0CommentsWhich formula to use
Hello, I am looking for a formula but I don't know which one to use. What I would like to do is that when in collum material is entered 1804 that it multiplies the collum quantity with 34,3. And the result is shown in collum plan(hours). But if in collum material is entered 1800 that then it is multiplied with 17,2 and collum quantity and result again is shown in collum plan(hours). File is in the attatchment. Can anyone tell me which formula would work for this? Below my file: Shift Ordernumber line Material Quantity Plan(hours) Reality(hours) Operator Comments 1 1992620 10 1804 100 RH 1 1992621 20 1800 0 2 156461 20 1800 100 time per second 1804 34.3 1800 17.2Solved1.1KViews0likes2Comments