Click here to Skip to main content
15,889,877 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
PraiseRe: I went shopping today. Pin
Eddy Vluggen14-May-20 2:06
professionalEddy Vluggen14-May-20 2:06 
GeneralRe: I went shopping today. Pin
OriginalGriff14-May-20 2:31
mveOriginalGriff14-May-20 2:31 
GeneralRe: I went shopping today. Pin
Chris Maunder13-May-20 14:13
cofounderChris Maunder13-May-20 14:13 
GeneralRe: I went shopping today. Pin
The pompey13-May-20 16:04
The pompey13-May-20 16:04 
GeneralRe: I went shopping today. Pin
Chris Maunder14-May-20 5:21
cofounderChris Maunder14-May-20 5:21 
GeneralRe: I went shopping today. Pin
OriginalGriff13-May-20 20:31
mveOriginalGriff13-May-20 20:31 
GeneralRe: I went shopping today. Pin
DerekT-P14-May-20 12:34
professionalDerekT-P14-May-20 12:34 
RantAnd we're back to the eighties again... Pin
OriginalGriff13-May-20 1:54
mveOriginalGriff13-May-20 1:54 
Did you know that if you export contacts in Outlook CSV format from Google Contacts, Outlook can't read it? Laugh | :laugh:

No, seriously.

And why? Because it's stored with "\n" as the line separator instead of "\r\n" and Outlook doesn't like that, not at all.
A windows app (Chrome) writes a text-based file that another Windows app (Outlook) can't read because the line terminator is Windows standard rather than it's preferred format. I thought we killed that in the eighties!

Guess what, Microsoft? Excel can read it. Excel reads it fine provided it's got any type of line terminator ... D'Oh! | :doh:

[edit]
OK, it's a trivial change:
C#
string inPath = @"C:\Users\PaulG\Downloads\ToConvert\Contacts\GoggleContacts.csv";
string outPath = @"C:\Users\PaulG\Downloads\ToConvert\Contacts\GoggleContacts2.csv";
string[] lines = File.ReadAllLines(inPath);
string appended = String.Join("\r\n", lines);
File.WriteAllText(outPath, appended);
but it shouldn't be necessary, not at all ... not this century.
[/edit]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!

GeneralRe: And we're back to the eighties again... Pin
musefan13-May-20 2:06
musefan13-May-20 2:06 
GeneralRe: And we're back to the eighties again... Pin
James Curran13-May-20 2:36
James Curran13-May-20 2:36 
GeneralRe: And we're back to the eighties again... Pin
Rage13-May-20 2:40
professionalRage13-May-20 2:40 
GeneralRe: And we're back to the eighties again... Pin
Peter_in_278013-May-20 2:44
professionalPeter_in_278013-May-20 2:44 
GeneralRe: And we're back to the eighties again... Pin
Rage13-May-20 2:46
professionalRage13-May-20 2:46 
GeneralRe: And we're back to the eighties again... Pin
Rage13-May-20 2:39
professionalRage13-May-20 2:39 
GeneralRe: And we're back to the eighties again... Pin
James Curran13-May-20 2:46
James Curran13-May-20 2:46 
GeneralRe: And we're back to the eighties again... Pin
kalberts13-May-20 2:56
kalberts13-May-20 2:56 
GeneralRe: And we're back to the eighties again... Pin
Jörgen Andersson13-May-20 3:40
professionalJörgen Andersson13-May-20 3:40 
GeneralRe: And we're back to the eighties again... Pin
Rage13-May-20 21:17
professionalRage13-May-20 21:17 
GeneralRe: And we're back to the eighties again... Pin
Jörgen Andersson13-May-20 21:19
professionalJörgen Andersson13-May-20 21:19 
GeneralRe: And we're back to the eighties again... Pin
Stuart Dootson13-May-20 5:37
professionalStuart Dootson13-May-20 5:37 
GeneralRe: And we're back to the eighties again... Pin
jsc4213-May-20 3:11
professionaljsc4213-May-20 3:11 
GeneralRe: And we're back to the eighties again... Pin
littleGreenDude13-May-20 3:58
littleGreenDude13-May-20 3:58 
GeneralRe: And we're back to the eighties again... Pin
OriginalGriff13-May-20 4:14
mveOriginalGriff13-May-20 4:14 
GeneralRe: And we're back to the eighties again... Pin
kalberts13-May-20 4:48
kalberts13-May-20 4:48 
GeneralRe: And we're back to the eighties again... Pin
PIEBALDconsult13-May-20 4:57
mvePIEBALDconsult13-May-20 4:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.