PL/SQL (MOSC)

MOSC Banner

How to replace tab character from text field enclosed in quotes in sql*loader

in PL/SQL (MOSC) 4 commentsAnswered

I'm trying to upload a csv file that contains a tab character in the text field, that's enclosed by quotes.

e.g. of a 2 column input file:

Hello, " World"

Desired outcome would be to remove the tab character from World, before storing it in the database table.

Thanks for any help!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center