You're viewing a comment by Octavian and its responses.

Octavian Permalink
September 22, 2015, 14:09

Hello,

I have a csv file with 6 columns separated by #
The third column has inside its values other # that constraints me from importing the csv in my oracle plsql.
How do I remove the # that are between the 2nd # from the left and the 4th from the right ?

Many thanks,

Octavian

Comment Responses

Anirudh Permalink
January 30, 2016, 18:02

# This GNU sed code clips any comment
# chars occurring in the 3rd field of line
# till it is left with 6 fields

:top
/#/!b

s//&/; trst
:rst

s//&/6; T

s///3; btop

Reply To This Comment

(why do I need your e-mail?)

(Your twitter handle, if you have one.)

Type the word "apple_95": (just to make sure you're a human)

Please preview the comment before submitting to make sure it's OK.