Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak
Post your project for free and start getting offers from freelance performers within minutes after posting!

Remove extra numbers from the Excel column

Translated5 USD

Client's feedback on cooperation with Yurii P.

Quality
Professionalism
Price
Availability
Terms

Fast, quality, clear and without any more questions. Thank you for help.

Freelancer's feedback on cooperation with Aleks Paranyuk

Payment
Task formulation
Requirements
Availability

thank you.
Fast payment and immediate check.
I recommend cooperation.

The client does not want to make a prepayment? Payment via Safe help avoid possible fraud.
  • Roman Gural
    1 February 2020, 15:45 |

    Заменить: (*) на пусто?

  • Aleks Paranyuk
    1 February 2020, 15:46 |

    пробовал, выдает ошибку

  • Aleks Paranyuk
    1 February 2020, 15:47 |

    image

  • Profile deleted
    1 February 2020, 15:52 |

    Notepad++ замена с помощью регулярных выражений, сделаешь за пару секунд, потом просто вставишь обратно. что-то типа \(\d*\) такого будет надо заменить на пустое место. 

  • Profile deleted
    1 February 2020, 15:53 |

    Но и в экселе можно прикрутить регулярки, только я честно говоря не помню в подробностях как именно это сделать.

  • Profile deleted
    1 February 2020, 15:55 |

    Если в тексте скобки больше нигде не встречаются, можешь в самом экселе разделить колонку с текстом по символу "(" например. Получишь две колонки - с текстом и с выражением в скобках

  • Profile deleted
    1 February 2020, 15:55 |

    Если в тексте скобки больше нигде не встречаются, можешь в самом экселе разделить колонку с текстом по символу "(" например. Получишь две колонки - с текстом и с выражением в скобках

  • Oleksandr Sudak
    1 February 2020, 16:02 |

    Пришлите файл Ексель.

    5-7 минут и будет сделано.

  • Oleksandr Sudak
    1 February 2020, 16:07 |

    =ЛЕВСИМВ(СЖПРОБЕЛЫ(A2);ПОИСК("`";ПОДСТАВИТЬ(СЖПРОБЕЛЫ(A2);" ";"`";ДЛСТР(СЖПРОБЕЛЫ(A2))-ДЛСТР(ПОДСТАВИТЬ(СЖПРОБЕЛЫ(A2);" ";""))))-1)

Current freelance projects in the category Data processing

[TM] BA Analyst - create 30 SQL queries for dataset

120 USD

Good day, there is a dataset consisting of 3 tables, need to create 30 SQL queries for it. Domain - ecommerce 5 simple queries for each table 2 complex queries with aggregations for each table 4 queries for table pairs with aggregation 5 queries for all tables at once I need…

DatabasesData processing

Automation needs to be done on make com (GPT + TG + Notion)

Hello everyone, some automation needs to be done: 1. send a json file with the task to telegram (the file will have the same keys in json format) 2. Process the json in make com 3. Create the corresponding task in the respective teamspace in Notion Who has experience and…

Machine learningData processing

Add website names and contact emails to the table.

13 USD

There is a list of 278 media websites. It is necessary to add to the table the name of the media outlet to which each website belongs, as well as the contact email from the website. Simple task for 3 hours. Specify the price and time of completion. I will send the list of…

Data processing ∙ 17 proposals

Data table formatting and RFM analysis

1. The CRM table of all customer orders has been exported. It needs to be formatted in such a way that it becomes convenient for reading and working. The following columns should be included: customer (full name), phone number, total number of orders, date of the last order,…

DatabasesData processing ∙ 6 proposals

Restoring access to Google account

13 USD

Unable to log in to Google account. Google states a reason, as if there was some suspicious activity. I pass all checks, but when the field for entering the phone number appears, it says that this number cannot be used for login. And this happens with any number.

Data processingCustomer support ∙ 3 proposals

Client
Aleks Paranyuk
Ukraine Kyiv  30  0
Project published
4 years ago
118 views