Welcome to EpoS Wizard!
Notifications
Clear all
Processing ejfile.sda
Posts: 8
Topic starter
Dec 29, 2016 5:06 pm
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
Dec 31, 2016 8:19 pm
OK, did it with C#.
Reply
Forum Information
Our newest member: stanhats
Latest Post: Printer issue
Forum Icons:
Forum contains no unread posts
Forum contains unread posts
Topic Icons:
Not Replied
Replied
Active
Hot
Sticky
Unapproved
Solved
Private
Closed