Delete empty fields with notepad

zyllycarmy

hello guys, I appeal to you, how could I eliminate those empty fields with notepad

to

Terry R

@zyllycarmy
I think your example went a bit awry as the results don’t exactly match the originals.i.e.
0.0.0.206 becomes 0.0.0.209
P_45 = 009 becomes P_2 = 009
Happy Birthday = remains where your request was for this to be removed

But if I read your request correctly you want any field having no data after the “=” sign is to be removed. Also any email field without an actual email address is also to be removed.

So my regex (regular expression) is
Find What:([^|]+?= \|)|\h*email: \|
Replace With:<empty field> <—nothing in this field

It will grab characters so long as a | is not found and followed by the = sign, a space and the | character. Alternatively it will find a space (optional, 0 or 1) followed by email: and another space and then the | character, thus no actual email address.

See if this helps you. Come back to us regardless and let us know how you went and if you need further help.

The regex needs the Replace function set as ‘regular expression’ search mode and have the ‘wrap around’ ticked.

Terry

Scott Sumner

@zyllycarmy

Your example doesn’t really make sense…P_45 in the before text changes to P_2 in the after text, although that doesn’t fit the classification of “eliminate those empty fields”. And your IP address changes. And…Happy Birthday = remains in the after text although one would think it should be eliminated by the specification.

zyllycarmy

@Terry-R

zyllycarmy

thank you very much helped me, sorry for the error, is that I’m with my baby taking care of it and working at the same time, solve the problem, thank you very much