Print excel file format country code and iban number separately

[ertan_ay1 (ertan ay)]

this part is FR for some people…not a

lways EN

[supermanPunch (Arpan)]

@supermanPunch

Could you show us a Screenshot of How you are using the Expression ?

@ertan_ay1 , Could you show us the Expression in the Workflow ? Want to know what is the value you are using as the String.

[ertan_ay1 (ertan ay)]

in this way

[image]

[supermanPunch (Arpan)]

@ertan_ay1 ,

It looks like you are passing a Hardcoded value into the Type into Activity.

If you are supposed to enter each value present in the Excel Column, then You would need to read the Excel as a Datatable using Workbook Read Range Activities, Use For Each Row Activity Then Inside For Each Row Activity you would have to use Type Into Activity with the Below Expression :

System.Text.RegularExpressions.Regex.Match(CurrentRow("IBAN").ToString,"(\D+)?(\d+)").Groups(1).Value.ToString

System.Text.RegularExpressions.Regex.Match(CurrentRow("IBAN").ToString,"(\D+)?(\d+)").Groups(2).Value.ToString

Here CurrentRow is each row present in the Datatable and CurrentRow("IBAN").ToString will provide us the IBAN value of each row in Excel.

[ertan_ay1 (ertan ay)]

this code writes the same number for everyone but everyone has a different number

[supermanPunch (Arpan)]

@ertan_ay1 ,

Yes. That is because you are using the Hardcoded value as the Input String.

We need to replace it with your dynamic row value from the Excel.

You are using this Expression :

System.Text.RegularExpressions.Regex.Match("55199415284267214210047337","(\D+)?(\d+)").Groups(1).Value.ToString

You have to replace the String "55199415284267214210047337" with your dynamic value from the For Each Row in Datatable.

System.Text.RegularExpressions.Regex.Match(CurrentRow("IBAN").ToString,"(\D+)?(\d+)").Groups(1).Value.ToString

You would require to do the Solution Somewhat in the Below way :

UiPath - How to loop through rows and columns in Excel and pass values to web search/input

[ertan_ay1 (ertan ay)]

I understand what you mean but my excel is coming by email,for this reason i can’t copy the path

[supermanPunch (Arpan)]

@ertan_ay1 ,

In that case, Could you Explain what is your Process actually ? You could explain it Stepwise?

Earlier, You did share Screenshots of Excel Sheet, Hence was assuming that you had an Excel file from where you are retrieving the values.

@ertan_ay1

farklı iban1236×120 21.2 KB

[ertan_ay1 (ertan ay)]

First of all, I apologize for not being able to reply right away. @supermanPunch

1. client account login request coming to me
   2)by email
   3)this excel file is downloaded by the robot
   4)As seen in the photo, all information is entered in the UiTest.
2. name, surname, customer number, and IBAN
   6)However, as seen in the photo, the country code that is a letter as IBAN information and the IBAN number that follows are combined and it is requested to be written separately in the box.
   7)and all customers’ IBAN information and country code letters are different. (sample = FR5454485785454 , TR5445544544555, AB545845454854, FS5648764548654 as…)
   
   
   
   
   

[supermanPunch (Arpan)]

@ertan_ay1

2)by email
3)this excel file is downloaded by the robot

@ertan_ay1 , Were you able to Automate the Downloading/Saving of the Excel in the Email Request?

What are the Steps you have already Automated ?