Re: [libreoffice-users] Pasting csv string into Calc

Hi.
I just pasted from this email into calc.
Copy to clipboard.
Paste Special > Unformatted text. The text import dialogue opened and I 
set delimiter as comma.

All imported as you asked.
steve

On 12/11/2018 08:32, vytas wrote:
> Hi,
>
> I have results arriving by e-mail containing a series of lines with a 
> structure as shown below.
>
> "Vytas", "vytas@somewhere.com", "Jock Wadley Award" ,"Freddy 
> Someone",  "dflghfsd"
> "Vytas", "vytas@somewhere.com", "Beryl Burton Award" ,"Joan Someone",  
> "dflghfsd"
> ...
> ...
>
> I need to paste this into a spreadsheet into five different columns.  
> Every paste method I tried has failed.  The best I can get is that 
> everything gets pasted into the first field.
> What am I missing?
>
> Thanks,
>
> Vytas


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy