Join whitspace

Dear all,

I am automating a process in which I do need to join the pattern found using regex. I need to join the IBAN account from bankstatement, and after that, getting the last four digits.

I do this: Var_IBAN = Var1.Replace(" “,”").ToString. Then I write it in excel, but when it is pasted, it is pasted with whitespace. It is not joined. After that, i do Var_2 = Var_IBAN.Substring(Var_IBAN.Length, -4). And it gets me just the last 3 digits.

How can I do it to join the pattern?



Can you please go through articles as below?


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