Find position of text string in larger string

8. RE: Find position of text string in larger string

Like

Jonathan Heuer

Posted 12 days ago

Neil I'm sure I didn't clearly explain. Once I search for "V23" and obtain it's position, I'll ultimately want to get the value after the hyphen, "4072". But if I can find "V23" in the larger string, I'm fairly confident that I can extract the part after the hyphen.

------------------------------
Jonathan Heuer
------------------------------

Original Message

Original Message:
Sent: 09-16-2020 14:26
From: Neil Schneider
Subject: Find position of text string in larger string

Jonathan,
I probably misunderstood the question. The formula field would return the actual value if the value is found in the string. The example returns "V23-4072", did you need the index of the value?

------------------------------
Neil Schneider

Original Message:
Sent: 09-16-2020 10:58
From: Jonathan Heuer
Subject: Find position of text string in larger string

Thanks Neil- yep I know about Contains. The problem is I need to extract the actual value from the text string, not just whether it's there or not.

------------------------------
Jonathan Heuer

Original Message:
Sent: 09-16-2020 10:53
From: Neil Schneider
Subject: Find position of text string in larger string

If you only want to know if the summary field contains the value you are looking for (and don't need the index in the array), this should do it..
var text data = "V102-136 ; V23-4072 ; V8-25";
var textList dataList = Split($data, ";");
var text field = "V23-4072";
var bool hasField = Contains($dataList, $field);

If ($hasField, $field, "notfound")

------------------------------
Neil Schneider

Original Message:
Sent: 09-15-2020 23:09
From: Jonathan Heuer
Subject: Find position of text string in larger string

I have a long string in my Services table, the result of a Combined Text Summary field, each element takes the pattern V###-#### (where the number parts of the string are arbitrary length). For example :

V102-136 ; V23-4072 ; V8-25

I want to create a formula which extracts correct element in this array, based on the value in another field, and I could do it if I knew the position in the text string of the "V" value. So if there were a function Find which returned the position of a text string, that would do it. Something like

Find([Summary Field", "V" & [Text string to search for])

I can't find a function to do this. Functions like left just search for single characters, and I need to search for a longer string. Ideas?

------------------------------
Jonathan Heuer
------------------------------

9. RE: Find position of text string in larger string

Like

Mark Shnier (YQC)

Posted 12 days ago

..Jonathan, was there a problem with using my solution an an approach?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Original Message

Original Message:
Sent: 09-16-2020 15:14
From: Jonathan Heuer
Subject: Find position of text string in larger string

Neil I'm sure I didn't clearly explain. Once I search for "V23" and obtain it's position, I'll ultimately want to get the value after the hyphen, "4072". But if I can find "V23" in the larger string, I'm fairly confident that I can extract the part after the hyphen.

------------------------------
Jonathan Heuer

Original Message:
Sent: 09-16-2020 14:26
From: Neil Schneider
Subject: Find position of text string in larger string

Jonathan,
I probably misunderstood the question. The formula field would return the actual value if the value is found in the string. The example returns "V23-4072", did you need the index of the value?

------------------------------
Neil Schneider

Original Message:
Sent: 09-16-2020 10:58
From: Jonathan Heuer
Subject: Find position of text string in larger string

Thanks Neil- yep I know about Contains. The problem is I need to extract the actual value from the text string, not just whether it's there or not.

------------------------------
Jonathan Heuer

Original Message:
Sent: 09-16-2020 10:53
From: Neil Schneider
Subject: Find position of text string in larger string

If you only want to know if the summary field contains the value you are looking for (and don't need the index in the array), this should do it..
var text data = "V102-136 ; V23-4072 ; V8-25";
var textList dataList = Split($data, ";");
var text field = "V23-4072";
var bool hasField = Contains($dataList, $field);

If ($hasField, $field, "notfound")

------------------------------
Neil Schneider

Original Message:
Sent: 09-15-2020 23:09
From: Jonathan Heuer
Subject: Find position of text string in larger string

I have a long string in my Services table, the result of a Combined Text Summary field, each element takes the pattern V###-#### (where the number parts of the string are arbitrary length). For example :

V102-136 ; V23-4072 ; V8-25

I want to create a formula which extracts correct element in this array, based on the value in another field, and I could do it if I knew the position in the text string of the "V" value. So if there were a function Find which returned the position of a text string, that would do it. Something like

Find([Summary Field", "V" & [Text string to search for])

I can't find a function to do this. Functions like left just search for single characters, and I need to search for a longer string. Ideas?

------------------------------
Jonathan Heuer
------------------------------

10. RE: Find position of text string in larger string

Like

Jonathan Heuer

Posted 12 days ago

I haven't implemented it yet, but I think it would work fine. I was just hoping to find a solution which didn't limit the size of the array. Right now there are <10, but it could grow by quite a bit.

------------------------------
Jonathan Heuer
------------------------------

Original Message

Original Message:
Sent: 09-16-2020 15:36
From: Mark Shnier (YQC)
Subject: Find position of text string in larger string

..Jonathan, was there a problem with using my solution an an approach?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 09-16-2020 15:14
From: Jonathan Heuer
Subject: Find position of text string in larger string

Neil I'm sure I didn't clearly explain. Once I search for "V23" and obtain it's position, I'll ultimately want to get the value after the hyphen, "4072". But if I can find "V23" in the larger string, I'm fairly confident that I can extract the part after the hyphen.

------------------------------
Jonathan Heuer

Original Message:
Sent: 09-16-2020 14:26
From: Neil Schneider
Subject: Find position of text string in larger string

Jonathan,
I probably misunderstood the question. The formula field would return the actual value if the value is found in the string. The example returns "V23-4072", did you need the index of the value?

------------------------------
Neil Schneider

Original Message:
Sent: 09-16-2020 10:58
From: Jonathan Heuer
Subject: Find position of text string in larger string

Thanks Neil- yep I know about Contains. The problem is I need to extract the actual value from the text string, not just whether it's there or not.

------------------------------
Jonathan Heuer

Original Message:
Sent: 09-16-2020 10:53
From: Neil Schneider
Subject: Find position of text string in larger string

If you only want to know if the summary field contains the value you are looking for (and don't need the index in the array), this should do it..
var text data = "V102-136 ; V23-4072 ; V8-25";
var textList dataList = Split($data, ";");
var text field = "V23-4072";
var bool hasField = Contains($dataList, $field);

If ($hasField, $field, "notfound")

------------------------------
Neil Schneider

Original Message:
Sent: 09-15-2020 23:09
From: Jonathan Heuer
Subject: Find position of text string in larger string

I have a long string in my Services table, the result of a Combined Text Summary field, each element takes the pattern V###-#### (where the number parts of the string are arbitrary length). For example :

V102-136 ; V23-4072 ; V8-25

I want to create a formula which extracts correct element in this array, based on the value in another field, and I could do it if I knew the position in the text string of the "V" value. So if there were a function Find which returned the position of a text string, that would do it. Something like

Find([Summary Field", "V" & [Text string to search for])

I can't find a function to do this. Functions like left just search for single characters, and I need to search for a longer string. Ideas?

------------------------------
Jonathan Heuer
------------------------------

11. RE: Find position of text string in larger string

Like

Mark Shnier (YQC)

Posted 12 days ago

Right, I think that you will find that using the formula language in the formula field boxes, you will not be able to generate an array.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Original Message

Original Message:
Sent: 09-16-2020 15:44
From: Jonathan Heuer
Subject: Find position of text string in larger string

I haven't implemented it yet, but I think it would work fine. I was just hoping to find a solution which didn't limit the size of the array. Right now there are <10, but it could grow by quite a bit.

------------------------------
Jonathan Heuer

Original Message:
Sent: 09-16-2020 15:36
From: Mark Shnier (YQC)
Subject: Find position of text string in larger string

..Jonathan, was there a problem with using my solution an an approach?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com

Original Message:
Sent: 09-16-2020 15:14
From: Jonathan Heuer
Subject: Find position of text string in larger string

Neil I'm sure I didn't clearly explain. Once I search for "V23" and obtain it's position, I'll ultimately want to get the value after the hyphen, "4072". But if I can find "V23" in the larger string, I'm fairly confident that I can extract the part after the hyphen.

------------------------------
Jonathan Heuer

Original Message:
Sent: 09-16-2020 14:26
From: Neil Schneider
Subject: Find position of text string in larger string

Jonathan,
I probably misunderstood the question. The formula field would return the actual value if the value is found in the string. The example returns "V23-4072", did you need the index of the value?

------------------------------
Neil Schneider

Original Message:
Sent: 09-16-2020 10:58
From: Jonathan Heuer
Subject: Find position of text string in larger string

Thanks Neil- yep I know about Contains. The problem is I need to extract the actual value from the text string, not just whether it's there or not.

------------------------------
Jonathan Heuer

Original Message:
Sent: 09-16-2020 10:53
From: Neil Schneider
Subject: Find position of text string in larger string

If you only want to know if the summary field contains the value you are looking for (and don't need the index in the array), this should do it..
var text data = "V102-136 ; V23-4072 ; V8-25";
var textList dataList = Split($data, ";");
var text field = "V23-4072";
var bool hasField = Contains($dataList, $field);

If ($hasField, $field, "notfound")

------------------------------
Neil Schneider

Original Message:
Sent: 09-15-2020 23:09
From: Jonathan Heuer
Subject: Find position of text string in larger string

I have a long string in my Services table, the result of a Combined Text Summary field, each element takes the pattern V###-#### (where the number parts of the string are arbitrary length). For example :

V102-136 ; V23-4072 ; V8-25

I want to create a formula which extracts correct element in this array, based on the value in another field, and I could do it if I knew the position in the text string of the "V" value. So if there were a function Find which returned the position of a text string, that would do it. Something like

Find([Summary Field", "V" & [Text string to search for])

I can't find a function to do this. Functions like left just search for single characters, and I need to search for a longer string. Ideas?

------------------------------
Jonathan Heuer
------------------------------

Discussions