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?