Find Jobs
Hire Freelancers

Modify a google script to run then open a certain sheet

$10-30 AUD

Completed
Posted almost 9 years ago

$10-30 AUD

Paid on delivery
We have a script in Google Sheets, after it runs we want it to open the sheet "Look at Me" Here is the script function importFromCSV() { var ss = [login to view URL](); var osheet = [login to view URL]('Version Information'); var version = [login to view URL](2, 1).getValue(); var url = "[login to view URL] with Physical [login to view URL]"+version; var response = [login to view URL](url); var csvFile = [login to view URL]().toString(); //var csvFile = files[i].getContentAsString(); var csvData = CSVToArray(csvFile, ","); // Replace undefined with blank var ss = [login to view URL](); var sheet = [login to view URL]('Data from Neto'); [login to view URL]().activate(); for (var i = 0; i < [login to view URL]; i++) { for(var k=0; k<csvData[i].length;k++){ var val = csvData[i][k]; if(val == undefined || val == null || val == ""){ csvData[i][k] = ""; } } [login to view URL](i+1, 1, 1, csvData[i].length).setValues(new Array(csvData[i])); } [login to view URL](2, 1).setValue(version+1); } // [login to view URL] // This will parse a delimited string into an array of // arrays. The default delimiter is the comma, but this // can be overriden in the second argument. function CSVToArray( strData, strDelimiter ){ // Check to see if the delimiter is defined. If not, // then default to comma. strDelimiter = (strDelimiter || ","); // Create a regular expression to parse the CSV values. var objPattern = new RegExp( ( // Delimiters. "(\\" + strDelimiter + "|\\r?\\n|\\r|^)" + // Quoted fields. "(?:\"([^\"]*(?:\"\"[^\"]*)*)\"|" + // Standard fields. "([^\"\\" + strDelimiter + "\\r\\n]*))" ), "gi" ); // Create an array to hold our data. Give the array // a default empty first row. var arrData = [[]]; // Create an array to hold our individual pattern // matching groups. var arrMatches = null; // Keep looping over the regular expression matches // until we can no longer find a match. while (arrMatches = [login to view URL]( strData )){ // Get the delimiter that was found. var strMatchedDelimiter = arrMatches[ 1 ]; // Check to see if the given delimiter has a length // (is not the start of string) and if it matches // field delimiter. If id does not, then we know // that this delimiter is a row delimiter. if ( [login to view URL] && (strMatchedDelimiter != strDelimiter) ){ // Since we have reached a new row of data, // add an empty row to our data array. [login to view URL]( [] ); } // Now that we have our delimiter out of the way, // let's check to see which kind of value we // captured (quoted or unquoted). if (arrMatches[ 2 ]){ // We found a quoted value. When we capture // this value, unescape any double quotes. var strMatchedValue = arrMatches[ 2 ].replace( new RegExp( "\"\"", "g" ), "\"" ); } else { // We found a non-quoted value. var strMatchedValue = arrMatches[ 3 ]; } // Now that we have our value string, let's add // it to the data array. arrData[ [login to view URL] - 1 ].push( strMatchedValue ); } // Return the parsed data. return( arrData ); }
Project ID: 8265841

About the project

2 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
If I understand your request, you just want it to go to a certain sheet after this script has run correct? Let me know and I can work with you again. It was a pleasure. Thanks!
$30 AUD in 3 days
5.0 (1 review)
0.7
0.7
2 freelancers are bidding on average $25 AUD for this job
User Avatar
Aucune proposition n'a encore été fournie.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
St Peters, Australia
4.8
18
Payment method verified
Member since Mar 23, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.