|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
11-11-2006, 05:10 PM
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
need tool to eliminate extra space at end of line or excel colum
I have a bunch of extra spaces at the end of lines that I need gone, is there a tool to do this?
Example dsalfjsdf dsfjsfsdlfj sdaufjlsdjaf jfsdlfjsdf |
|
|
|
11-11-2006, 05:20 PM
|
#2 | |
|
Confirmed User
Join Date: Oct 2003
Posts: 3,191
|
Quote:
if lines are same length it is easy: use column mode with this utility: ultra-edit32 |
|
|
|
|
|
11-11-2006, 05:27 PM
|
#3 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
they are all different lengths
|
|
|
|
|
11-11-2006, 05:32 PM
|
#4 |
|
Confirmed User
Join Date: Nov 2005
Location: Metro Detroit
Posts: 748
|
if its just the column... paste it into a text file, shen on a mac or linux box, or if you are shelled into your host, you can run this command on the text file you pasted the column into.
sed 's/[ ^t]*$//' YOUR_TEXT_FILE then paste the output back into the native app... |
|
|
|
|
11-11-2006, 05:41 PM
|
#5 |
|
Let slip the dogs of war.
Industry Role:
Join Date: Jan 2003
Location: Bermuda
Posts: 17,263
|
Built in function in Excel "trim()". Simple, simon.
__________________
. |
|
|
|
|
11-11-2006, 05:44 PM
|
#6 | |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
Quote:
How do i enter that? I suck at excel |
|
|
|
|
|
11-11-2006, 06:09 PM
|
#7 | |
|
Let slip the dogs of war.
Industry Role:
Join Date: Jan 2003
Location: Bermuda
Posts: 17,263
|
Quote:
Create a second column beside it, or use an empty one that exists. For our purposes we'll call it Column B. 1) In the first cell of Column B (Cell B1) enter the following "=trim(a1)" 2) Highlight this cell and all the cells below it that correspond with data that needs to be trimmed. Say you have 71 rows of data, you will highlight Cells B1-B71 and press CTRL-D (This is the copy down command). This will copy your formula all the way down, but fill in the cells correctly. For example, cell B2 will have the forumla trim(a2) and etc all the way down. You're not done yet, because the new data is formula based, so if you delete column A, the data will vanish in column B as there's nothing to base the formulas on anymore. Not to worry. 3) Select all of column B, and press CTRL-C (Copy). 4) With all of columb B still highlighted, right click on it and select "Paste Special". Select the third radial button down "Values" and press OK. Now all of Column B is populated with the trimmed data and is no longer based on a formula. 5) Delete the original Column, Column A. You're done.
__________________
. |
|
|
|
|
|
11-11-2006, 06:10 PM
|
#8 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
whooohooo, thx
 |
|
|
|
|
11-11-2006, 07:17 PM
|
#9 |
|
Confirmed User
Industry Role:
Join Date: Feb 2003
Location: Australia
Posts: 9,492
|
trim is da shit!!
__________________
 Blue Design Studios - Adult Design Specialists! Email me for a free quote: [email protected] |
|
|
|
