Practice problems oriented towards dealing with functions, arrays, loops, and conditions.
💻 Use PlayCode to develop online and run the code instantly
You are working for a non profit that is building their own website which lets users login using their email address. All users with an account will have emails that end in .org, and contain @ symbol in the email.
| # Windows *REQUIRES* downloading Perl to run, which you can get using `choco install strawberryperl`. | |
| npx cloc --fullpath --match-f=".tsx|.ts|.js" --not-match-f="node_modules|lib|package-lock.json|/.next|/.vercel" . |
| // Hate seeing this VSCode/TypeScript error with custom attributes? | |
| // Type '{ name: string; value: string; }' is not assignable to type 'DetailedHTMLProps<MetaHTMLAttributes<HTMLMetaElement>, HTMLMetaElement>'. | |
| // Property 'value' does not exist on type 'DetailedHTMLProps<MetaHTMLAttributes<HTMLMetaElement>, HTMLMetaElement>' | |
| // | |
| // Here's a fix to that for all HTML elements in JSX/React. | |
| declare module 'react' { | |
| // Add a custom attribute to *all* HTML elements parsed by TypeScript. | |
| // This is required when the element you want to add the attribute to doesn't | |
| // have it's own attributes type definition (which is most of them). |
| <!-- Past in HTML of page that you want right click of image disabled --> | |
| <script src="http://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha256-3edrmyuQ0w65f8gfBsqowzjJe2iM6n0nKciPUp8y+7E=" crossorigin="anonymous"></script> | |
| <script type="text/javascript"> | |
| $('img').bind('contextmenu', function(e) { | |
| return false; | |
| }); | |
| </script> |
| RewriteEngine On | |
| RewriteCond %{HTTPS} off | |
| # First rewrite to HTTPS: | |
| # Don't put www. here. If it is already there it will be included, if not | |
| # the subsequent rule will catch it. | |
| RewriteRule .* https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] | |
| # Now, rewrite any request to the wrong domain to use www. | |
| # [NC] is a case-insensitive match | |
| RewriteCond %{HTTP_HOST} !^www\. [NC] | |
| RewriteRule .* https://www.%{HTTP_HOST}%{REQUEST_URI} [L,R=301] |
| ' These macros are meant to be used with Manual Calculation to just | |
| ' calculate the selected cells. The verbose macro shows the | |
| ' progress of the calculation by showing what current cell is | |
| ' calculating out of the total number of cells. The verbose macro also | |
| ' displays how long the macro took to finish. | |
| Option Explicit | |
| ' ---------------------------------------------------------------- | |
| ' Procedure Name: CalculateSelection |
| ' ---------------------------------------------------------------- | |
| ' Procedure Name: SheetExists | |
| ' Purpose: Determine whether or not a sheet/tab exists | |
| ' Procedure Kind: Function | |
| ' Procedure Access: Public | |
| ' Return Type: Boolean | |
| ' Author: sb172a | |
| ' Date: 8/10/2018 | |
| ' ---------------------------------------------------------------- | |
| Function SheetExists(SheetName As String, Optional GivenWorkbook As Workbook) As Boolean |
| ' ---------------------------------------------------------------- | |
| ' Procedure Name: AlphaNumericOnly | |
| ' Purpose: Removes non-alpha numeric characters from the given string | |
| ' Procedure Kind: Function | |
| ' Procedure Access: Public | |
| ' Parameter SourceString (String): the string to remove non alpha numeric values from | |
| ' Return Type: String | |
| ' Author: sb172a | |
| ' Date: 8/9/2018 | |
| ' ---------------------------------------------------------------- |
| ' ---------------------------------------------------------------- | |
| ' Procedure Name: TabName | |
| ' Purpose: Returns the current sheet/tab name | |
| ' Procedure Kind: Function | |
| ' Procedure Access: Public | |
| ' Author: sb172a | |
| ' Date: 7/3/2018 | |
| ' ---------------------------------------------------------------- | |
| Function TabName() | |
| TabName = Application.Caller.Worksheet.Name |
| ' When comparing these methods, a few tests were done to test their efficiency... | |
| ' Test 1: one column, 100,000 total text numbers in the column | |
| ' SelectionToNumberInPlace Time: 2.122 seconds | |
| ' SelectionToNumberColumn Time: 4.124 seconds | |
| ' Test 2: one column, 1,048,576 total text numbers in the column | |
| ' SelectionToNumberInPlace Time: 18.1218 seconds | |
| ' SelectionToNumberColumn Time: 15.1213 seconds | |
| ' Test 3: two columns, 2,097,152 total text numbers in the columns | |
| ' SelectionToNumberInPlace Time: 24.1224 seconds | |
| ' SelectionToNumberColumn Time: 31.1231 seconds |
