We will loop through the ExtractedUserData variable and delineate each row for String manipulation in the following steps:
-
Add a new Step action with the Title as Loop DataTable. Add it outside the previous Step, but still within the Try block.
-
Within this Step action, add a Loop action to step through each row in the Table, set the Table variable as ExtractedUserData, and Assign the current row to a new Record variable called CurrentRow (create this with the wizard), as shown here:
-
Under the previous loop, let's add another Loop action to step through each item in the row. For that, we will iterate through each value in the record, set the Record variable as CurrentRow, and assign the current value to a new variable called CurrentValue, as shown here:
-
Within the second loop, we will check for the row number and assign it to the respective row name. Let's add a counter variable...