Str.partition & rpartition
It separate the string with separator available in string otherwise it will return string and two empty string
This blog is about working with data by using different tools Excel ,Python, Access Power automate etc .
It separate the string with separator available in string otherwise it will return string and two empty string