String Manipulation in Excel

Help Studio
, ,
1

image
image1920×1080 231 KB

image
image1920×1080 252 KB

Hi, can anyone please help me understand the string manipulation function?
The output for the particular assign activity is 4526079023.
Please help.
Thanks.

2

@ADITYA_MUKHERJEE As far as I understand :

  1. The First Split, Splits that Cell Value based on New Lines and It takes the First Item After Splitting which will be the First Line. Since that Line contains “P.O. Number :” I believe
  2. The Second Split Splits the First Item of the First Split based on “:” and Takes the Second item that is the Number and a Trim Operation is performed on it to remove Starting and Ending Spaces.

In this way you Obtain the P.O. Number

1 Like
4

str_Name.Split(“d"c).First.ToString.Substring(str_Name.LastIndexOf(”:")).ToString try that syntax