Re: importing a csv file into a wonder application

OpenCSV (http://opencsv.sourceforge.net ) is an Apache licensed library that’s been working well for us for a while. Straight tokenizing works well if there aren’t newlines or commas or any other meaningful characters in the content. Even “last name, firstname mi

Re: importing a csv file into a wonder application

Old NeXT-style would be using the method "componentsSeparatedByString" of NSArray. So, this is how I make it (assuming '\n' is used for linebreak and '\t' for cell) and Apache Commons IO for file reading: String contentOfFile = FileUtils.readFileToString("/my/file.csv", "UTF-8"); NSArray lines

Re: importing a csv file into a wonder application

Thanks! That should do the trick. Kevin Spake Alchemy Billing LLC 916-397-9953: Phone 866-594-0847: Fax IMPORTANT WARNING: This message is intended for the use of the person or entity to which it is addressed and may contain information that is priviledged and confidential, the disclosure of

Re: importing a csv file into a wonder application

Hi Kevin, My CSV importers use something like this: Scanner scanner = new Scanner(new FileInputStream(importFile), "UTF-8"); try { // first use a Scanner to get each line Integer lineNumber = 0; while (scanner.hasNextLine()) { St

Re: importing a csv file into a wonder application

On Wed, 15 Apr 2015 21:11:01 -0700 "Kevin @ alchemy POP" wrote: > I've got a simple Wonder project where I want to populate the > database by importing a csv file. Before adding the data to the table > I intend to do some cleanup on it, ie, checking for unwanted > characters, etc. Is there an ap

importing a csv file into a wonder application

I've got a simple Wonder project where I want to populate the database by importing a csv file. Before adding the data to the table I intend to do some cleanup on it, ie, checking for unwanted characters, etc. Is there an approved Wonder approach to reading a text file, or is it just straight j