pinto106
New User
Jul 20, 2011, 7:13 AM
Post #1 of 3
(10509 views)
|
|
HELP Deleting Certain Number of Characters
|
Can't Post
|
|
Suppose I have a data file which looks like this EX:
290611, 201917, 4304.3195, N, 07042.6893, W (line 1)
290611, 201911, 4304.319, N, 07042.688, W (line 2)
290611, 201918, 4304.31904, N, 07042.68844, W (line 3)
290611, 201916, 4304.3196, N, 07042.6893, W (line 4)
Notice that in the third column, (the 4304....) either has 3,4 or 5 decimal places, or 8,9, or 10 characters (4304.3195 has 9 characters).
I need a program that will say if column 3 is not 9 characters then ignore the entire line. So in the ex above it should ignore lines 2 and 3 completely, because for instance line 2, column 3 has 10 characters, and line 3, column 3 has only 8 characters
*Ignore spaces between columns as characters that was only so it was easier to understand. Normally theres no spaces, a line looks like
290611,201916,4304.3196,N,07042.6893,W
|
MAIN
SEARCH
WHO'S 
LOG 