Appscript Google spread sheet

Stängt Publicerat 1 år sedan Betalades vid leverans
Stängt Betalades vid leverans

I want to split the data on column B with delimiter data to column C

For example

Column B = Name, 1234

SPLIT so output is

Column B= Name

Column C = 1234

Code im working on is

var ss = [login to view URL]('1D_oE-3VRWNxwVZ08SLTIByTZ8k');

var sheet = [login to view URL]('Sheet1');

var timezone = "asia/qatar";

var hours = 3 ;

//

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); // i want to split this to C

[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);

}

}

Google Spreadsheets C-programmering JavaScript

Projekt-id: #34311027

About the project

6 offerter Distansprojekt Aktivt 1 år sedan

6 frilansare har lagt bud på i genomsnitt $27 för det här jobbet

furkanjl

Hi, I understand that you're looking for someone who can create a function that will split the text on one cell into two different cells using a delimiter. I have experience with Google Apps Script and I can do this j Mer

$25 USD inom 1 dag
(34 omdömen)
5.6
sriraghav384

Hi, Please provide the Excel Sheet that needs to be splitted. I can provide solutions. after a long years bidding in Freelance Project. Looking forward for your response. I can complete it

$20 USD inom 2 dagar
(4 omdömen)
2.2
adam7patrick

Hello, Dear Hiring Manager I have read your requirements carefully. I am expert in Javascript *** High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. *** I can start working rig Mer

$20 USD inom 2 dagar
(0 omdömen)
0.0
abdulsdeveloping

It seems that you need to split the data coming from the ESP32 module and assign each piece to a separate variable and eventually adding the vars to their respected columns. This should be fairly easy, let's chat

$25 USD inom 7 dagar
(0 omdömen)
0.0