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