Find index position of a string in an array

Question

Hi,I’m easily able to return the value of a string in an array by it’s index position with the FIND function.e.g. if array = [“hello”,”World”]FIND(array,1) = “hello” However, i’m struggling to understand how to do the inverse - finding the index position of a string in an array by the value of the string:e.g. if array = [“hello”,”World”]‘STRINGFIND’(array,”hello”) = 1I’m sure this is quite simple and I’m just missing the correct function.Thanks!

Ian Baenziger · Answer

HiJoshJefferis!At this time, we actually do not offer an out-of-the-box function for finding the index position of astring in an array. There is a very “hacky” way to do this though:=ASARRAY(FILTER(MAP(@Haystack, x => IF(x = @Needle, x.index, NONE)), x => x != NONE))[1]Note that this returns#ERROR!if an item isn't found. It can be wrapped inIFERRORto provide a default value like-1.Also, you posted in the developer forum, so I am wondering if there are other tools at your disposal.Are you building an extension using our Extension API? If so, we may have a few other levers. If not, then the formula above is the best solution available we can think of.Thanks!Ian

Create an account in the community

Log in to the community