I am extracting some data from the database.
Theses are four fields i.e. 1,2,3,4 which should have a value+unit as shown below.the fifth field i,e. 5 carries just the unit.
I want that if the fields are blank it should not report anything. In this case it reports a unit.
And if the field has a value it should report the value as well as the unit.
How to do it?
1. value field||'~'||unit field ||','||
2. value field ||'~'||unit field ||','||
3. value field ||'~'||unit field ||','||
4. value field ||'~'||unit field ||','||
5. unit field||','||