Help For String Manipulation

[ADITYA_MUKHERJEE]

Hi, Can any one please explain this exprpession?

row(1).ToString.Split(Environment.NewLine.ToCharArray,StringSplitOptions.RemoveEmptyEntries)(0).Split(":".ToCharArray,StringSplitOptions.RemoveEmptyEntries)(1).Trim

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

[ppr (Peter | MVP)]

@ADITYA_MUKHERJEE
row(1).ToString.Split(Environment.NewLine.ToCharArray,StringSplitOptions.RemoveEmptyEntries)
it is taking 2nd row sencond column to a string splits the string in a string array by all newLine chars

(0).Split(":".ToCharArray,StringSplitOptions.RemoveEmptyEntries)
it is taking from above retrurned string array the first item and splits it based on : into a string array

(1).Trim
from from second received split array it takes the second item, removes the leading and trailing spaces

et voila: The output is 4526079023

[desineediaditya (Aditya D)]

Hi @ADITYA_MUKHERJEE,

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!’
Regards,
Aditya

[ADITYA_MUKHERJEE]

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?

[ADITYA_MUKHERJEE]

doubt.xlsx (8.5 KB)

[ppr (Peter | MVP)]

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