How can I use string split to assign multiple variables in for each loop?

Help Studio
1

Hi all, this is my first post. My project is for web navigation/scraping and I need some help.

I have an HTML form that asks for “Client SSN, Account Number, and Destination”, using Custom Input activity.

The output is stored in one variable in the HTML file.
window.external.setResult(SSN + "|" + Account + "|" + Destination);

I am using the Assign activity to break out the values separated by the | char.

Value_SSN = SearchValues.Split(CChar("|"))

Next, I want to save those split values into their own respective variables.

Can anyone offer guidance on how to complete this?

Thank you!

Capture
Capture403×537 9.44 KB

HTML form

<!DOCTYPE html>
<html lang="en">

 <head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <title>Intelifi</title>

  </head>

  <body>
      
          Client SSN:<br>
          <input type="text" id="SSN"><br>
          Account Number:<br>
          <input type="text" id="Account"><br>
          Destination:<br>
          <input type="text" id="Destination"><br>

          <button onclick="SubmitValues()">Submit</button>


          <script type="text/javascript">
          function SubmitValues(){
            var SSN = document.getElementById("SSN").value;
            var Account = document.getElementById("Account").value;
            var Destination = document.getElementById("Destination").value;
            window.external.setResult(SSN + "|" + Account + "|" + Destination);
            return true;
          }
            
          </script>
  </body>
  </html>
2

Is there a real need to loop through the array just because you have split it?

Can’t you use Multiple Assign and then do:

Try
Array_Split=Search.Values.Split("|"c)
Value_SSN= Array_Split(0)
Value_Account= Array_Split(1)
Value_Destination= Array_Split(2)

Process your variables as required

End Try
Catch 

End Catch

Obviously, this assumes that there is a pattern and your string is predictable

3

give a try on return the string as serialized JSON like
{“SSN”:“123”, “Account”:“12345”,“Destination”:“ABC”}
but quote/unescape the "

then you can easy bring it into a dictionary by:

grafik
grafik820×214 13.5 KB

JsonConvert.DeserializeObject(Of Dictionary(Of String, String))(YourStringVar)

And allows you to use the key like
yourDictVar(“Account”) e.g. getting the Account

5

I like your suggestion but don’t know how to implement it. Also how did you get the immediate window?

6

Have a check on the screenshot
set a breakpoint somewhere and start debugging, once you will fet paused you can see the immediate panel

Also refer to UIPath Academy Debugging course to get trained on this as well

7

AndyMenon! I figured it out! Thanks!

8

You’re welcome Alexander! Great that you have a solution! :slight_smile: :+1:

1 Like
9

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