Unsolved

This post is more than 5 years old

2 Intern

 • 

243 Posts

1705

January 10th, 2011 04:00

Useful tip - replacing a null field

I've a report I am currently writing where it sometimes returns an empty field - this is a list of all data backed up in a particular pool and sometimes the pool field returns blank which doesn't seem right but that is a different problem!  What I want to do is replace the blank field for pool with the text "unknown pool".

I can use the NULL to zero operator and this will replace these fields with 0 so I know these fields are null.  However I want to replace the null field with a string so I use the Search and Replace operator and for a null field I enter in the Search String:

^$

Then in the replace field the text I want to replace this with:

unknown pool

One other point on this operator, I wasted a lot of time because the order the parameters are given are not how you would logically expect them to be arranged!

8 Posts

February 9th, 2016 10:00

Each fields have a possible Null Value that will automatically replace empty/blank cells with anything. In this example, it will replace NULLs with N/A.

Just edit this option on your last operator or data source.

Capture.JPG.jpg

No Events found!

Top