Appscript Google spread sheet
$10-30 USD
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);
}
}
Projekt-id: #34311027
About the project
6 frilansare har lagt bud på i genomsnitt $27 för det här jobbet
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
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
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