Re: Wallet Label Export Format: A Proposal by Craig Raw

Quote from: NotATether on August 31, 2022, 07:12:18 AM

Quote from: n0nce on August 31, 2022, 02:20:34 AM

Have you tried 'coding' the rather simple parsing logic in Excel? I'm not a very skilled Excel user, but just tried it and it works like a charm.

Code:

=IF(LEN(A2)<64; "address"; IF(LEN(A2)=64; "transaction"; IF(ISNUMBER(SEARCH("<";A2)); "input"; "output")))

No need to add an extra column for this, indeed!

I highly doubt the average Excel user with no programming language background whatsoever will be able to reproduce this query or understand what it does.

Then it can just be added into the BIP and that's it. It could even be exported with the data as a comment at the end of the file.
A third column would instead increase the file size by 50% as you'll add a 3rd field for each dataset.