How to split the Apartment details from address

[harika_k]

Hi,

i need to split the Apartment details from address
Example: 814 Chapman Dr. Apt 10
output: Apt 10

[ppr (Peter Preuss)]

@harika_k

814 Chapman Dr. Apt 10

we can use e.g. regex:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[vrdabberu (Varunraj Dabberu)]

HI @harika_k

Is any keyword static in that?

Regards

[pravallikapaluri]

Hi @harika_k

address = "814 Chapman Dr. Apt 10"
Message box
"Apt " + address.Split({"Apt"}, StringSplitOptions.None)(1).Trim()

[ppr (Peter Preuss)]

@harika_k

814 Chapman Dr. Apt 10

And can bring some dynamics in it:

[harika_k]

@pravallikapaluri

"Apt " + address.Split({"Apt"}, StringSplitOptions.None)(1).Trim()

Thank you Pravallika the solution works

[pravallikapaluri]

@harika_k
Welcome
Happy Automation

[ppr (Peter Preuss)]

@harika_k
keep in mind aspects of defensive handling

[harika_k]

Hi pravalika,

if i want before apt text what is the logic for this?

[pravallikapaluri]

@harika_k
Create a new topic so that it will help for others to search

[pravallikapaluri]

@harika_k

address.Substring(0, address.IndexOf("Apt"))