Japanese

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!

Trim or remove records and spaces

1057254Nov 27 2013

Hello,

I am trying to remove/trim everything after 7 characters.

**issue #1** removing everything after 6 or 7 chracters

example: 1Q7 4B7 MY NAME IS MARY

Results I want: 1Q7 4B7

**issue #2** removing one space

example: EQ9 2IQ

Results I want: EQ9 2IQ

Please assist.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 25 2013

Added on Nov 27 2013

#data, #oracle-sql-developer-japanese, #開発ツール製品

0 comments

789 views