@Dblookup and wildcard

HCL Domino Domino Forum
1

Hi can someone point me in the right direction. Is there a way to use @DBlookup with a wildcards.

I have a budget code 502-7777-777-603

I want to list all the budget codes that have a “502” as for first three digits and a “603”.

Thanks in advance.

2

Subject: @Dblookup and wildcard

No – you’d need to build a view that uses the desired values in the first column. In this case:

@Word(value;“-“1) + “-” + @Word(value;”-”;4)

would give you:

“502-603”

in the first column.

3

Subject: RE: @Dblookup and wildcard

…or you could use an @dbcolumn instead of a @dblookup and apply on a view which displays only the desired data in the SELECT formula.

Nicolas Abesdris

Quintessence e-solutions Inc.

4

Subject: @Dblookup and wildcard

Make the lookup column in your view behave like this:x := @Explode( “502-7777-777-603”; “-” );

a := @Subset( x;1 );

b := “-” + @Subset( x;-1 )

The first line makes the string into a multi-value field.

The next gets the first set of characters as a key in the view.

The last one gets the final set and prepends a “-” so you can know it’s the final item.

Then do something like this for your lookup:

@DbLookup( “Notes”:“NoCache”; “”:“”; “ViewName”; Key1:key2; desired_column_number )

Cnjoy,

Collin

KC8TKA