Read Text and LINQ Command

Hi

I would like to to ask about the fastest way to process the text file that contain more than 20k lines.
example as below “Input File”

I need to do a summary and the output In excel format as below:

Total = Value before + sign

“OUTPUT”

Name Number Of transaction Total Date
ETIQA FAMILY TAKAFUL 4 1,525.1 April
TNBA 3 6,704.65 April

“Input File”

BEGINNING BALANCE 991,628.29
01/04 CMS - CR PYMT MARS 529.10+ 992,157.39
ETIQA FAMILY TAKAFUL
ETIQA CLAIM
6626337
01/04 CMS - CR PYMT MARS 6,751.63+ 998,909.02
EFTB - FAMILY TAKAFU
ETIQA CLAIM
6633982
01/04 CMS - CR PYMT MARS 242.00+ 999,151.02
ETIQA FAMILY TAKAFUL
ETIQA CLAIM
6556592
01/04 CMS - CR PYMT MARS 262.00+ 999,413.02
ETIQA FAMILY TAKAFUL
ETIQA CLAIM
6568745
01/04 CMS - CR PYMT MARS 492.00+ 999,905.02
ETIQA FAMILY TAKAFUL
ETIQA CLAIM
6613546
01/04 CMS - DR CORP CHG 78.00- 983,667.19
CMS - DRaa CORP CHG

01/04 CMS - CR PYMT MARS 5,336.65+ 989,003.84
PERMODALAN NASIONAL
2200003135
PYT FR PERMODALAN NA
02/04 TRANSFER TO A/C 199.00+ 989,202.84
EJ BAYU *
PCR TEST
Pcr test
02/04 CMS - CR PYMT MARS 177.55+ 989,380.39
ELIB A/C-DATARAN (PA
ETIQA CLAIM
6618588
02/04 CMS - CR PYMT MARS 1,232.00+ 990,612.39
ELIB A/C-DATARAN (PA
ETIQA CLAIM
6566508
02/04 CMS - CR PYMT MARS 757.00+ 991,369.39
ELIB A/C-DATARAN (PA
ETIQA CLAIM
6624097
02/04 TRANSFER TO A/C 136.00+ 991,505.39
TNBA
CLAIM

I can do this by insert each line in excel and do the query.

and the processing time to slow.
I need a advise on how to speed up the process to get the output.

Thank you
Regards
Jamuri

1 Like

Hey @Abang_Jamuri_Abang_Shoker

You wanna remove the + sign is that correct ?

Thanks
#nK

Hi Nithinkrishna,

No, I would like to get the idea how to speed up my process by using text file and LInq .
My current process was i need to text file to excel and then run Linq query to get the summary report .

Sample Text and output required as per below attached file.

In file.docx (45.2 KB)

Thank you

Okay @Abang_Jamuri_Abang_Shoker

Let me check.