Feb 15, 2018 07:31 AM
(This post was last modified: Feb 15, 2018 07:33 AM by Sader604.)
I cannot post links yet because i'm not 50 posts so this is gonna be troublesome to explain here... so please PM me or add on Skype (i'll give on PM)
Telegram is a chat application created by Twitter and every group has an invite link.
When you go to the link it displays current amount of members in the group.
I want to export the amount of members listed there into a column in my Google Sheets, so i do it by using this command:
But because class i am importing which is "tgme_page_extra" contains both the number of members and a word "members" Google Sheet won't recognize it as a number. So result in the column looks like "5039 members".
Which means i cannot use basic functions on these exported values like for example sorting from high to low, low to high.
So what i am looking for is any good way to import just a number. It can be a new function for google sheets written from scratch, it can be a fix to my command, it can be any other idea.
I was thinking that maybe, you can just let the command above import it with "members" word into column A.
And then in column B write a function that takes only numbers from column A, and ignore all other signs/letters?
No idea if that would be possible, just an idea i came across.
I'm willing to pay like 15-20$ in Bitcoin/Ethereum for a fix to this.
Telegram is a chat application created by Twitter and every group has an invite link.
When you go to the link it displays current amount of members in the group.
I want to export the amount of members listed there into a column in my Google Sheets, so i do it by using this command:
Code
=IMPORTXML("telegram link i cant paste because im not 50 posts facepalm" ,"//div[@class='tgme_page_extra']")But because class i am importing which is "tgme_page_extra" contains both the number of members and a word "members" Google Sheet won't recognize it as a number. So result in the column looks like "5039 members".
Which means i cannot use basic functions on these exported values like for example sorting from high to low, low to high.
So what i am looking for is any good way to import just a number. It can be a new function for google sheets written from scratch, it can be a fix to my command, it can be any other idea.
I was thinking that maybe, you can just let the command above import it with "members" word into column A.
And then in column B write a function that takes only numbers from column A, and ignore all other signs/letters?
No idea if that would be possible, just an idea i came across.
I'm willing to pay like 15-20$ in Bitcoin/Ethereum for a fix to this.