Skip to Content
0
Nov 27, 2017 at 11:02 AM

Complex Table search and set as initial value

91 Views

All,

I have a requirement to search for a value ending with 'N' in a complex table. If the count of values ending with 'N' is more than 1, user to select the value from Complex table search drop down. If CT has only one value ending with 'N' then I need to set as initial value which is ending with N. I looked into RFind function which gives a sub string. How do i do it using a Regular expression using JavaScript.

Sample values in CT

Condition 1, More values ending with N. User will select from Complex table.

ACCOON

LWDXNN

LWDXNO

LWTXNN

Condition 2, only 1 value is ending with N, which should be defaulted in transaction screen.

LWDXNN

LWDXNO

Request to guide in achieving this.

Thanks in advance.