ilemi
@ilemi
268 Following
3517 Followers
2 replies
0 recast
7 reactions
1 reply
0 recast
8 reactions
1 reply
1 recast
16 reactions
1 reply
2 recasts
13 reactions
1 reply
1 recast
12 reactions
5 replies
2 recasts
13 reactions
15 replies
0 recast
22 reactions
4 replies
7 recasts
48 reactions
1 reply
1 recast
8 reactions
We're working on some fixes with @neynar, but for now if you're using the verifications table then use this to parse out the address:
from_hex(COALESCE(try(split(claim, '"')[4]), try(split(claim, '''')[4])))
for mentions col in casts, use:
split(replace(replace(replace(cancel.mentions,'[',''),']',''),' ',''),',') 3 replies
0 recast
14 reactions
5 replies
2 recasts
24 reactions
10 replies
5 recasts
28 reactions
5 replies
3 recasts
31 reactions
5 replies
0 recast
9 reactions
3 replies
3 recasts
14 reactions
6 replies
2 recasts
22 reactions
39 replies
14 recasts
96 reactions
11 replies
7 recasts
37 reactions
2 replies
0 recast
29 reactions
5 replies
0 recast
19 reactions