On Wed, 10 Nov 2021, wes wrote:
hmmm. well, the single-quote/apostrophe character that appears the same to
us, could actually be multiple different possible characters "under the
hood" so to speak. what if you use copy-and-paste to put that character in
the find field?
wes,
I wondered about t
On Wed, Nov 10, 2021 at 12:38 PM Rich Shepard
wrote:
> On Wed, 10 Nov 2021, wes wrote:
>
> Calc should allow me to remove that
> single quote/apostrophe from a column using the search-and-replace dialog
> box.
>
>
hmmm. well, the single-quote/apostrophe character that appears the same to
us, coul
On Wed, 10 Nov 2021, wes wrote:
what if you save it to CSV first and then use text tools to remove the
extraneous apostrophes?
wes,
That was my fall-back position. But Calc should allow me to remove that
single quote/apostrophe from a column using the search-and-replace dialog
box.
Thanks,
On Wed, Nov 10, 2021 at 11:06 AM Rich Shepard
wrote:
> On Wed, 10 Nov 2021, Robert Citek wrote:
>
> one of many columns in a .ods spreadsheet file that I want to save
> as a .csv file with the numbers lacking the ' prfix.
>
>
what if you save it to CSV first and then use text tools to remove the
On Wed, 10 Nov 2021, Robert Citek wrote:
First pass:
$ <<'eof' sed -e "s#'##g"
Input: '14 output: 14
Input: '26.3output: 26.3
eof
Input: 14 output: 14
Input: 26.3output: 26.3
Is that close to what you are looking for?
It would be if those values were the only content of a t
First pass:
$ <<'eof' sed -e "s#'##g"
Input: '14 output: 14
Input: '26.3output: 26.3
eof
Input: 14 output: 14
Input: 26.3output: 26.3
Is that close to what you are looking for?
Regards,
- Robert
On Wed, Nov 10, 2021 at 11:24 AM Rich Shepard
wrote:
> On Wed, 10 Nov 2021, R
On Wed, 10 Nov 2021, Robert Citek wrote:
What are you trying to do? Can you post an example of inputs and
desired outputs?
Input: '14 output: 14
Input: '26.3output: 26.3
Rich
Good morning, Rich.
I’m still nursing my coffee this morning, so my brain isn’t fully up to
speed. What are you trying to do? Can you post an example of inputs and
desired outputs?
Regards,
- Robert
On Wed, Nov 10, 2021 at 10:44 AM Rich Shepard
wrote:
> The exported (external) database query
The exported (external) database query result is an .xlsx file rather than a
UTF8 encoded text .csv file. Numeric columns are exported as text with an
initial ' prefix to the number.
I keep trying to remove it using the search-and-replace capabilities,
specifing cell contents as 'values' and the
