キャンセル
次の結果を表示 
次の代わりに検索 
もしかして: 

Find string

Hello!

 

It seems like a simple problem, but I am stuck:

I have a string array and I want to search each cell for a certain substring:

 

house

bed

Profile "something"

car

whatever

EndProfile

GlobalProfile

 

I want to find out in which row the substring "Profile" appears (at the beginning). As the string that comes after "Profile" always changes, I cannot compare the whole string. If I find a row with the word "Profile" then I want to have the index of that row. I don't want to divide any strings, I just need said index.

 

Can someone please help me?

 

Edit:

I have tried to compare strings using an asterisk, but if I search for "Profile*" then it doesn't find anything.

0 件の賞賛
メッセージ1/4
3,693件の閲覧回数

Use a For Loop to index each element individually and use Match Pattern inside to find the string with "Profile".  The loop count when you find it is your index.

Jim
You're entirely bonkers. But I'll tell you a secret. All the best people are. ~ Alice
For he does not know what will happen; So who can tell him when it will occur? Eccl. 8:7

0 件の賞賛
メッセージ2/4
3,684件の閲覧回数

Hi

 

 

You need to look at the match pattern VI or regular expression VI and learn about pattern matches simple example

 

Example_VI_BD.png

 

 

Danny Thomson AshVire Ltd
0 件の賞賛
メッセージ3/4
3,681件の閲覧回数

you beat me to it Jim 🙂

Danny Thomson AshVire Ltd
0 件の賞賛
メッセージ4/4
3,679件の閲覧回数