How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

[arnab]

Very informative. Thanks a lot.

[Rita_Barros]

Thanks you for this. This was really helpful!

[Melanny_Herrera_Cruz]

Hi good morning.

I am creating a bot that captures a text of type Int from the screen and this captured text always changes length, going up to 5 characters or more. I need regardless of the fetched text to save the text from the first digit to the penultimate.

Can you help me please, thank you.

[Adrian_Star (Adrian Starukiewicz)]

Hi @Melanny_Herrera_Cruz ,

You can use a regular expression:

output = System.Text.RegularExpressions.Regex.Match(inputString,"\b\d+(?=\d)").Value

output = String
inputString = String

Output as shown on screen:

Example link to visualize:

regex101: build, test, and debug regex

Pattern explanation:
start with the word boundary ( \b ),
get numbers that are more than 1 ( \d+ ),
end on a one-digit pattern without taking a character ( (?=\d) ).

[nitish.bakshi]

How to split the string if my string is of the format

Mat
cat
rat
fat

and I want one word at a time?

Can anyone help?

[Adrian_Star (Adrian Starukiewicz)]

Hi,
solution to your problem:

arr_text As Array of Strings

arr_text = Split(your_text, Environment.NewLine)

Usage details in the first post:

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

[nitish.bakshi]

Hi Adrian,

The above mentioned isnt giving me the result.
Can you show with a example

I am trying this

Split(Collection, Environment.NewLine)

where “Collection” is a string type variable

[nitish.bakshi]

This worked for me - text.Split(Environment.NewLine.ToArray,StringSplitOptions.RemoveEmptyEntries)

Thanbk you

[Kakooza-Allan-Klaus]

@Adrian_Star,
I cannot thank you enough your article has been very useful in making me understand string manipulation.

I have written a regex that seems to be working but I get this error:
Self referencing loop detected with type ‘System.Text.RegularExpressions.Match’. Path ‘Groups’.
Could you be having an idea on how to resolve it please.

Thank you.

Best Regards,
Kakooza Allan Klaus

[Adrian_Star (Adrian Starukiewicz)]

Hi @Kakooza-Allan-Klaus ,
Please include your regex pattern here along with a description of what you want to extract. Also include sample text with data. Then I will be able to check the pattern and give you the answer.

[Kakooza-Allan-Klaus]

Hi @Adrian_Star,

As requested.

C:\\\w*\s*\w*\\\w*.xlsx

C:\folder Name\6639a06d28484664ac15dfedf95a0e37.xlsx

Best Regards,
Kakooza Allan Klaus

[Adrian_Star (Adrian Starukiewicz)]

sample = "C:\folder Name\6639a06d28484664ac15dfedf95a0e37.xlsx"
pattern = "C:\\[\w\s]+\\\w+.xlsx"
regex_result = System.Text.RegularExpressions.Regex.Match(sample, pattern).Value

Do you have a logical expression like mine in the regex_result variable?

[Kakooza-Allan-Klaus]

Yes,
But the are patterns are different
I want to know what could have been wrong with mine.

Yours is very stable

[Adrian_Star (Adrian Starukiewicz)]

The difference is slight.
In my formula, I just optimized regex pattern by fitting a result with a range of \w and \s characters.
What does it mean. I grouped the characters \w and \s in to [] bracket and assigned them: + - that is, to match each type of word characters and whitespace in any number starting from 1.

[Harika_Mudiam]

Hi @Nasya.Idris I have seen it was questioned long back. Still posting the link for your question through my short video.
Hoping it would help, if anyone approaches here with same question or you can even refer for the better and single liner approach.

[hikumar (Kumar)]

This was treasure

[Rita_Barros]

Very good post. This has helped me several times
Thanks for sharing!

[m.bindrum18024 (Mona)]

Hello there,

Is there any way to remove the bullet point without text through automation in word?

[angelia (Angelia Howard)]

TestText.replace(“•”,“”)

[m.bindrum18024 (Mona)]

I used the assign method for removing the bullet. The left variable (“ohne_Aufzählungspunkt”) represents the variable for the result of the execution. For the right variable (“Aufzählungspunkt”), the enumeration point should be removed using enumeration_point.Replace("• ", “”). Unfortunately this does not work. Is there a better way to do this?