Hi, I'm seeking advice on following case. I'm using BASE 9.1.3. I have the attached raw file in txt format. How do I group all Team 1 together? Because when I import, the data all store on the same column. A. Team 1 0116 241 Johor MSA IN 25 4% .00 2213 MSA CW 16 2% 14,100.00 ASE INQ 600 1% .00 How do I group all Team 2 together? Because sometimes, there could be a row “TERM OWNR LOCATION“ in between, but as long as no next line like “0135 241 Johor” wording appear, the following rows should be group as above rows. B. Team 2 0135 241 Johor MSA IN 128 4% .00 3199 CWD 550 27% 626,500.00 TRC 22 1% 472,433.09 DATE PRINTED :30/11/2011 23:36:19 NON CRITICAL, CONFIDENTIAL ATM/CDM TERMINAL USAGE, BY TRX BRANCH:000 PAGE 00002 REPORT ID : f456987 TERM OWNR LOCATION TRN CNT AMOUNT TOTAL TAC 1 % .00
... View more