Ask Your Question
0

calc csv limits for columns [closed]

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

effinsoftware gravatar image

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

1 Answer

Sort by » oldest newest most voted
0

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

erAck gravatar image

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 more

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 gravatar imageeffinsoftware ( 2019-02-08 20:51:28 +0200 )edit

Question Tools

1 follower

Stats

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

Seen: 28 times

Last updated: Feb 07