You would need an example of the text to help you.I am trying to use Text Manipulation
Example -
House number or Name • Near here or there
I am try to extract "House number or name"
It can be all alpha or have a number, The "•" is always present regardless, I do not want " • Near here or there"
Better example -Use Regex.
However, if you would like to try a DIY solution without any Regex research/learning...
- set test string variable to ""
- set integer variable to -1
- repeat while test string variable is not •
- increase integer variable value by 1
- copy source string character at integer variable value position to test string variable
- end loop
- delete portion of source string from integer variable value position onwards
In your case if you want to get the address you should rather doText manipulation with the below regex
Code:.*(?= •)
•(.*?)•