
pinto106
New User
Jul 20, 2011, 7:13 AM
Post #1 of 3
(10172 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
|