Hi
I want to obtain field2 based on the the subsequent values of a field 1 using as reference field1 value from where Flag exists (example table below)
I tried Field2=Wildmatch (Field1,Field1&'*') but did not work. Any thoughts?
Thank you
Field 1 |
Flag |
Field2 |
1! |
|
|
1!2! |
|
|
1!2!3! |
X |
1!2!3! |
1!2!3!4! |
|
1!2!3!4! |
1!2!3!4!5! |
|
1!2!3!4!5! |
2! |
|
|
2!3! |
|
|
2!3!4! |
X |
2!3!4! |
2!3!4!5! |
|
2!3!4!5! |