Text Manipulation

[Mike9761]

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"

 

[Winny57]

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"

You would need an example of the text to help you.

If the number is contained between two precisions you can use (.*?)

 

[Pseudocyclic]

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

 

[Mike9761]

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

Better example -
Mr John Smith • 2 This Road This Town
I want to extract the name "Mr John Smith"
The remaining " • This Road This Town" I don't want .

 

[Pseudocyclic]

The above should extract "Mr John Smith ". There are a number of simple ways it can be tweaked to remove the unwanted space at the end.

 

[Winny57]

If it is not confidential shared the text to be processed

 

[Dev777]

Text manipulation with the below regex

.*(?= •)

 

[Winny57]

Text manipulation with the below regex

.*(?= •)

In your case if you want to get the address you should rather do

•(.*?)•

If your address is in two • otherwise you must delimit the start symbol then (.*?) end symbol