Posts

PYTHON Knowledge

IMPORT

PIP install method 2

PIP script will be found in C:\pythinxx\Script Make sure you open CMD "Run as Admin", and run the following commands: PIP install modulename

Tool/IDE for python in windows

install  https://wingware.com/

ModuleNotFoundError: No module named 'pyodbc'

Copy commands XCOPY / RoboCopy

xcopy /i /Y "files*.txt" \\server\folder /Y Use this option to stop the xcopy command from prompting you about overwriting files from source that already exist in destination.

How to Compare Two Columns in Excel (for matches & differences)

Image
=A2=B2 =IF(A2=B2,"Match","Mismatch") =IF(EXACT(A2,B2),"Match","Mismatch")

How to insert todays date into excel

=ctrl+ ;