Showing posts from May, 2020

Powershell to find Text in PDF and Word

In continuation to my previous article on PowerShell to find hyperlink texts in ppt , here I am going to show how to find hyperlinks in Word or PDF files. Sample code below, tweak it for your purpose and drop me a comment if you need help. $FilePath= "C:\Users\xxx\"  $OurDocuments = Get-ChildItem -Path "$FilePath" -Filter "*.pdf" -Recurse #change to .doc* for word $Word = New-Object -ComObject word.application $Word.Visible = $false $i = 0 $OurDocuments | ForEach-Object { try {     $Document = $Word.Documents.Open($_.FullName,$false,$true)      #"Processing file: {0}" -f $Document.FullName          try{     $Document.Hyperlinks | ForEach-Object {         if ($_.Address -like "*" -or $_.Text -like "*")          {                 "Found issues {0} `r`n" -f $Document.Fullname                  "Found issues {0} `r`n" -f $_.Address                 "Found issues {0} `r`n&q

PowerShell to find HyperLink Text in PowerPoint

Recently I faced a scenario where I needed to find if a particular url is used in hyperlink in 100s of ppt. Opening ppt and looking for the ppt is cumbersome,  so wrote a small PowerShell to find the url. Here is the PowerShell Script code Click here to view article on powershell to find hyerlink text in word or pdf $FilePath= "C:\Users\xxx\Path" Add-Type -AssemblyName Office $ppt = New-Object -ComObject powerpoint.Application $DocumentsLib = Get-ChildItem -Path "$FilePath" -Filter "*.ppt*" -Recurse $Doc = New-Object -ComObject powerpoint.Application $i=0 $DocumentsLib | ForEach-Object { Write-Host $_.FullName $Doc = $ppt.Presentations.Open($_.FullName,$Null,$Null,[Microsoft.Office.Core.MsoTriState]::msoFalse) $Slides = $Doc.Slides Foreach ($Slide in $Slides) {     $Slide.Hyperlinks | ForEach-Object {                 if ($_.Address -like "*texttofind*" -or $_.Text -like "texttofind*")          {            write-host $_.Address        

Drop Database in Oracle

Steps to drop a container database in oracle Step 1 : Connect to the database as sysdba bash#$ sqlplus / as sysdba Step 2 : Shutdown the database SQL> shutdown immediate; Step 3 : Start mount the database with exclusive restrict to avoid the database being opened SQL> startup mount exclusive restrict; Step 4 : Drop database SQL> drop database;

Getting Started with MariaDB

In our previous post, we demonstrated steps to install MariaDB Server on Ubuntu , in this article, we are going to show how to create database in MySQL/MariaDB. We are going to talk about DDL(Data Definition Language), how to create tables and authorize users to access them. Start your mariadb-server and follow the steps Creating Databases, Tables, and Authorized Users Step 1: Connect to your mariadb-server and run below sql. This can be done via mysql client or any other tools like Heidisql, phpmyadmin etc. This is going to create a new database in your server.  CREATE DATABASE myFirstDB; Check if the database already exists and create CREATE DATABASE IF NOT EXISTS myFirstDB; To list all the databases in a server. SHOW DATABASES; To connect to your database USE DATABASE_NAME; Once you have selected your database, use following to create user CREATE USER 'username'@'localhost' IDENTIFIED BY 'user_password'; To create a user that can connect fro