# Array IndexOf()

**URL:** https://community.tulip.co/t/array-indexof/6810
**Category:** Product Suggestions
**Created:** [November 3, 2022, 6:26am UTC](https://community.tulip.co/t/array-indexof/6810 "2022-11-03T06:26:44Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![youri.regnaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/youri.regnaud/32/2917_2.png) [@youri.regnaud](https://community.tulip.co/u/youri.regnaud)
#### Post date: [November 3, 2022, 6:26am UTC](https://community.tulip.co/t/array-indexof/6810/1 "2022-11-03T06:26:44Z")

</div>

Is there already a kind of IndexOf() function to find index for a specific value in a simple or complex array?

---

<div class="post-metadata">

### Author: ![thorsten.langner](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@thorsten.langner](https://community.tulip.co/u/thorsten.langner)
#### Post date: [November 3, 2022, 8:49am UTC](https://community.tulip.co/t/array-indexof/6810/2 "2022-11-03T08:49:14Z")

</div>

Hi @youri.regnaud ,

I hope that helps:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/3/3ac24dffc60f3eef9235613e1054a096c2672fa4.png)

---

<div class="post-metadata">

### Author: ![youri.regnaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/youri.regnaud/32/2917_2.png) [@youri.regnaud](https://community.tulip.co/u/youri.regnaud)
#### Post date: [November 3, 2022, 1:30pm UTC](https://community.tulip.co/t/array-indexof/6810/3 "2022-11-03T13:30:50Z")

</div>

Thanks, Do you know if you can use regex if a value match a regex expression?

---

<div class="post-metadata">

### Author: ![thorsten.langner](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@thorsten.langner](https://community.tulip.co/u/thorsten.langner)
#### Post date: [November 3, 2022, 2:38pm UTC](https://community.tulip.co/t/array-indexof/6810/4 "2022-11-03T14:38:44Z")

</div>

HI @youri.regnaud ,

this will deliver all matches as an Array:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/f/f4447add07f55066517a930ed1bfba2a87b423e1.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/e/ee1b70d36c14e8b778c7d294bd53bff729ba6c5a.png)

Does this help?

Edit:

To check if its a total match you could build something like this (this checks if only capital letters are used):

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/e/e7dfbd544f56a112469951cfc66e5c826cab61cf.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/7/7dfbddf2060573b75e5753b7dfe6a6156708e823.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/b/bf03b6e3371c49549b33effa1e39d3fdac3de9e2.png)

Maybe thats something for an custom widged, if you need this more often.

---

<div class="post-metadata">

### Author: ![youri.regnaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/youri.regnaud/32/2917_2.png) [@youri.regnaud](https://community.tulip.co/u/youri.regnaud)
#### Post date: [November 3, 2022, 3:10pm UTC](https://community.tulip.co/t/array-indexof/6810/5 "2022-11-03T15:10:22Z")

</div>

My question was more if i can find index in an array that match a regex expression. Thanks for your help

---

<div class="post-metadata">

### Author: ![thorsten.langner](https://avatars.discourse-cdn.com/v4/letter/t/4bbf92/32.png) [@thorsten.langner](https://community.tulip.co/u/thorsten.langner)
#### Post date: [November 3, 2022, 4:57pm UTC](https://community.tulip.co/t/array-indexof/6810/6 "2022-11-03T16:57:19Z")

</div>

You could send it to a connector function and let the connector solve the issue (here looking for an “e” at the end with at least 4 leading characters):

 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/e/e18484056d4172d11b9d805be3210e1782f6b361.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/2/28ec31d468a7f815842b5868433667ab612c0f34.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/1/13eabf596d3f1824a0f9b9a1016c1b43822972db.png)

I guess in most cases the “like” without regex is best (I added some examples as comments in the SQL…)

But maybe a custom widget is the best solution here?

---

<div class="post-metadata">

### Author: ![mia02](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/mia02/32/6581_2.png) [@mia02](https://community.tulip.co/u/mia02)
#### Post date: [February 12, 2024, 8:02am UTC](https://community.tulip.co/t/array-indexof/6810/7 "2024-02-12T08:02:36Z")

</div>

I also try this :

 ![ee1b70d36c14e8b778c7d294bd53bff729ba6c5a](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/7/707285eadd08dd171999af947d8922700777c3bb.png)