The function Split.all seems to be ignoring a basic convention of CSV formatting? My text.readln command reads a csv header row thus:- Number,Scheme,Location,Date,Category,"L-Lost, R-Repaired, D-Discarded",Serviced
When I then use Split.all with the comma delimiter and print I get:- Number Scheme Location Category "L-Lost R-Repaired D-Discarded" Serviced
The convention of processing values between delimiters is to treat a value enclosed in quotes ("...") as an entire value. Is there a way to use the regular-expression facility of the delimiter parameter to get:-
Number Scheme Location Category L-Lost, R-Repaired, D-Discarded Serviced
Last edited by chrisRoald on Sat Dec 03, 2016 4:36 am, edited 2 times in total.
Users browsing this forum: No registered users and 1 guest
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum