sed Or Grep Problem OR Terminal Problem?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers sed Or Grep Problem OR Terminal Problem?
# 22  
Old 02-12-2015
If it weren't for a MAC, on my linux system I'd try
Code:
 tr '\r' '\n' <input.txt | sed '/[0-9]d/'

or an equivalent if your system doesn't accept '\r' and '\n'
This User Gave Thanks to RudiC For This Post:
# 23  
Old 02-12-2015
Thank you so much for the clue!!! I finally got it!!! Smilie It has definitely got to do with text format that Excel uses. After I opened the file with "TextEdit" & changed the format and style, I could finally use sed or grep to it Smilie

I had to convert it into "Rich Text Format" then I could sed it into output.txt format. It gave me lines with "\" at the end but that's ok I could use perl, find and replace.

I was so lucky as the file is not more than 10mb though. If it's like 200gb like before, this project is simply dead.

I m not sure if there's a command to change the text format without using "TextEdit". If there is, it would be simply AWESOME Smilie

Anyways, thank you all for your help and sorry I caused too much trouble. :S

Moral of the Story : Don't play with Excel Smilie

I could use perl on the txt that just come out of Excel though. If only there's a way to remove lines containing digits using perl

Once again, thank you all Smilie
# 24  
Old 02-12-2015
Try not to print it from EXCEL but to save it as a .csv or a .txt file. These might be easier to process afterwards.
# 25  
Old 02-12-2015
Yes, I saved it as MS-DOS txt or Window Formatted. I tried both but couldn't do sed. Maybe I will try .csv next time Smilie
# 26  
Old 02-12-2015
Don't save it in those two formats as they are incompatible with *nix formats.
This User Gave Thanks to RudiC For This Post:
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Silly problem with sed and grep

I am trying to delete all empty lines from a file using either grep -v ^$ file or sed '/^$/d' file But neither one is working. I have uploaded the file I am trying to modify. Any help will be greatly apreciated. (3 Replies)
Discussion started by: Xterra
3 Replies

2. HP-UX

Problem with terminal

Hi Guys, I'm using my putty to connect to the HP-UX test box. Once I get connected to server there seem to be something wrong with my putty that behaves very odd. for example it starts from the half of the screen. I really dont know how to explain this problem. or for instance when i run vi to... (2 Replies)
Discussion started by: messi777
2 Replies

3. Linux

Terminal logging character problem -Newbie-

Im a complete newbie tryin to work with linux centos; in terminal wanted to log with script command; but output file has some strange characters when I try to open with gedit or bluefish terminal , gedit, bluefish encoding is utf-8 ; Script started on Mon 08 Mar 2010 03:32:39 PM EET... (2 Replies)
Discussion started by: anacondauser
2 Replies

4. Shell Programming and Scripting

Problem - gnome terminal shell scripting

I've a python script named rwe.py. I'm running the program in three separate terminals. If one of the executing program stops . I want to leave the terminal as it is so that i can see the error. i wrote a the below script and used cron to run it every one hour to check if the three programs are... (0 Replies)
Discussion started by: msteve2002
0 Replies

5. Shell Programming and Scripting

Problem with gnome-terminal

Hello everyone. This is my first post.:o Using Ubuntu 8.04 and bash 3.2.39 i'm trying to adapt my routine to this platform. So, this means forget xterm and use gnome-terminal (as default ubuntu terminal). EveryDay i need to connect to several servers, and i've made a Tcl'script to make this... (1 Reply)
Discussion started by: trutoman
1 Replies

6. Linux

tty terminal permissions problem

I'm hoping someone can help me out here. I'm having a problem on my Red Hat Enterprise 5 Server where my tty devices "tty" are being set to read only permissions. I need them to be set to 777 in order to write to the serial printers through a custome application. I have gone through many... (2 Replies)
Discussion started by: Netwrkengeer
2 Replies

7. Programming

terminal problem

i am executiing some commands using system an popen command in c. while executing the code . some data is shown on terimal without using any print statement. how can i solve this problem thank u sree (1 Reply)
Discussion started by: phani_sree
1 Replies

8. SCO

Terminal Allocation Problem

Hello All, I am facing a problem on SCO Open Server V 5x, We are using serial communication on dumb terminals, right now i am facing a problem on some terminals, as they are not showing thier previous tty no, as tty13 or tty18, but they are showing ttya6 or ttya4, i also tried to move and link... (5 Replies)
Discussion started by: Awadhesh
5 Replies

9. UNIX for Advanced & Expert Users

terminal type problem with cygwin on aix

hey, I use cygwin to connect to AIX 5.2 but when I open vi I get an error saying: ex: 0602-108 cygwin is not a recognized terminal type how can I fix that? I thought cygwin was tty vt100? (1 Reply)
Discussion started by: rein
1 Replies

10. UNIX for Dummies Questions & Answers

terminal problem

Hi all While trying to upon a new window it is saying UNABLE TO GET PTY..what does this means how to solve it Thanks Prafulla (4 Replies)
Discussion started by: Prafulla
4 Replies
Login or Register to Ask a Question