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()) {
String currentLine = scanner.nextLine();
lineNumber += 1;
…
} finally {
scanner.close();
}
And for handling the individual lines:
StrTokenizer tokenizer = StrTokenizer.getCSVInstance(aLine);
tokenizer.setDelimiterChar(';');
tokenizer.getTokenList();
for (int i = 0; i < tokenizer.getTokenArray().length; i++) {
String aToken = tokenizer.getTokenArray()[i];
if (!ERXStringUtilities.stringIsNullOrEmpty(aToken)) {
switch (i) {
case 0: {
…
}
}
}
HTH, Fabian
> Am 16.04.2015 um 06:11 schrieb Kevin @ alchemy POP
> <[email protected]>:
>
> 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 java
> until it's time to actually add the records to the database?
>
> I looked through the Wonder docs but did not see anything related to basic
> text file i/o.
>
> Thanks,
>
>
> 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 which s governed by
> applicable laws. If the reader of this message is not the intended recipient,
> you are hereby notified that any dissemination, distribution, or copying of
> this message is STRICTLY PROHIBITED. If you have received this message in
> error, please notify us immediately at 1(916)723-7029 and delete the related
> message. You, the recipient, are obligated to maintain it in a safe, secure,
> and confidential manner. Re-disclosure without additional consent or as
> permitted by the law is prohibited. Unauthorized re-disclosure or failure to
> maintain confidentiality could subject you to penalties described in the
> Federal and State Laws.
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/lists.fabian%40e-lumo.com
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
