Pipe delimited file download

Basically, I want to create a time-driven script to run on a Google spreadsheet to save it as a. Right now I manually download it as. I want to automate this for myself but also for another user to get that final. Most importantly, I want this to be able to be run without user input or active workstations it's supposed to be run on a Sunday morning so it has to be in a time-triggered Google Apps Script.

I have very little JavaScript experience, so the only solution I can think of is two nested for loops sheetID and sheetName withheld :.

And then a small script to email the newFile to the other user haven't wrote that part yet but I see plenty of solutions on google so don't worry about the emailing portion. Even if it does work it would eat up far too much of my Google Apps Script quota for triggered scripts. I'm sure I've gone the absolute wrong direction with this. Please help? Even just where to begin would be greatly appreciated. I can't share the actual file, only a dummy copy, but I'm pretty sure the solution shouldn't be content-specific?

Aside from the fact that there are no comma's or pipes anywhere in the original file data, only a mix of text and numbers if that helps? To remove empty lines and cells outside the table you can apply replace method to the string variable:. This is a simpliest solution. But beware, the replace method will get you wrong result in case your table has emply cells inside.

It's need a more complicated algorithm to keep inner empty cells intact. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you.

Once you have received the verification code, you will be able to choose a new password for your account. About Us Our team. Save an Excel file as pipe delimited file Save an Excel file as pipe delimited file To save an Excel workbook as a pipe delimited file, please do as follows. See screenshot: 3. See screenshot: 5. Hide Private Photos on iPhone. Take Screenshot by Tapping Back of iPhone.

Should You Upgrade to Windows 11? Windows Default Browser Workaround. Browse All Windows Articles. Windows 10 Annual Updates. OneDrive Windows 7 and 8.

Copy and Paste Between Android and Windows. Protect Windows 10 From Internet Explorer. Mozilla Fights Double Standard. Connect to a Hidden Wi-Fi Network. Change the Size of the Touch Keyboard. Check Bluetooth Device Battery Life. Reader Favorites Take Screenshot on Windows. Asked 7 months ago. Active 7 months ago. Viewed times. You have to use getRange. For all cells on the sheet, probably. And then you can process the 2D-array well, it can be a classic nested loop, why not?

I see, thank you. If I understand correctly my issue isn't with the nested for loops but the fact that with each iteration I was calling the getValue function again, which is more intensive than checking an array value. I appreciate it! Add a comment.

Active Oldest Votes. In: Out:. Yuri Khristich Yuri Khristich 7, 1 1 gold badge 5 5 silver badges 21 21 bronze badges.

I really appreciate the help. This did work, but it also pulled several blank rows with it the rows were represented as just a series of pipes like so " ". Is there a way to avoid that using the range.