Strip trailing whitespaces from string [Python]


If you want to remove extra whitespaces from start and end of a string, use strip() method in Python. strip() method removes all default whitespaces (spaces and tabs \t) and returns the copy of the string. Python code to strip trailing whitespaces from string

Note: Code works in both Python 2 and 3 Output […]

Python: Position of next occurrence of a sub-string


Python code to get the position of next or second occurrence of a sub-string within a string.

Note: Above code works in both Python 2 and Python 3 Output:

Python: Replace/remove string between two delimiters/characters

This Python code helps you to to replace a string between two delimiters or characters delete/remove string between two characters or delimiters Python code to replace string between two delimiters

Python code to delete/remove string between two characters/delimiters Replace 5th line of above code with below one

Note: This code works in both […]

VBA macro to find duplicates in excel


VBA macro to find duplicates in excel sheet. This macro finds the duplicates in user selected range and highlights them in light red color. VBA code to find and highlight duplicates

Add above code to your excel workbook How to use this macro Select the range (column/row/columns and rows…) in which you want to […]

Macro to extract file name from file path [Excel VBA]

Excel VBA macro to extract file name from file path. This macro extracts the string (file name) which is between dot (.) and backslash(\) delimiters (from right side).

Page 1 of 1012345...10...Last »