Discard all with text export YAY! (and of course a request)

You guys probably don't REALLY know how big of a deal this is, so thank you thank you thank you developers.

And then... the inevitable BUT.

Here's the info you're exporting:

- MAIL -
Received: 6/18/2018 3:12 AM (local time)
Discarded: 6/26/2018 4:26 PM (local time)
Sender: Vendor (Outlander Welcome Center)
Subject: Order Fulfilled (Sapphire Fragment x50)
Item #1: Order Fulfilled (Sapphire Fragment x50) x1
[MESSAGE]

BILL OF EXCHANGE
---------------

Good news! We've received word that your order for an item that you wanted to buy has been fulfilled. The item can be collected at the bank in Outlander Welcome Center.

Order Details:
Sapphire Fragment x50
Price: 75 gold
Vendor Location: Outlander Welcome Center
Placed by: Vladamir Begemot
Fulfilled by: REDACTED because this is a public forum
Date of Exchange: 6/18/2018 3:12 AM

Thank you for your business,

First Bank of Brittany
Branches available in Ardoris, Etceter, Port Graff, and Resolute
[END MESSAGE]
------

Here's what we need to know from all that:

BOUGHT, Sapphire Fragment, 50, 75, Outlander Welcome Center, my name, seller name, 6/18/2018, 3:12 AM,

A sell example

SOLD, Pure White Dye, 1, 3999, Brittany Alleys, Vladamir Begemot, buyer name, 6/22/2018, 4:33 PM,

That's it, the rest is just fluff.

Do it like that and we can import it all day long, you have saved the day, we throw a big party, the worlds collide, everyone rejoices, it is the end of the Iron Age and we can move back into the Golden Age.

No commas in the gold values please. Yes commas between date and time and after time so the spreadsheet can handle it please.

Thank you!!!!!!!!!!!!!!!!

----- Edit: Special Cases -----

Gold receipt, item name and quantity blank, put the gold amount in the gold column

RECIEVED, , , 1099, Mail, Vladamir Begemot, Sender name, Date, Time,

Multi-receipt of items in mail, just make a line for each item.

RECIEVED, Gaia's Heart, 1, 0, Mail, Vladamir Begemot, Sender name, Date, Time,
RECIEVED, Bronze Spear of Gaiaism +9, 1, 0, Mail, Vladamir Begemot, Sender name, Date, Time,
RECIEVED, Bronze Spear of Gaiaism +8, 1, 0, Mail, Vladamir Begemot, Sender name, Date, Time,

Expired items, gold is refund amount

Expired, Item Name, 1, 5, Mail, Vladamir Begemot, Vendor City, Date, Time,

 

Agreed!

Having this in a format that can be put right into excel will be a life saver for anyone who sells small or large quantities of goods.

While the flavor text is fun it becomes redundant when exporting these sales as I'm sure Vladimir knows

 

+1

I think the text comma delimited idea is great! Then we don't have to write Powershell Scripts to turn lines into fields for our spreadsheets. Long Live Practical Data Export Techniques !

 

Lol, huzzah!

 

Great idea!