How to use switch

[Matthew2 (Matty)]

Hi,

I have two excel files, one contains currency rates and the other file contains the total price in different currency.

I will have to split the code and price from the Total Price column in Excel 1 and based on the currency code, I have to multiply the Total Price (excel 1) and the currency rates from the 2nd excel.

I have achieved the splitting of total price column from excel 1, now how to get the respective currency rates from excel 2 ?
screenshot of both files

[Yoichi]

Hi,

We can achieve it using dictionary and regex as the following, for example.

Sample20210826-3.zip (3.1 KB)

Hope this helps you.

Regards,

[Matthew2 (Matty)]

Hi,

Could you help me to find the libary of dict? Cannot find it anywhere
I mean the variable type of dict

[Yoichi]

Hi,

Can you check the following?

It’s System.Collections.Generic.Dictionary

Regards,

[Matthew2 (Matty)]

Hi,
I got this one, not sure why

[Yoichi]

Hi,

We need to set Type for each argument.

Regards,