Level 3 Assigment ( i am stuck)

basicly the guide its asking me to extract the ID of the client , name and country, it says that i should know how to do it but i dont know, can someone help me out please?

1 Like

You need to use split function as outlined in Lesson 3 Level 1 (Data manipulation).
Video 2 provides you a guideline on the split. Possibly you’ll need to trim the resulted string to get rid of spaces.

1 Like

Client_tempinfo=get_txt.Indexof(“ClientName”)-gettxt.indexof(“ClientID”)

client_ID=get_txt.Substring(get_txt.indexof(“ClientID”)+10,resultid-10).Trim.tostring

Try something like this to fetch client name and country

1 Like

Wow reading this is confusing me quite badly.

1 Like

Okay try this

ClientInfoStr.Split({"Client ID: ","Client Name: ","Client Country: "},StringSplitOptions.None)System1_ExtractClientInformation.xaml (9.7 KB)

1 Like

vbCr return to line beginning and vbLf go to next line.

This is used to fetch exact string and finally trim to remove additional empty spaces

1 Like