I have around 2 million of rows need to find all the empty rows.
AKRAM AHMED
SSYED Aakram ahmed
(need to find this empty row)
james hetfield metallica
Asked
Active
Viewed 102 times
0
-
Using which program/technology? – noone Aug 21 '13 at 11:23
-
what language are you coding in? – pythonian29033 Aug 21 '13 at 11:23
-
line1 (spaces)AKRAM(feild lenght for akram is say 15spaces,5 already used so after 10 spaces its ahmed)AHMED – akram Aug 21 '13 at 11:32
-
I have fixed length file – akram Aug 21 '13 at 11:32
-
AKRAM AHMED SSYED Aakram ahmed (need to find this empty row) james hetfield metallica – akram Aug 21 '13 at 11:34
-
if you read the file line by line, test each line with the regular expression `^[[:space:]]*$`. – collapsar Aug 21 '13 at 11:55
-
it doesnt seem to work – akram Aug 21 '13 at 13:08
-
After syed they are spaces! so if use a regexp then it finds this space! but what I need to find is that one empty row! – akram Aug 21 '13 at 13:11
2 Answers
1
Search for this regex : \\n\s*\\n
It will search for lines containing only white spaces or nothing.
Mostafa Elgaafary
- 1,552
- 2
- 13
- 11
-
I believe you don't need to double escape the new line: `\n` should be enough. – sp00m Aug 21 '13 at 11:31
