March 3, 2016 at 7:25 pm #661
you can export the result to NodeXL?
jbMarch 3, 2016 at 8:37 pm #662
Hi – old recipe here https://mashe.hawksey.info/2011/10/using-google-spreadsheet-to-feed-nodexl/March 3, 2016 at 9:13 pm #663
I see it very difficult for me.
Thank you so much.
BarriApril 11, 2016 at 2:33 pm #700
I have tested the formulas and do not work in this version.
1º. DELETE FILE A
=EXPAND(ArrayFormula(IF(LEFT(E2:E,1)=”@”,MID(E2:E,2,FIND(” “,E2:E)-2),))) ERROR
I can not find the right formula
I do not get it to work 🙁 🙁 🙁
can you help me?
barriApril 12, 2016 at 8:51 am #701
hmm 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.
April 12, 2016 at 5:07 pm #705
- This reply was modified 4 years, 3 months ago by mhawksey.
the first option is PERFECT!!!
BarriApril 14, 2016 at 8:59 pm #710
Because I do not take the cell B (vertex 2) RT?
Some and not others
BarriJune 6, 2016 at 6:55 pm #734
la solución es:
jbJune 6, 2016 at 9:47 pm #735
Thanks – updated in the shared link 🙂November 6, 2018 at 2:05 pm #1299
Thank 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?
You must be logged in to reply to this topic.