awk - Exclude or Include Records from a fixed-width file

The below command gets the records that have a value "new" in the given position (in this case the file was fixed-width). All other records which do not have the value "new" are ignored.

 awk '{if (substr($0, 7, 3) == "new") print $0}' file1.txt

substr 7, 3 is the starting position 7 with 3 characters

sed - Add a line to all files

#below inserts a line at 1st row with the content "Added new line using sed " in all the files in the path

for i in *; do sed -i '1s/^/Added new line using sed \n/' $i; done

#below inserts a line at 3rd row with the content "Added new line using sed " in all the files in the path

for i in *; do sed -i '3s/^/Added new line using sed \n/' $i; done

DBeaver Not Responding in macOS

Not quite often but sometimes when either DBeaver or your macOS decides to frustrate you (particularly when you are already frustrated with the work 😉) then you will see DBeaver not starting up with just a spinning rainbow wheel forever. 

In The Activity Monitor, it says DBeaver not responding!!!

Force Quit DBeaver and navigate to this folder:

/Users/schanna/Library/DBeaverData/workspace6/.metadata/.plugins/org.eclipse.e4.workbench

and remove the file: workbench.xmi 

schanna@schanna org.eclipse.e4.workbench % rm workbench.xmi 

Now, you should be back to business.