I have to extract the client details from acme page
in one by one the is client id client name client county and put the details into SHA1Online hash key generator like TD88219-Caroll Eisenmann- Romania this
I have to extract the client details from acme page
can anyboday help me out its urgent
Hi @Sandhya_Gajare ,
Could you let us know what problem/issue you have faced when extracting or what have you tried and what is not working ?
You can try with Get Text activity and use split expression get the values.
Check out the video Link for reference and thread
Regards
Gokul
No @Sandhya_Gajare , You can check above thread. or just tell us where you having the issue
Regards
Gokul
@Gokul while i am trying to put data into SHA1Online Text Box EQ75283- Kizzie Kohen- Italy i have to remove the space after -
Share the expression for generating this EQ75283- Kizzie Kohen- Italy
value?
Check out the Split expression
Client ID
ClientID = ClientInformation.Substring(ClientInformation.IndexOf("Client ID: ") + "Client ID: ".Length).Split(Environment.NewLine.ToCharArray)(0)
Client Name
ClientName = ClientInformation.Substring(ClientInformation.IndexOf("Client Name: ") + "Client Name: ".Length).Split(Environment.NewLine.ToCharArray)(0)
Client Country
ClientCountry = ClientInformation.Substring(ClientInformation.IndexOf("Client Country: ") + "Client Country: ".Length).Split(Environment.NewLine.ToCharArray)(0)
In the Type Into Use like this : ClientID+"-"+ClientName+"-"+ClientCountry
Regards
Gokul
When you are extracting the Client ID, Client Name and Client Country and assigning/placing it in variables, you would need to use .Trim
on it to remove the Leading and Trailing white spaces.
You can use it in the Split Expression that you are using or as a Separate Assign
Activity or Directly into the Type Into
Activity as well.
yourClientNameVar.Trim
Hi Sandhya,
Please follow the below Steps:-
Using GET TEXT Activity (if needed using Anchor Base approach) extract all the three details in variable name Str_Client_Name, Str_Client_ID, Str_Client_Country.
Now Use TYPE INTO activity, In properties enable the “EMPTY before entering option” and in input of it type exactly this:- Str_Client_Name+“-”+Str_Client_ID+“-”+Str_Client_Country
If this sounds good to you please mark it as an SOLUTION.
Thanks.
@Sandhya_Gajare
after extracting data please apply this
ClientDetails.Substring(ClientDetails.IndexOf("Client Name: ")+"Client Name: ".Length).Split(Environment.NewLine.ToCharArray)(0)
ClientDetails.Substring(ClientDetails.IndexOf("Client ID: ")+"Client ID: ".Length).Split(Environment.NewLine.ToCharArray)(0)
ClientDetails.Substring(ClientDetails.IndexOf("Client Country: ")+"Client Country: ".Length).Split(Environment.NewLine.ToCharArray)(0)
store in 3 different variables. you will not get space and then use as you want
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.