Welcome Guest | My Membership | Login

More MultiValue Database and Products Articles...

Tech Tip!

Value Mark Counter Dictionary item. Add Line numbers or count the number of MultiValues you have in a field from a list statement.

 

 

Twitter Button from twitbuttons.com

Release Date: Friday, May 01, 2009

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

 

# # #          # # #          # # #

 

Related Articles:


Return to top