remove \x0a in unix

Tags

remove, shell scripts, unix

Top Forums Shell Programming and Scripting remove \x0a in unix

01-20-2009

Registered User

52, 0

Join Date: May 2005

Last Activity: 21 January 2011, 10:24 AM EST

Posts: 52

Thanks Given: 0

Thanked 0 Times in 0 Posts

remove \x0a in unix

hi all, i have a flat file delimited by pipe (|), and i'm loading it to sybase, the problem is when i do a select to the table of the database, the last field has new line ascii (\x0a):

38,'0\x0a '
88,'076004074028\x0a '
27,'076004075023\x0a '

how can i remove the \x0a from the flat file????

thanks for help

DebianJ

View Public Profile for DebianJ

Find all posts by DebianJ

01-20-2009

Moderator

8,825, 1,112

Join Date: Feb 2005

Last Activity: 23 August 2021, 11:26 AM EDT

Location: Foxborough, MA

Posts: 8,825

Thanks Given: 579

Thanked 1,112 Times in 1,003 Posts

look into 'man tr'

vgersh99

View Public Profile for vgersh99

Find all posts by vgersh99

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to remove everything before 1st space in UNIX?

i need to remove all before 1st space input : 206292 24436 1115 504 1115 1120793 1115 17453606 62931 547915 108924 305715 23541 19255 315727 1403954 369685 2 1120793 1115 8 1115 165106

2. UNIX for Dummies Questions & Answers

Remove SAS comments using UNIX

I have tried a lot, Need your help guys. SAS Program: data one ; /* Data step */ Input name $; /*Dec variables*/ I want to remove the commented part(/* Data step */) alone. I have tried using sed command but it is deleting the entire line itself. i need unix command to separate this and...

3. Shell Programming and Scripting

How to remove ^M character in file in UNIX?

I have file with controlM (^M) character. i just wanted to run the script after removing the same through script. Thanks in Advance Ganesh.

4. Shell Programming and Scripting

Printf transforms \x0a into \x00

If printf '\x0a' | xxd -cols 1produces 0000000: 0a .then, why does printf '%c' "`printf '\x0a'`" | xxd -cols 1produce 0000000: 00 .??

5. Shell Programming and Scripting

[Perl] Does m/\x0A/ same as m/\x{0A}/ ?

Perl allow hex character with just one digit. Such as \x0 \x9 \xA. How to force to use 2 digits in m// and s///. Such as \x00 \x09 \x0A. ---------- Post updated at 05:20 PM ---------- Previous update was at 03:38 PM ---------- I don't know why these code replace as text, not a real hex...

6. Shell Programming and Scripting

Replacing hex characters '\x0D' with '\x0D\x0A'

Hello All, I have a requirement where I need to replaced the hex character - '\x0D' with 2 hex characters - 'x0D' & 'x0A' I am trying to use SED - But somehow its not working. Any pointers? Also the hex character '\x0D' can occur anywhere in the line. Can this also be accomplished...

7. Shell Programming and Scripting

how to get remove file in unix

hi all, can u plz let me know how to get a file which is being deleted or removed using rm command in unix thanks in advance bali

8. UNIX for Advanced & Expert Users

How to remove UNIX user and groups

I created UNIX groups - oinstall, dba and UNIX user - oracle for the installation of Oracle 10g. But I might did something incorrectly. Oracle user account didn't created properly. How to remove these UNIX groups and user so that I can start over again to create them properly. Thanks.

9. Shell Programming and Scripting

Remove ^M (CR) from Unix Files

Is there any way we could remove the "^M" from files on unix? and also what is the best way to count the TABS in a TAB delimited file per record? Thanks, AC

10. UNIX for Dummies Questions & Answers

How to remove a unix boot partition ?

Hi group member, I'm as new as a newbie can get on Unix, so bear with me . I just got a task of installing NT on a box that had some sort of unix on it. Once I reboot, i always get a Grub> screen and I dont' know how to get rid of it. Just relying on the nt install parition don't seem to be able...

Shell Programming and Scripting