What is regex (lookup)? When you should use it?

Question Posted / uday

3 Answers
14893 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is regex (lookup)? When you should use it?..

Answer / rajat singh

In a regex lookup operation, each record in the lookup file must contain a regular expression in the format described in “Regular expressions in DML functions”. The regex key specifier of a regex lookup file identifies the record field to interpret as a regular expression.
A lookup function such as lookup (file_label , expression) tests the value of its second argument against the regular expression field in each record of the lookup file, until the function finds a match.

Is This Answer Correct ?

3 Yes

0 No

What is regex (lookup)? When you should use it?..

Answer / prakash balakrishnan

In INTERVAL LOOKUP we will be defining certain range of
values like 0 - 10 , 10 - 20. Similarly in regrex lookup we
will be defining values like 0|1|2|3

Is This Answer Correct ?

1 Yes

2 No

What is regex (lookup)? When you should use it?..

Answer / ramakrishna

lookup is also similar to join.. by using the following
syntax we will fetch the info from lookup

lookp("looupfilename",conidition).field want to fecth from
lookup

Is This Answer Correct ?

1 Yes

8 No

Post New Answer