Get what row-number a searched word exist in a Text-Field
Is there a way to do that?
Could you possibly expand on explaining what you want?
In short: I would guess that it is in certain ways it is possible to do that.
A multi-row text-field with lot of text from internet web-sites or generic text only.
Just trying to auto-import data and find the ones I want to use and import to FMP: Should be a like a GoToTextLineNumber (text,number) function if you get me, and also a GetTextLineNumber (text,number), That gets all text starting from Line-Number to next >CR> or as FMP call them ¶.
We consider all lines ends with a "¶" even if line-length span multi-rows so to say.
If you have a good generic example code one can make a user-function with it :)
Forgot... when you search for a word or sentence I need to get the "line-number. it was found on, first occurrence only.
You may want to research custom functions. I've seen a Parse function that many find useful.
ValueCount ( Left ( Position ( TextField ; "SearchText" ; 1 ; 1 ) ) )
Yes I know and I will... :)
If you mean row when you are looking at a display or paper print, no (to the best of my knowledge) without using a plugin if one exists or magic.
If by row you mean paragraph, yes. Use getval(fieldname) inside a loop that searches for patterncount in the current paragraph (a bit more complex).
You could use a global to display the text and insert paragraphs every 80 characters (or so as needed) to create line breaks and then use the idea in the paragraph above.
Position determines the numerical location in a string and not its rank in a list of lines in a display.
Calculations will fail due to variable number of characters per line in output.
Wouldn't that return the paragraph rather than the line on screen? If so the two may not be the same.
We consider all lines ends with a "¶"
Thus, our suggestions have assumed that any "row" was also a paragraph and thus ValueCount is an effective part of the parsing calculation to get the desired row number.
If the request had not stipulated that return at the end of each row, this process becomes much more difficult to do with native Filemaker functions and custom functions built from them.
Retrieving data ...