Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI cannot load CSV with fields enclosed by double-quotes, delimited by comma

3673816Jul 2 2018 — edited Jul 2 2018

Hi.

I have a CSV file with fields delimited by comma.

Some fields, however are also enclosed by double-quotes, specifically the ones whose text itself has commas, as a way of differentiating commas in the text vs commas that are field delimiters.

So, something like this:

--------------

123,abcd,"abc,d"

456,defg,"def,g"

Three fields, delimited by comma. However, the third field is enclosed by double-quotes and has commas in its text. This comma is not a delimited, but a part of the text itself.

I have having a hard time using ODI to load this file into Oracle.

In Oracle External table it is easy, I would just do:

         FIELDS TERMINATED BY ','

         OPTIONALLY ENCLOSED BY '"'

In ODI, in the datastore "Files" tab I don't see anything that specifies "optionally enclosed by".

Also, in the mapping, I am using the "LKM SQL to Oracle (Built-In).Global" module, which does not have the "optionally enclosed by" attribute. Neither does the "LKM File to Oracle (EXTERNAL TABLE)" module.

So, how can I load double-quoted fields without the actual double-quotes in the resulting Oracle column and, more importantly, escape the text-related commas and not treat them as field separators?

Thank you

Boris

This post has been answered by JimmyOTNC on Jul 2 2018
Jump to Answer

Comments

798692
JRE may not be enabled in your browser. Check whether it is enabled or not?

You can verify that from 'Tools -> Internet Options -> Advanced -> Java (sun)'
User_64CKJ
880537 wrote:
..However, when I view the page in IE8, the applet displays an error message (which I can't seem to decipher).
I'm having trouble deciphering that message as well. ..Mostly because you did not copy/paste it.
883540
my bad...the error looks like this:

java.lang.UnsupportedClassVersionError: HelloWeb : Unsupported major.minor version 51.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(Unknown Source)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source)
at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Exception: java.lang.UnsupportedClassVersionError: HelloWeb : Unsupported major.minor version 51.0
EJP
The JVM being used by the browser is earlier than the version of javac you compiled the applet with.

So update the browser's JVM or use the -target switch of javac.

If you get a message you can't 'decipher', post it. Just saying you can't decipher it only wastes time.
883540
I'm running Java SE 7, which should be the latest version of Java available. Does this mean I need to update my compiler?

Sorry that I keep asking these questions but I want to make sure my applets will run properly in the future.
Kayaman
Answer
880537 wrote:
I'm running Java SE 7, which should be the latest version of Java available. Does this mean I need to update my compiler?
No, it means that your browser isn't running Java 7, but has an older plugin.
Sorry that I keep asking these questions but I want to make sure my applets will run properly in the future.
Then maybe use the target flag when compiling so it's compatible with 1.5. Version 1.6 tops. Unless you really need to use all the new features.
Marked as Answer by 883540 · Sep 27 2020
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 30 2018
Added on Jul 2 2018
4 comments
3,670 views