No empty strings from SPLIT command

Post Reply
smbstarv
Posts: 98
Joined: Wed Nov 27, 2013 3:44 pm
My devices: Ipad 6th gen
Flag: Netherlands
Contact:

No empty strings from SPLIT command

Post by smbstarv »

SPLIT command says:(.....) Array [m$] does not contain empty strings.

I'm trying to read a csv file (output from excel). I read a row of cells ,using Readline. I then use the SPLIT command, to obtain the individual cell contents. Unfortunately empty cells are "bypassed". This results in an unwanted "shift to the left" of the cells at the righthand side of these empty cells.
(The only way I can think of, to avoid this, is to read the individual characters of the line.)
Is there a way to have SPLIT also produce empty strings in array [m$]. ?

User avatar
Mr. Kibernetik
Site Admin
Posts: 4786
Joined: Mon Nov 19, 2012 10:16 pm
My devices: iPhone, iPad, MacBook
Location: Russia
Flag: Russia

Re: No empty strings from SPLIT command

Post by Mr. Kibernetik »

Thank you very much for your suggestion!

User avatar
Mr. Kibernetik
Site Admin
Posts: 4786
Joined: Mon Nov 19, 2012 10:16 pm
My devices: iPhone, iPad, MacBook
Location: Russia
Flag: Russia

Re: No empty strings from SPLIT command

Post by Mr. Kibernetik »

This functionality will be available in version 4.6.

Post Reply