Line with Pilcrow only

[datalink]

In a multi-key field which is delimited with hard returns we have a number of lines with only the hard return because of an import process.

I want to run a calculated fill down to strip out the lines that have only the delimiter and no actual data.

I was thinking I'd use the substitute function to substitute the hard return with "", but I'm not sure how to get just the empty lines.

[comment]

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/199290/