Fermé

Appscript Google spread sheet

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

}

}

Compétences : Google Spreadsheets, Programmation C, JavaScript

Concernant le client :
( 2 commentaires ) Tabuk, Saudi Arabia

Nº du projet : #34311027

6 freelances font une offre moyenne de 27 $ pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(34 Commentaires)
5.6
(32 Commentaires)
5.0
(13 Commentaires)
4.8
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0