Yes. Based on “Net 30 days” it is possible.
Just tell me one thing that the 8 Digit No you want to Extract will be always on NextLine of “Net 30 days” ??
And Does that NextLine will contain only one 8 digit no ??
If Yes is the ans for both the above ques then below is the workflow for the same :-
MainPratik.xaml (7.9 KB)
text.txt (184 Bytes)
If the data format is gonna be same always then below String Manipulation is used to retrieve the Next Line of “Net 30 days”
readTextFile.Substring(readTextFile.IndexOf("Net 30 Days")+"Net 30 Days".Length).Split(Convert.ToChar(vblf))(1)
After that on that Line the Regex is used as shown below :-
Mark as solution and like it
Er Pratik Wavhal