Extract only after 4 digit account Number in Datatable through linq

[Himanshu_Pratap_Rana (Robot Master)]

I have excel and i want after 4 digit from account number column through linq,because some spend time through other way because huge amount of data.
input.xlsx (10.6 KB)

[Yoichi]

Hi,

Can you share expected output?

Regards,

[Himanshu_Pratap_Rana (Robot Master)]

i want only after 4 digit in add in another column (Last Four Digit)

[Yoichi]

Hi,

Let’s say dtResult has 2 columns : AccountNumber and Last4digit

Then

dtResult = dt.AsEnumerable.Select(Function(r) dtResult.LoadDataRow({r("AccountNumber").ToString,Strings.Right(r("AccountNumber").ToString,4)},False)).CopyToDataTable

note: dt is datatable from the excel file.

Regards,

[Himanshu_Pratap_Rana (Robot Master)]

Hi Yoichi,
I am sharing my workflow and i want last four digit number showing in my message box.

[Yoichi]

Hi,

Can you try the following expression in MessageBox?

Strings.Right(CurrentRow("AccountNumber").ToString,4)

Regards,