Export to NODE XL

Tagged: export, node xl, nodexl

This topic has 9 replies, 3 voices, and was last updated 4 years, 11 months ago by Rafael.

Viewing 10 posts - 1 through 10 (of 10 total)

Author

Posts
March 3, 2016 at 7:25 pm #661

Barri
Participant

Hi,
you can export the result to NodeXL?
Best regards,
jb

March 3, 2016 at 8:37 pm #662

mhawksey
Keymaster

Hi – old recipe here https://mashe.hawksey.info/2011/10/using-google-spreadsheet-to-feed-nodexl/

March 3, 2016 at 9:13 pm #663

Barri
Participant

I see it very difficult for me.
Thank you so much.
Barri

April 11, 2016 at 2:33 pm #700

Barri
Participant

Hi,

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)) CORRECT

3º
=EXPAND(ArrayFormula(IF(LEFT(E2:E,1)=”@”,MID(E2:E,2,FIND(” “,E2:E)-2),))) ERROR
I can not find the right formula

4º
=EXPAND(ArrayFormula(LOWER(IF(D2:D=””,A2:A,D2:D)))) ERROR
=ArrayFormula(LOWER(IF(D2:D=””,A2:A,D2:D))) CORRECT

I do not get it to work 🙁 🙁 🙁

can you help me?
barri

April 12, 2016 at 8:51 am #701
mhawksey
Keymaster
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.

@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 #705

Barri
Participant

the first option is PERFECT!!!

Gracias,
Barri

April 14, 2016 at 8:59 pm #710

Barri
Participant

Because I do not take the cell B (vertex 2) RT?

https://docs.google.com/spreadsheets/d/1K_qZjf5ZJ_zIOWoVRtEVDbMo4FKbhe4_IMxo34I_wgM/edit#gid=948675872

Some and not others

Best regards,
Barri

June 6, 2016 at 6:55 pm #734

Barri
Participant

la solución es:

=ARRAYFORMULA(SI(L2:L=””,SI.ERROR(REGEXEXTRACT(F2:F,”@([A-Za-z0-9]+)”),””),L2:L))

A-Z

Salu2
jb

June 6, 2016 at 9:47 pm #735

mhawksey
Keymaster

Thanks – updated in the shared link 🙂

November 6, 2018 at 2:05 pm #1299

Rafael
Participant

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?
Many thanks
Author

Posts