Guest User

Untitled

a guest
Jul 16th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. 8504.40.9031 9403.70.0000
  2. 8504.40.9090 9403.70.8031
  3. 8504.40.9510 9403.70.9000
  4.  
  5. 8504409031 9403700000
  6. 8504409090 9403708031
  7. 8504409510 9403709000
  8.  
  9. function appendString() {
  10. var range = SpreadsheetApp.getActiveSheet().getActiveRange();
  11. var numRows = range.getNumRows();
  12. var numCols = range.getNumColumns();
  13. var writeValues = []
  14. for (var i = 1; i <= numRows; i++) {
  15. var row = []
  16. for (var j = 1; j <= numCols; j++) {
  17. var currentValue = range.getCell(i,j).getValue();
  18. var withString = currentValue.toString().replace(".","");
  19. row.push(withString)
  20. }
  21. writeValues.push(row)
  22. }
  23. range.setValues(writeValues)
  24. }
  25.  
  26. 850440.9031 940370
  27. 850440.909 940370.8031
  28. 850440.951 940370.9
Add Comment
Please, Sign In to add comment