I want to be able to search for and remove everything in the square brackets (and the brackets themselves).
Does anyone know how to do this?
Question
Search and remove part string with variable content
+6- Contributor
- 52 replies
I have a spreadsheet with lines of names and addresses which have comments by the author in square brackets in the names. e.g. Eon Energy [formerly Powergen].
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 7843 replies
Hi,
The StringReplacer and a regular expression might help you.
Text to Match: \\[.*\\]
Replacement Text: <leave blank>
Use Regular Expressions: yes
Takashi
+6- Contributor
- 52 replies
Takashi
I have found a glitch with the original data where there can be two sets of [ ] in the string. This RegEx removes both sets and everthing in between.
Is there a way of changing the RegEx to remove everything in the [xxx] and then [yyy] rather than everything from the first open [ and the final ]?
Thanks
Seb
- 7843 replies
An strange expression. Perhaps you are getting a little confused?
.* matches with 0 or more any characters.
[^\\[\\]]* matches with 0 or more any characters except [ and ].
[ and ] are special characters to define a character class in regular expressions, so you will have to escape them with a backslash if you use them in an expression as the character itself.
See also here to learn more about regular expressions.
Regular-Expressions.info (http://www.regular-expressions.info/)
+1- Participant
- 16 replies
Yes, there is. Try this expression.
\\[[^\\[\\]]*\\]
I wish to extract the data into three new attributes where Attribute1 = 77, Attribute2 =53.3 and Attribute3 = 5.33.
To add a level of complexity the number of digits and the place of the decimal point can vary within the rows of data.
Please can you advise (I'm no expert!)
- 7843 replies
Hello Takashi. I have a similar issue to the one you resolved here but in mine the string contains data as formatted as : (77) (53.3) (5.33)
I wish to extract the data into three new attributes where Attribute1 = 77, Attribute2 =53.3 and Attribute3 = 5.33.
To add a level of complexity the number of digits and the place of the decimal point can vary within the rows of data.
Please can you advise (I'm no expert!)
How to expose the charters held within parentheses