Working with Google Sheets
Task: find a simplified way to remove the extra lines in a few clicks (e.g. 9 of 10 identical URLs and leave only 1) . It is one domain that is needed to check it.
Or group in a handful of duplicate URLs, for example, so that they were upward, and they didn’t have to search among the 26k lines, and they were already collected.
Ready to listen to all your ways, formulas and ideas to simplify this work.
Applications 1
-
2 days11 USD
84 2 days11 USD
Good Morning, the deep.
I’m a beginner and I’m sure I’ll be able to do this.
I see this as follows (we use the script attached to the table):
Three letters:
The Danny
The result
and removed.
Enter the “data” in the data sheet. Go to the results list. Press the UPDATE button (image to which the script is attached; the image may be any). In the Result list is a list of the desired data. The list is removed - will fall unnecessary - according to your criterion.
… Working through a script is a guarantee of the random failure of the formula.
In terms of value we agree.
-
1 day11 USD
957 19 0 1 day11 USD
Good day ! The solution of the task is quite simple, as we work with the data of the same type. You can remove unnecessary text in the post and find unique domains. Working in two formulas.
Ready to help. The cost will be discussed.
-
1 day11 USD
975 53 3 1 1 day11 USD
Good day ! I can make a script. I will do everything today.
I will be happy to work together!)
-
1 day11 USD
421 13 0 1 day11 USD
Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
1 day11 USD
3628 113 7 1 1 day11 USD
Welcome to
I have a decision for you.
Prepared for the project today.
Write and talk.
-
1 day11 USD
4798 50 1 1 day11 USD
Good day . I have experience with Google Sheets. The task is not difficult, I can do it quickly, I write the code on Python that considers all the data from your table, processes and slows the result into a new sheet, and I can also collect logs that would see how blocks were grouped and how many domains remained.
-
1 day11 USD
5940 345 0 1 day11 USD
With the script in the Google table itself, everything can be solved, you just need to discuss the criterion of line equality. There will be a table with unique links.
-
1 day23 USD
10130 117 0 1 day23 USD
Hello to you.
I’m developing bots for telegram on NodeJS. Ready to take. Let’s write, we will discuss.
-
1 day23 USD
3652 107 0 1 day23 USD
I propose to write a script that will sort all the data into groups and leave in any group only at one address... or will disperse these groups by individual input.
There is also a script that will have a field to enter the text, and when you enter the first letter of the url, the script will filter all 26,000 records and leave only those that start on the letter.
If the filtered records will still be many, then enter the second letter, and the second filtration will occur, but already all the url that starts with two introduced letters.
Three, four and so on. The letter...
-
Доброго дня. Тобто вам потрібно залишити лише по 1 посиланню на кожен з унікальних доменів? Наприклад була таблиця:
https://freelancehunt.com/my/freelancer
https://freelancehunt.com/my
https://freelancehunt.com/mailbox
https://mysite.com/applesТо в кінці має вийти таблиця:
-
Current freelance projects in the category Data Parsing
Parsing company emails from a specific industry
113 USD
Find contacts (e-mail, phone number) of companies engaged in the specified business mentioned in this Google document https://docs.google.com/document/d/1_d-iLxLSL3gjRvo1GmUpWNm0Pm5YoKGcEvaiDc_2I0g/edit?usp=sharing The result should be in the form of a table with the following… Data Parsing ∙ 8 hours 44 minutes back ∙ 22 proposals |
Need a parser for the online store https://www.lcsc.com/It is necessary to regularly (once a month, or upon script launch) obtain up-to-date information about the products available in the store. https://www.lcsc.com/ from the catalog of all sections.… Data Parsing ∙ 1 day 14 hours back ∙ 42 proposals |
OpenCart — rental catalog of special equipment
135 USD
OpenCart — Equipment Rental Catalog Need to launch an equipment rental catalog on OpenCart. Theme: excavators cherry pickers forklifts generators cranes scaffolding other construction equipment. It is preferable that you already have a ready-made template or developments… Web Programming, Data Parsing ∙ 2 days 6 hours back ∙ 58 proposals |
Transfer the program - the server where the program was located has crashed (officially permitted parsing of government data)
46 USD
Hello! My client has encountered the case described below. We need help transferring to a new server and testing the program. It would be better to have a programmer who understands parsing. Software & Server Configuration, Data Parsing ∙ 2 days 10 hours back ∙ 29 proposals |
Website parsingImplementation of 4 parsers (directory websites) is required. There is a technical specification, and there is a code example as a reference. The tasks include: Writing a parser Integrating a proxy Deduplication logic (transfer the logic from the example) Hashing logic based… Data Parsing ∙ 4 days 2 hours back ∙ 44 proposals |
Kyiv