Community
Showing results for 
Search instead for 
Do you mean 
Reply

Many Errors on .csv Export

Accepted Solution Solved
Highlighted
Copper Contributor
Posts: 142
Country: USA
Accepted Solution

Many Errors on .csv Export

I did an export of a DB out of Act Premium 18.  When I open it up I notice errors such as data in the wrong column for some lines but not others.  Is there any way to fix this so the export is accurate?


Accepted Solutions
Highlighted
Solution
Accepted by topic author topaz99
‎04-29-2020 04:03 PM
Silver Contributor
Posts: 1,933
Country: United_Kingdom

Re: Many Errors on .csv Export

If you are using the export from File - Export -  when you get to item 4 in the export wizard select TAB instead of Comma.

 

Open as Text File in Excel (Tab delimited.)

+

View solution in original post


All Replies
Highlighted
Platinum Elite Contributor
Posts: 14,732
Country: Australia

Re: Many Errors on .csv Export

Highlighted
Copper Contributor
Posts: 142
Country: USA

Re: Many Errors on .csv Export

I don't see any carriage returns in Act on these records, however they are all 1-line fields. Is it possible there are carriage returns from cutting and pasting into these Act fields? I don't see how I could determine which fields have them or how to correct it without re-entering all the data for each record.

Highlighted
Platinum Elite Contributor
Posts: 14,732
Country: Australia

Re: Many Errors on .csv Export

It is possible that a CR/LF or something else odd is in those fields from a copy/cut and paste

Another option for you is to use the List View, add all the fields you want and Export to Excel.
Highlighted
Solution
Accepted by topic author topaz99
‎04-29-2020 04:03 PM
Silver Contributor
Posts: 1,933
Country: United_Kingdom

Re: Many Errors on .csv Export

If you are using the export from File - Export -  when you get to item 4 in the export wizard select TAB instead of Comma.

 

Open as Text File in Excel (Tab delimited.)

+