Notepad ++ replace empty cell white spaces with NA

Question

I would like to replace empty cells with NA in Notepad ++ The empty cells are not showing here, but I would like to fill in the empty spaces with NA.

Sample data set:

15876346,71F,70152731459,H,2.3,6,14,31

18334617,82F,7015273698,C,1.2, , ,21

42190557,01F,7015273,C, , ,21,57

Desired output:

15876346,71F,70152731459,H,2.3,6,14,31

18334617,82F,7015273698,C,1.2,NA ,NA ,21

42190557,01F,7015273,C,NA ,NA,21,57

are they always space separated ? then try replace with an regexp [ ](?=[ ]) an replace it with space and NA — MBobrik, Dec 20 '21 at 18:28
Isn't just a global search-and-replace of `,,` with `,NA,` going to solve this? — Tim Roberts, Dec 20 '21 at 19:52
Does this answer your question? [Reference - What does this regex mean?](https://stackoverflow.com/questions/22937618/reference-what-does-this-regex-mean) — AdrianHHH, Dec 20 '21 at 22:21

score 0 · Answer 1 · answered Dec 21 '21 at 09:14

Ctrl+H
Find what: (?<=,)\h*(?=,)
Replace with: NA
CHECK Match case
CHECK Wrap around
CHECK Regular expression
UNCHECK . matches newline
Replace all

Explanation:

(?<=,)      # positive lookbehind, make sure we have a comma before
\h*         # 0 or more horizontal spaces
(?=,)       # positive lookahead, make sure we have a comma after

Screenshot (before):

Screenshot (after):

Notepad ++ replace empty cell white spaces with NA

1 Answers1