Export to NODE XL
Home › Forums › Advanced usage › Export to NODE XL
- This topic has 9 replies, 3 voices, and was last updated 4 years, 11 months ago by
Rafael.
-
AuthorPosts
-
March 3, 2016 at 7:25 pm #661
Barri
ParticipantHi,
you can export the result to NodeXL?
Best regards,
jbMarch 3, 2016 at 8:37 pm #662mhawksey
KeymasterHi – old recipe here https://mashe.hawksey.info/2011/10/using-google-spreadsheet-to-feed-nodexl/
March 3, 2016 at 9:13 pm #663Barri
ParticipantI see it very difficult for me.
Thank you so much.
BarriApril 11, 2016 at 2:33 pm #700Barri
ParticipantHi,
I have tested the formulas and do not work in this version.
1º. DELETE FILE A
2º
=EXPAND(ArrayFormula(LOWER(A2:A))) ERROR
=ArrayFormula(LOWER(A2:A)) CORRECT3º
=EXPAND(ArrayFormula(IF(LEFT(E2:E,1)=”@”,MID(E2:E,2,FIND(” “,E2:E)-2),))) ERROR
I can not find the right formula4º
=EXPAND(ArrayFormula(LOWER(IF(D2:D=””,A2:A,D2:D)))) ERROR
=ArrayFormula(LOWER(IF(D2:D=””,A2:A,D2:D))) CORRECTI do not get it to work 🙁 🙁 🙁
can you help me?
barriApril 12, 2016 at 8:51 am #701mhawksey
Keymasterhmm there is probably a better way to do this:
Method 1: check out the formula in this NodeXLFormatted Sheet (see cells A2, B2, and C2)
Methods 2: Use TAGSExplorer and export an edge list by adding &output=true to the url (you may need to enable pupups) e.g.
@reply only – http://hawksey.info/tagsexplorer/?key=1EvPNJqLfNrlBN6ljIk-i8LHImeghBt0DrkAfdS_izuY&sheet=Archive&output=true
@reply and @mention only – http://hawksey.info/tagsexplorer/?key=1EvPNJqLfNrlBN6ljIk-i8LHImeghBt0DrkAfdS_izuY&sheet=Archive&mentions=true&output=true
@reply, @mention and RT only – http://hawksey.info/tagsexplorer/?key=1EvPNJqLfNrlBN6ljIk-i8LHImeghBt0DrkAfdS_izuY&sheet=Archive&mentions=true&retweets=true&output=true
-
This reply was modified 7 years, 5 months ago by
mhawksey.
April 12, 2016 at 5:07 pm #705Barri
Participantthe first option is PERFECT!!!
Gracias,
BarriApril 14, 2016 at 8:59 pm #710Barri
ParticipantBecause I do not take the cell B (vertex 2) RT?
Some and not others
Best regards,
BarriJune 6, 2016 at 6:55 pm #734Barri
Participantla solución es:
=ARRAYFORMULA(SI(L2:L=””,SI.ERROR(REGEXEXTRACT(F2:F,”@([A-Za-z0-9]+)”),””),L2:L))
A-Z
Salu2
jbJune 6, 2016 at 9:47 pm #735mhawksey
KeymasterThanks – updated in the shared link 🙂
November 6, 2018 at 2:05 pm #1299Rafael
ParticipantThank you very much for the help. It works perfectly. However, the table I have is too big and I can not edit it in the google spreadsheets. Is it possible that you indicate how the same formulas are written but in Excel?
Many thanks -
This reply was modified 7 years, 5 months ago by
-
AuthorPosts
- You must be logged in to reply to this topic.