Find Jobs
Hire Freelancers

APP Script - Google sheet

$10-30 USD

Fullført
Lagt ut over ett år siden

$10-30 USD

Betalt ved levering
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
Prosjekt-ID: 34311048

Om prosjektet

3 forslag
Eksternt prosjekt
Aktiv 2 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
Tildelt til:
Brukeravatar
$0 USD om 1 dag
4,9 (32 omtaler)
5,0
5,0
3 freelancers are bidding on average $25 USD for this job
Brukeravatar
--------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 om 1 dag
5,0 (5 omtaler)
3,2
3,2

Om klienten

SAUDI ARABIAs flagg
Jeddah, Saudi Arabia
5,0
1
Betalingsmetode bekreftet
Medlem siden jan. 13, 2017

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.