Tech Tip!

Suppose your data has a series of attributes that correspond to - say - lines on an order, or lines on a call log, or maybe lines on a time sheet.

You want to display the line number beside the other data.

"LINE" will do the trick assuming that attribute 1 is part of that data.

LINE
001 S
002 0
003 Line
008 F;1;NV
009 R
010 2

If you just need a count of the "lines" referenced by the multi-value data in attribute 1, then "CTR" will do that for you.

The assumption is that there are no null elements in attribute 1.

CTR
001 S
002 0
003 Count
008 F;1;C;#;S
009 R
010 7
 

This Tips was derived from Tom Phillips. He has lot of more samples like this at http://www.tom-phillips.info

menu
menu