Unable to capture the client ID, Client Name, Client country

Thanks for getting back to me! Can you please explain this portion of the code?

Split(Environment.NewLine.ToCharArray)(0)

I know you can change the (0) portion to 1, 2, 3, etc but I don’t fully understand it

PS

You are the man

Thanks!

out_ClientID = ClientInfoDetails.Split(Environment.NewLine.ToArray, StringSplitOptions.RemoveEmptyEntries)(0).Split(":"c)(1).Trim

out_ClientName = ClientInfoDetails.Split(Environment.NewLine.ToArray, StringSplitOptions.RemoveEmptyEntries)(1).Split(":"c)(1).Trim

out_ClientCountry = ClientInfoDetails.Split(Environment.NewLine.ToArray, StringSplitOptions.RemoveEmptyEntries)(2).Split(":"c)(1).Trim

3 Likes

ClientInfo is variable of GetValue Activity

ClientId=ClientInfo.Substring(ClientInfo.IndexOf("Client ID: ")+"Client ID: ".Length).Split(Environment.NewLine.ToCharArray)(0)

ClientName=ClientInfo.Substring(ClientInfo.IndexOf("Client Name: ")+"Client Name: ".Length).Split(Environment.NewLine.ToCharArray)(0)

ClientCountry=ClientInfo.Substring(ClientInfo.IndexOf("Client Country: ")+"Client Country: ".Length).Split(Environment.NewLine.ToCharArray)(0)

use write line activity to cross check
ClientID + “-” + ClientName + “-” + ClientCountry