Find UNIX files in the past day that contains a keyword

Trying to find a file that was modified in the past day that contains a certain keyword…

Here’s the trick:

find -type f -name “<filename search string>” -mtime -1 -exec grep -l “<keyword>” {} \;

Where filename search string is any help you can give it to filter down the file type, such as *.txt or s* and keyword is the phrase you are searching for.

mtime -1 could be modified to be any time frame, such as the past week (mtime -7).

CSS Buttons

I was looking for a GIF image of a + and a X with a box around it.  After some searching, I found an easier way to customize one…use CSS.

Here’s the class code:


.red_button {
background-color: red;
border: none;
color: white;
padding: 2px 2px;
text-align: center;
text-decoration: none;
display: inline-block;
margin: 2px 2px;
cursor: pointer;
font-size: 10px;
width: 20px;
height: 20px;
}

.green_button {
background-color: green;
border: none;
border-radius: 10px;
color: white;
padding: 2px 2px;
text-align: center;
text-decoration: none;
display: inline-block;
margin: 2px 2px;
cursor: pointer;
font-size: 10px;
width: 20px;
height: 20px;
}

The red button is a square and the green one is a circle.

Find WiFi Password

More than a few times now I have had to look up how to find the password for a WiFi network saved on my laptop.  It always takes a while to find a website that accurately/correctly tells the steps.  So, here they are so I can find them again:

  1. Start
  2. Type CMD
  3. Right click on “Command Prompt” an select “Run as Administrator”
  4. To get the names of all saved networks: netsh wlan show profiles
  5. To get the password: netsh wlan show profile name=”name_of_network” key=clear

This will then show the contents of the saved keys, including the password.

Daylight Savings Time Check in Oracle

I needed a way to find if a given date is within a DST date range.  We observe DST here, so I needed to know if I needed to adjust the time or not.  The main purpose was so I could convert a date/time to GMT, which does not observe DST.

First column is current date/time
DST_START is the day DST starts
DST_END is the day DST ends
DST_CHECK will be “Y” if we are currently in DST, “N” if not.
CURRENT_TIME_GMT converts the current time to what it would be in GMT

SELECT SYSDATE,
NEXT_DAY (
TO_DATE (TO_CHAR (SYSDATE, 'YYYY') || '/03/01 02:00 AM',
'YYYY/MM/DD HH:MI AM')
- 1,
'SUN')
+ 7
dst_start,
NEXT_DAY (
TO_DATE (TO_CHAR (SYSDATE, 'YYYY') || '/11/01 02:00 AM',
'YYYY/MM/DD HH:MI AM')
- 1,
'SUN')
dst_end,
CASE
WHEN SYSDATE >=
NEXT_DAY (
TO_DATE (
TO_CHAR (SYSDATE, 'YYYY')
|| '/03/01 02:00 AM',
'YYYY/MM/DD HH:MI AM')
- 1,
'SUN')
+ 7
AND SYSDATE <
NEXT_DAY (
TO_DATE (
TO_CHAR (SYSDATE, 'YYYY') || '/11/01 02:00 AM',
'YYYY/MM/DD HH:MI AM')
- 1,
'SUN')
THEN
'Y'
ELSE
'N'
END
AS dst_check,
NEW_TIME (
SYSDATE,
CASE
WHEN SYSDATE >=
NEXT_DAY (
TO_DATE (
TO_CHAR (SYSDATE, 'YYYY')
|| '/03/01 02:00 AM',
'YYYY/MM/DD HH:MI AM')
- 1,
'SUN')
+ 7
AND SYSDATE <
NEXT_DAY (
TO_DATE (
TO_CHAR (SYSDATE, 'YYYY')
|| '/11/01 02:00 AM',
'YYYY/MM/DD HH:MI AM')
- 1,
'SUN')
THEN
'CDT'
ELSE
'CST'
END,
'GMT')
AS current_time_gmt
FROM DUAL;

To give credit, I used the info from:
https://www.techonthenet.com/oracle/functions/new_time.php
https://stackoverflow.com/questions/287563/in-oracle-how-can-i-detect-the-date-on-which-daylight-savings-time-begins-end

batch remove periods from files

I had a user that had a folder of files that had a lot of .’s in the names.  As an example:
I.like.kayaking.txt
This.is.a.sample.file.txt

They needed all of the .’s replaced with a space.  Here is the contents of the batch file that I created to fix the issue:


@echo off
 setlocal enableextensions disabledelayedexpansion

for %%a in (*) do (
 set "filename=%%~na"
 setlocal enabledelayedexpansion
 for %%f in ("!filename:.= !") do (
 endlocal
 ren "%%~fa" "%%~f%%~xa"
 )
 )

All the user has to do is copy the .bat file into the directory that has the problem files and then run the .bat file.

This is a slightly modified version of the script found at: https://stackoverflow.com/questions/28558996/batch-file-for-replacing-dots-with-spaces-in-file-names

Shell script to concatenate multiple csv files

I had a unix directory with multiple CSV files, all with the same prefix.  I needed them to be concatenated together to make one large file using a shell script.

I used the below code, copied multiple times (one for each file prefix)

Sample files:
file20170804.csv
file20170803.csv
file20170802.csv


new_file=”/dir/file.csv”
if [ -f $new_file ] ; then
rm $new_file
fi

for file in /dir/file?*.csv
do
tail -n +2 “$file” >> $new_file
done


Here is the code with comments:

1 new_file=”/dir/file.csv”
2 if [ -f $new_file ] ; then
3 rm $new_file
4 fi

5 for file in /dir/file?*.csv
6 do
7 tail -n +2 “$file” >> $new_file
8 done

1 – Name of the file you are creating
2 – 4 Check if the file already exists.  If so, then remove it
5 Loop through the smaller files.  Note that I have a ? to make sure that it is not trying to add the big file back to itself.
6-8 Concatenate the file to the $new_file, but ONLY lines 2-end of file.  This omits the header record of the .csv file.