Welcome to EpoS Wizard!

As you’ll no doubt have noticed if you’ve previously visited any time in the last decade or two, EPoS Wizard has undergone some quite drastic changes!

YOU WILL BE REQUIRED TO CHANGE YOUR PASSWORD
(See below if you are unable to receive a password reset request)

Read on »

Share:
Notifications
Clear all

Processing ejfile.sda

2 Posts
1 Users
0 Likes
1,002 Views
Posts: 8
Topic starter
Active Member
Joined: 11 years ago

I'm wanting to turn the Z totals from an ejfile.sda into a CSV I can pick up with a spreadsheet. I'm not interested in the amount, just in the Q lines and I only use a very limited range of PLUs. An example:

#005909   28/02/2016    0:36  
01 CLERK01              000000
       * Z 1*                 
PLU                           
          00001-         99999
PLU                           
 P00002                3.000 Q
TENNENTS                 *5.40
 P00012                4.000 Q
Beer 330                 *7.60
 P00013                3.000 Q
Beer 500                 *7.50
 P00022                8.000 Q
MALT WHISKEY            *20.00
 P00023                1.000 Q
OTHER SPIRITS            *1.90
 P00044                3.000 Q
WINE 1/4 BOTTLE          *6.60
 P00058                1.000 Q
SOFT DRINKS              *0.60
***TOTAL              23.000 Q
                        *49.60

Does anyone have anything, or a link to something, that could do this?

Putting out a line per Z per PLU would be fine e.g.
005909,28/02/2016 0:36,P00002,3.000
005909,28/02/2016 0:36,P00012,4.000

etc.

I have access to Windows and Linux PCs.

Reply
1 Reply
Posts: 8
Topic starter
Active Member
Joined: 11 years ago

OK, did it with C#.

Reply
Share: