Post
Topic
Board Development & Technical Discussion
Merits 2 from 2 users
Re: Wallet Label Export Format: A Proposal by Craig Raw
by
NotATether
on 31/08/2022, 07:12:18 UTC
⭐ Merited by NeuroticFish (1) ,ETFbitcoin (1)
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.