[Libreoffice-bugs] [Bug 144842] LibreOffice Calc FILEOPEN Import csv 'Format quoted field as text' does not work

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Sep 30 17:04:28 UTC 2021


https://bugs.documentfoundation.org/show_bug.cgi?id=144842

--- Comment #3 from Mike <itismike at gmail.com> ---
Thanks for the explanations. I understand the problem is that part of the field
is quoted. I think I was incorrect in calling out the "Format quoted field as
text" as the root of this.

Wouldn't the Merge delimiters option work though?:
"Combines consecutive delimiters and removes blank data fields"

BTW the tabs above came from me copying/pasting from Calc. And it is not
fixed-width either. Scrubbed raw data follows:

date=2021-09-30 time=08:02:31 logid="..." type="event" subtype="vpn"
level="information" vd="root" eventtime=... logdesc="SSL VPN tunnel up"
action="tunnel-up" tunneltype="ssl-tunnel" ... dst_host="N/A" reason="tunnel
established" msg="SSL tunnel established"
date=2021-09-30 time=08:02:31 logid="..." type="event" subtype="vpn"
level="information" vd="root" eventtime=... logdesc="SSL VPN tunnel up"
action="tunnel-up" tunneltype="ssl-tunnel" ... dst_host="N/A" reason="login
successfully" msg="SSL tunnel established"
date=2021-09-30 time=08:02:31 logid="..." type="event" subtype="vpn"
level="information" vd="root" eventtime=... logdesc="SSL VPN tunnel up"
action="tunnel-up" tunneltype="ssl-tunnel" ... dst_host="N/A" reason="User
requested termination of service" duration=100 sentbyte=0 rcvdbyte=0 msg="SSL
tunnel shutdown"
date=2021-09-30 time=08:02:31 logid="..." type="event" subtype="vpn"
level="information" vd="root" eventtime=... logdesc="SSL VPN tunnel up"
action="tunnel-up" tunneltype="ssl-tunnel" ... dst_host="N/A" reason="User
requested termination of service" duration=100 sentbyte=13183 rcvdbyte=75383
msg="SSL tunnel shutdown"

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210930/79672957/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list