Client Security Hash - GetHashCode workflow not applying Client information string to SHA1

in_HashFormula ClientID+"-"+ClientName+"-"+ClientCountry does not generate the desired string. Only “–” gets written to the SHA1 website. I even used the ClientID.Trim+"-"+ClientName.Trim+"-"+ClientCountry.Trim . I setup the ClientID, ClientName, and ClientCountry as String Variable type with Scope Do in the System1_ExtractClientinformation. I also setup ClientID, ClientName, and ClientCountry as Out Direction with String Argument type. I followed the Assign as listed in the assignment:

ClientID
Clientinformation.Substring(Clientinformation.IndexOf("Client ID: ") + "Client ID: ".Length).Split(Environment.NewLine.ToCharArray)(0)

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

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

Please help.

It looks like your logic will result in this string currently: "Client ID:-Client Name:-Client Country:".

To find the values to the right of these, you can use a regular expression like this:

ClientID
System.Text.RegularExpressions.Regex.Match(Clientinformation, "(?<=Client ID:\s).*").Value

The rest will be similar.

Hi @tolenal,

What is inside

Can you provide that string please?

Thanks

It is the output of the screen scraping for the ACME website:

Thanks for the suggestion. I am able to see the output with a Write Line and it is able to parse the information in the System1 folder but the string still does not appear in the SHA1 folder. The result is the same “- -” and the Hash code repeats for all the transactions.

After the data for Clientinformation is scraped, what text is in the variable? I’m thinking that the data appears differently once scraped.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.