Skip to Content
0
Former Member
Mar 06, 2015 at 07:56 PM

Covert a comma string into separate rows

33 Views

Hi,

I have a scenario where I have to convert the below into separate distinct list -

Messages Image(932171456) copy.png

I need to convert into the below format

NPE-University

NPE-Inventor

NPE-Company

NPE-Patent Aggregator

Op Co-Competitor

Op Co-Licensing

NPE-Co/Inv

OpCo-G2k

OpCo-Other

There could be two scenarios for that -

1. This can be modified using the custom LOV (as I need the distinct separate values to display in the prompt for user)

2. This can also be changed into a new column that displays distinct separate values

Your help is really appreciated!! Thanks!