817 reputation
1722
bio website code.google.com/p/…
location Westminster, CO
age 29
visits member for 4 years
seen May 6 at 4:42

I'm passionate about coding and researching the history of technology as well as exploring where technology is leading.

I used to work in flight simulation doing both hardware implementation (electrical design, wiring), web development (design, development, webmaster), as well as software development (desktop development in C#).

I'm a big fan of both using and contributing to Open source projects.

I am the creator of the pypreprocessor library that can be found on PYPI as well as Google code.


2d
awarded  Yearling
Mar
28
awarded  Famous Question
Jan
16
awarded  Nice Answer
Dec
9
awarded  Nice Question
Jul
7
awarded  Yearling
May
6
awarded  Popular Question
Feb
8
comment Text to columns conversion in Google Spreadsheets
@bobesponja Thanks for the heads-up. I know there's a bug with Google Scripts where event triggers from imported scripts don't register properly. To fix it, just add the onOpen trigger manually.
Feb
1
comment Text to columns conversion in Google Spreadsheets
@JacobJanTuinstra In your first solution try copying B2 to B3. The result cells contain continuation formulas, not raw data. The cells outputted from the script contain the actual raw data so they can be copied/moved without any issues. The intent of this question is to find an equivalent to Excel's 'Text to Columns' feature. Until, Google officially adds support the script is as close as it's going to get.
Feb
1
revised Text to columns conversion in Google Spreadsheets
deleted 1281 characters in body
Jan
31
comment Text to columns conversion in Google Spreadsheets
@JacobJanTuinstra Because the capability can be added via Google Apps Scripting. I ended up solving my own problem by writing a 'Text To Columns' script that can now be found in the Script Gallery. Googlegooru also posted a video tutorial demonstrating its usage here googlegooru.com/text-columns-google-spreadsheets.
Jan
31
accepted Text to columns conversion in Google Spreadsheets
Jan
3
awarded  Notable Question
Dec
14
awarded  Self-Learner
Dec
7
revised Text to columns conversion in Google Spreadsheets
added 85 characters in body
Dec
7
revised Text to columns conversion in Google Spreadsheets
added 85 characters in body
Nov
30
revised Text to columns conversion in Google Spreadsheets
added 106 characters in body
Nov
29
revised Text to columns conversion in Google Spreadsheets
added 229 characters in body
Sep
5
comment How can I avoid sites that scrape and republish others?
@Basilevs lol, I'm glad I could help.
Jul
10
awarded  Popular Question
Jul
7
awarded  Yearling