Sep-27-2021, 11:05 AM
Hello Gurus,
I am from sql background and i am working on one python requirement to extract text from the give string based on position and pattern.
For e.g
input search_pattern position expected_output
'inf***maint***three' *** 2 maint
'but@@milk@@ghee @@ 3 ghee
'but@@milk@@ghee @@ -3 but
Have tried above using substring and instr in sql but very leangth code.
Can any one guide me
I am from sql background and i am working on one python requirement to extract text from the give string based on position and pattern.
For e.g
input search_pattern position expected_output
'inf***maint***three' *** 2 maint
'but@@milk@@ghee @@ 3 ghee
'but@@milk@@ghee @@ -3 but
Have tried above using substring and instr in sql but very leangth code.
Can any one guide me