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

News Tutorials
,
107

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.

108

This was treasure

109

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

110

Hello there,

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

Screenshot 2023-03-06 113236
Screenshot 2023-03-06 113236719×234 20.1 KB

1 Like
111

TestText.replace(“•”,“”)

113

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?

image
image1110×308 18.7 KB

114

Try with this:

System.Text.RegularExpressions.regex.replace(yourVariable,"(\u2022|\u2023|\u25E6|\u2043|\u2219)","")
1 Like
115

image
image714×574 19 KB

Works for me

116

Thank you. Will check it out

1 Like
117

Hello together,

I’m getting crazy. Someone can help with extracting the actual title?
Here is the text (the TEST TITLE TO BE EXTRACTED I want as a result):

"/
aStandard Operating Manual
InstrucciĂłn
aTĂ­tulo:
aTEST TITLE TO BE EXTRACTED
a
aNĂşmero:
aD54148483
"
Thanks in advance :slight_smile: !

118

Hi Adrian,

Can you please help me to get sentence as output “Waste management services”. This sentence will change dynamically. I have used split function but not getting proper output

Input String
StrItemDesc = “1 Waste management services 278922 RON 1 278922 RON”

Thanks

119

:hand_with_index_finger_and_thumb_crossed: :+1: :+1: :+1:

1 Like
120

Hi,

Can I use the Regex to extract the date time in the string? Can I use the Split function with Regex?

Regards,