calc csv limits for columns [closed]

asked 2019-02-07 14:53:20 +0100

updated 2020-07-21 23:28:25 +0100

flag of United Kingdom of Great Britain and Northern Ireland

20317 ●18 ●59 ●59 http://etmg.altervista...

there are columns to CA, but on opening I received a message saying I exceeded the maximum columns. It only imported to BU.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-02-09 19:18:56.582470

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2019-02-07 15:03:10 +0100

erAck

8264 ●41 ●76 https://erack.de/

Columns up to AMJ (i.e. 1024 columns) are available, but your CSV data may be malformed with embedded separators but unquoted field content, or you chose a wrong separator, for example ticked blank as well and field content text has blanks. Hard to tell without seeing the actual data.

edit flag offensive delete link

Comments

That turned out to be the case. The data had non-displayed characters that was breaking the text quote pairs. After scrubbing the incoming text to remove any of these characters, it opened without error. Thanks

effinsoftware ( 2019-02-08 20:51:28 +0100 )edit

add a comment

Question Tools

1 follower

Stats

Asked: 2019-02-07 14:53:20 +0100

Seen: 61 times

Last updated: Feb 07 '19

calc csv limits for columns [closed] edit

Closed for the following reason the question is answered, right answer was accepted by erAck close date 2019-02-09 19:18:56.582470