Help For String Manipulation

Hi, Can any one please explain this exprpession?


This is a screenshot of a portion that is extracted from a pdf and this data is in a single cell


The output is 4526079023

it is taking 2nd row sencond column to a string splits the string in a string array by all newLine chars

it is taking from above retrurned string array the first item and splits it based on : into a string array

from from second received split array it takes the second item, removes the leading and trailing spaces

et voila: The output is 4526079023



I was wondering you are trying to understand the expression or looking for solution if so then use this regular expression that gives you output
This is for your reference

if this solves your query then mark this as solution.
Happy Automation!’

1 Like

Thanks a lot brother…I am stuck with another doubt, can you help?

How can I separate address, telephone number, emai id, website into different cells?

doubt.xlsx (8.5 KB)

Please open a new Topic on this. Clear separated scenarios will help members doing a research to find solutions faster. Thanks


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.