-2

The input is -> -747585959 And being loaded as -747585959 I just want it to be loaded as 747585959. Used sql*loader for the data loading process.

The “ - “ is the first column and it has “ - “ for all the rows.

Improve this question
2
  • Maybe sed 's/^-//' inputfile > outputfile Commented Jul 19, 2022 at 14:41
  • Please show your control file. Have you tried anything? Commented Jul 20, 2022 at 12:44

1 Answer 1

Reset to default
0

Just simply do this for that column in the control file, which will in effect skip the first character, the dash.

...
,inputdata    NULLIF(inputdata=BLANKS) "SUBSTR(:inputdata, 2)"
...
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.