Help with text extraction - System1 - ExtractClientInformation

Let me explain it

You have this
image

Your variable is a string with new lines and empty spaces.
Hence:

  1. Use yourvar.Split(Environment.NewLine.ToArray,StringSplitOptions.RemoveEmptyEntries) - to remove the new lines characters and empty spaces.

Output of this will be “ClientID: LUJ23971,Client Name: Chance Strittmatter,Client ID: PU23971” which is an array of strings say “yourarray”

To get values from array using index you do this and then take the value after “:” split again and the use idex again :slight_smile:

yourarray(0).Split(":"c)(1).Substring(1) which is your ClientID

so
yourarray(1).Split(":“c)(1).Substring(1) is Client Name
yourarray(2).Split(”:"c)(1).Substring(1) is Client ID

7 Likes