Carriage Return - Line Feeds - exporting Calendar events

ofw62

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
There is a thread that somewhat similar to the below, titled "Import csv problem" (april 2018).

For a lllong time already I am facing the below problem and actually I found a workaround for it.
The workaround requires a bit of knowledge of regular expressions though and I believe this shouldn't be a requirement for a proper export.

When exporting Calendar events, I have noticed that, in a number of cases .., the csv includes CRLF (Carriage Return/Line Feeds) at the very end of the description in the 'Description box'.
There is no linefeed there. When enabling 'Show paragraph marks and other hidden formatting symbols" the texts look similar to those that do not have this carriage return\line feed. Also, when being in the description box, at the end of the text, I can not move the cursor to the next line, i.e. the last character of the text description actually -is- the last character. In all cases, the text is plain text and I do not see any way to have influence on the output.

Anyway, my workaround:
- export to .csv
- rename file to .txt
- open the file with a 'more advanced' text-editor that supports regular expressions (personally I use EditPadPro)
- perform a regex find: (\r?\n\r?\n?\s?)((\"\,\")|[A-Za-z0-9(])
- replace with: $2

This should basically remove those weird CRLF's

All lines of the .csv export should end up with "Normal","2" or "Normal","3"

To check this
Again perform a regex find: ^.+$(?<!"\d")

If above find and replace were okay, then the cursor should be at the top of text file, i.e. the CRLF's have been removed.

Yes, I know, this is a peculiar way of solving the issue.

I spent a lot of time trying to figure out what might cause this strange error but gave up. Using this workaround is just a few clicks: the find and replace actions are 'saved' actions.

Just my 2cents

SnagIt-29112021 065908.png
 
Similar threads
Thread starter Title Forum Replies Date
R The return of weird graphical glitches in Outlook? Using Outlook 2
H Return Highest Level Email Folder Outlook VBA and Custom Forms 2
B ActiveExplorer return NULL on new Window user login and running Outlook first time Using Outlook 1
B return to inbox Using Outlook 5
icacream outlook 2007 - how do I stop spacing when I hit return ? Using Outlook 4
G Possible to create reports that return contacts based on account criteria? BCM (Business Contact Manager) 0
R Return Address Using Outlook 1
S ActiveExplorer return NULL on new Window user login and running Outlook first time Outlook VBA and Custom Forms 19
N Line to move origEmail to subfolder within a reply macro Outlook VBA and Custom Forms 0
D ISOmacro to extract active mail senders name and email, CC, Subject line, and filename of attachments and import them into premade excel spread sheet Outlook VBA and Custom Forms 2
D cannot view emails in View pane (in the right pane), I only see one line or nothing Using Outlook 21
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1
V vBA for searching a cell's contents in Outlook and retrieving the subject line Outlook VBA and Custom Forms 1
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0
C How to rename subject line and forward the email Outlook VBA and Custom Forms 2
B Add Prefix text to Subject Line Using Outlook 1
M Convert Subject Line to Internet Header version of Subject Outlook VBA and Custom Forms 10
O Double line spacing - solved with minor drawback Using Outlook 0
J VBA Outlook : Subject line : Cut and Paste name to heading , number to very end of the body of Email Outlook VBA and Custom Forms 1
N Wide Line Spacing in Folder pane 2016 Using Outlook 18
C Change Subject Line in Selected Emails Outlook VBA and Custom Forms 1
O Adding a new account - "CompanyL (none)" line is added Using Outlook 5
C Outlook - cannot save subject line changes Using Outlook 2
O On click,I want to change subject line of selected mail and then reply to particular email and move Using Outlook 3
N Select Appointment subject line from combobox or list Outlook VBA and Custom Forms 1
M Subject Line Automation - Trigger Script Delayed Outlook VBA and Custom Forms 2
R Sending email copy (*.msg file) of sent email if subject line contains specific string. Outlook VBA and Custom Forms 1
J Marco in search of text in subject line Using Outlook 8
N automatic response with an attachment based on the subject line Outlook VBA and Custom Forms 1
K ind specific Subject line from outlook and copy the content of the email body to exce Outlook VBA and Custom Forms 0
C replace subject line generated by converting a word document to PDF and sending it to an email Using Outlook 8
C Outlook Subject Line Macro Outlook VBA and Custom Forms 0
Harald Olsen Automated insertion of address in address line Using Outlook 1
P Can't see full text in From and Subject line Using Outlook 1
D dropdown list in new email in subject line Using Outlook 4
T In-line reply style in Outlook Outlook VBA and Custom Forms 20
N Rename Subject Line with Email Content Outlook VBA and Custom Forms 3
Stilgar Relsik Create a rule to copy text from an email and paste it in the subject line. Using Outlook 1
P MS OUTLOOK 2013 - Adding Sender on the CC line Using Outlook 5
J Remove extra line above signature in reply Outlook VBA and Custom Forms 5
I Make a macro in line rather than pop out Outlook VBA and Custom Forms 0
Diane Poremsky Editing the Subject Line in Outlook Using Outlook 0
Aussie I Change the Subject Line ... but after it is moved the subject has reverted Using Outlook 1
Diane Poremsky Add a file number or keyword to the subject line of messages Using Outlook 0
O How to set subject line in replies using VBA Outlook VBA and Custom Forms 1
B VBA to prepend subject line Using Outlook 0
M Outlook adds strange characters inserted into the Subject Line Using Outlook 2
O How to display multi-line task in To-Do List - Outlook 2010 Using Outlook 1
D VBA Code to strip Subject Line when replying or forwarding Using Outlook 3

Similar threads

Top