How can I add final punctuation to all entries within a column? This is a pretty straightforward question, and I am disappointed that I couldn’t figure it out on my own. I just need to be able to add punctuation to the end of each cell within a particular column in my spreadsheet.
For example, I need to change something like:
to “Hello world.”
Thanks for the help.
You can join a string to a string using +
So if your cells all contain strings and you want to add a period / full stop in all cases then you can use
If you have more complex rules for when to add punctuation and what punctuation to add then please ask
Thanks for this. If you don’t mind a follow-up question, what would it look like if I only wanted to add punctuation to strings that do not already end in final punctuation (period, exclamation, or question marks)?
Additionally. It would be good to be able to remove final punctuation.
There are a few ways you could do this. You can test whether a string ends with a particular character using
endsWith(). For example:
true if the value in the cell ends with a period, and
false otherwise. If you wanted to test for a single piece of punctuation this would do the trick. However, since you want to test for several it might be easier to use the
contains() function. The advantage of the
contains() function over the
endsWith() function is that you can use regular expressions with it, which gives a powerful way of specifying the conditions you need the string to match.
true if the value in the cell ends with a period, exclamation or questionmark. The way this works is that
/[.!?]$/ is a regulary expression which breaks down as follows:
/ characters just show the start/end of the regular expression
[.!?] part says "any of the characters in the square brackets" (i.e. period, exclamation, question)
$ indicates "end of the string"
So in total this regular expression is testing whether the string contains a period, exclamation or questionmark immediately followed by the end of the string - i.e. the string ends with one of those characters.
Now you have a way of testing whether the string ends with one of these characters, you can use it in a variety of ways - for example you could create a custom text facet with the GREL
and then use that to select the lines that return
false - then run the appropriate transformation on those lines.
Alternatively if you want to do the transformation in a single GREL expression you can use:
That uses the
if control which allows you to do a true/false test and then do different things depending on the outcome
This is much easier... just use the
will remove a period from the end of the string if it ends in a period, but otherwise does nothing
Thank you so much for your continuous help! I learn a lot from your responses (beyond how to accomplish the desired task) and I really appreciate it.