Is there any way to search for a transaction by prefix?

ABCbits

legendary

Activity: 2870

Merit: 7490

Crypto Swap Exchange

Quote from: NeuroticFish on February 23, 2023, 05:01:11 PM

PS. If you want to play with local database you may want to look at Bitcoin in SQL, but the online version, sadly, is not too useful (times out too fast hence doesn't return anything useful)

It's not up-to-date (last update was on 9 months ago), so you might as well as run self-hosted Electrum server/block explorer and directly access it's SQL database using query which contain LIKE '01EF%' on TXID column.

NeuroticFish

legendary

Activity: 3668

Merit: 6382

Looking for campaign manager? Contact icopress!

I may be a bit late to the party but, if walletexplorer by chance didn't help then Blockchair has a great filtering capability, see https://blockchair.com/bitcoin/transactions
You may be able to filter by the amounts and time for example to narrow down what you need.

PS. If you want to play with local database you may want to look at Bitcoin in SQL, but the online version, sadly, is not too useful (times out too fast hence doesn't return anything useful)

NotATether

legendary

Activity: 1568

Merit: 6660

bitcoincleanup.com / bitmixlist.org

Quote from: ?? on ??

I have programmed a block explorer in Java, but it is not yet finished.
The project is not yet on Github etc.
In principle, you can look for everything in the blockchain, for any sign in certain calculation, or after lengths, according to the same "R" etc.
If you can do a little Java, you can program your own search cries.
- The blockchain must be available locally.
- The blockchain is then copied to its own database, takes a while and need a lot of space.
So if you are interested, just write to me.

When you say the blockchain is available locally, do you mean a copy of Bitcoin Core's block data must be available beforehand?

And then the copying - how much extra space does it need on top of that, in gigabytes? Does it just harvest the blocks folder of some full nodes and then converts it into its own format?

hosseinimr93

legendary

Activity: 2380

Merit: 5213

Quote from: nc50lc on February 22, 2023, 06:17:02 AM

Try https://www.walletexplorer.com/.
I've tested it with 20+ first characters of a TXID and it worked, it might not if there's not enough though.

I just tested walletexplorer. It worked even with the first 7 characters.
I also tested walletexplorer with the first 6 characters. It brought me a different transaction, not the one I was looking for.

Quote from: o_e_l_e_o on February 22, 2023, 06:20:33 AM

Usually down to 6 characters, but you will get a lot of duplicates with only 6 characters so better to use a few more, and obviously double check that it has indeed found the right address/transaction and not another one with starts with the same string.

I think if you enter a few first characters of a transaction (at least 6, it doesn't work with 5 characters at all) and there are more than 1 transaction starting with those characters, it shows the one that is alphabetically ahead.

o_e_l_e_o

legendary

Activity: 2268

Merit: 18509

nc50lc beat me to it - walletexplorer works for this. Usually down to 6 characters, but you will get a lot of duplicates with only 6 characters so better to use a few more, and obviously double check that it has indeed found the right address/transaction and not another one with starts with the same string.

Note that they are often not fulled synced with the blockchain. If you scroll to the bottom it will tell you they are currently synced to block 777,528, which is around 250 blocks from the current tip. So any transactions more recent than this won't be indexed by them yet.

nc50lc

legendary

Activity: 2394

Merit: 5531

Self-proclaimed Genius

Try https://www.walletexplorer.com/.
I've tested it with 20+ first characters of a TXID and it worked, it might not if there's not enough though.

Charles-Tim

legendary

Activity: 1512

Merit: 4795

Quote from: NotATether on February 22, 2023, 05:24:24 AM

Unfortunately, Mempool.space did not succeed in finding the transaction after typing the first 6 characters of the transaction hex. Was that feature only for addresses by the way?

Sorry. Unfortunately it does not work for txid, it works effectively for funded addresses only.

NotATether

legendary

Activity: 1568

Merit: 6660

bitcoincleanup.com / bitmixlist.org

Quote from: Charles-Tim on February 22, 2023, 05:18:07 AM

Have you tried https://mempool.space?

You can check this topic:
https://bitcointalksearch.org/topic/m.61442178

because there is possibility of another addresses

So if it works, make sure you check the address to be fully correct, one after the other.

Unfortunately, Mempool.space did not succeed in finding the transaction after typing the first 6 characters of the transaction hex. Was that feature only for addresses by the way?

Charles-Tim

legendary

Activity: 1512

Merit: 4795

Have you tried https://mempool.space?

You can check this topic:
https://bitcointalksearch.org/topic/m.61442178

because there is possibility of another addresses

So if it works, make sure you check the address to be fully correct. Checking this one after the other.

NotATether

legendary

Activity: 1568

Merit: 6660

bitcoincleanup.com / bitmixlist.org

I have a few transactions I need to search for in block explorers but they are all in image format. I could just try to extract the text from the image but that is going to be highly inconvenient. Is there not a block explorer that lets you search for transactions/addresses/blocks by the first few characters? So far, I know that Blockstream and blockchain.com don't let you do that.

Topic: Is there any way to search for a transaction by prefix? (Read 208 times)