Find Jobs
Hire Freelancers

APP Script - Google sheet

$10-30 USD

Imekamilika
Imechapishwa over 1 year ago

$10-30 USD

Kulipwa wakati wa kufikishwa
I want to split the data on column B to column C Example column B = Hello,World Output: Column B = Hello Column C = World The part of the code [login to view URL]("B" + nextRow).setValue(name); // Want to split this data The full code var ss = [login to view URL]('4D_otVRWtkkNFk_gq2KZpx0ksJuSLTkZkk'); var sheet = [login to view URL]('Sheet1'); var timezone = "asia/qatar"; var hours = 3 ; //MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM function doGet(e){ [login to view URL]( [login to view URL](e) ); //---------------------------------------------------------------------------------- //write_google_sheet() function in esp32 sketch, is send data to this code block //---------------------------------------------------------------------------------- //get gps data from ESP32 if ([login to view URL] == 'undefined') { return [login to view URL]("Received data is undefined"); } //---------------------------------------------------------------------------------- var Curr_Date =new Date(new Date().setHours(new Date().getHours() + hours)); var Curr_Time = [login to view URL](Curr_Date, timezone, 'HH:mm:ss'); var name = stripQuotes([login to view URL]); [login to view URL]('name=' + name); //---------------------------------------------------------------------------------- var nextRow = [login to view URL]() + 1; [login to view URL]("A" + nextRow).setValue(Curr_Date); [login to view URL]("B" + nextRow).setValue(name); // Want to split this data [login to view URL]("D" + nextRow).setValue(Curr_Time); //---------------------------------------------------------------------------------- //returns response back to ESP32 return [login to view URL]("Card holder name is stored in column B"); } //MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM function stripQuotes( value ) { return [login to view URL]().replace(/^["']|['"]$/g, ""); } //MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM //Extra Function. Not used in this project. //planning to use in future projects. //this function is used to handle POST request function doPost(e) { var val = [login to view URL]; if ([login to view URL] !== undefined){ var range = [login to view URL]('A2'); [login to view URL](val); } } //MMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM
Kitambulisho cha mradi: 34311048

Kuhusu mradi

3 mapendekezo
Mradi wa mbali
Inatumika 2 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
$0 USD ndani ya siku 1
4.9 (32 hakiki)
5.0
5.0
3 wafanyakazi huru wana zabuni kwa wastani $25 USD kwa kazi hii
Picha ya Mtumiaji
--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
$50 USD ndani ya siku 1
5.0 (5 hakiki)
3.2
3.2

Kuhusu mteja

Bedera ya SAUDI ARABIA
Jeddah, Saudi Arabia
5.0
1
Njia ya malipo imethibitishwa
Mwanachama tangu Jan 13, 2017

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.