help with substitution


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers help with substitution
# 1  
Old 07-11-2009
help with substitution

Hello, I have a file with 10,000+ records which look like this:

Image3992170.tif 4/21/200811:42:09AM 3,373.13KB
Image3993265.tif 4/11/20087:17:58PM 2,369.72KB
Image3996764.tif 5/2/200811:01:28AM 2,155.87KB
Image3997700.tif 5/2/200811:21:50AM 2,221.54KB
Image4016441.tif 5/30/20081:12:50PM 92.97KB
Image4021074.tif 4/17/20087:22:35PM 183.92KB
Image4021620.tif 4/23/200810:37:53AM 74.75KB

I need this file to have only image names like this (without a space in front of it):

Image3992170.tif

I am not very good in Unix, please help! Thank you!
# 2  
Old 07-11-2009
Quote:
Originally Posted by lotusdeva
I am not very good in Unix, please help! Thank you!
start with reading the doc. man cut, or man awk. alternatively, see here
# 3  
Old 07-11-2009
Yeah, only I got to extract these images and construct a script and run it before 12 am tonight in my Prod env. I really have no time to read man files. Not trying to be an ass, just very pressed for time. I usually work in windows environemnt and I am not an admin. If anyone can please give me a quick tip of how to accomplish what I need I would greatly appreciate it. Thank you!
# 4  
Old 07-12-2009
Couple of questions:

1) why would you put something to a prod env. that wasn't tested
2) why would anyone let you if you're not an admin

If all you want is the image (.tif) name, then extract it. You can use awk, sed, cut or whatever to do this.
Code:
awk '{print $1}' file > new_file
cp -f new_file file # cp rather than mv to preserve privileges of original file
rm new_file

I'm guessing
a) that's what you asked
b) I'm too late

Last edited by Scott; 07-12-2009 at 01:30 AM..
# 5  
Old 07-12-2009
Try this.
sed -n 's/^\([^ ]*[ ]\).*$/\1/pw xxx.tmp' temp.txt
It is assumed that "temp.txt" is the input file.
This will create a file xxx.tmp with the required data.
This will save a step of creating and later deleting files.
Of course, CUT will be most simplest, but as suggested above see the man command. Should not take more than 5 minutes.

Last edited by edidataguy; 07-12-2009 at 03:04 AM.. Reason: Added more info.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Substitution

I am trying to do some substitutions using the substitution operator (:%s) in a text file. I want to replace all A1, A2, A3.......A100 in my text file. I used :%s/A2/SAE/g successfully until A9 but when I use A1, all the A11 to A19 is changed. How do I specify the exact match here? (8 Replies)
Discussion started by: Kanja
8 Replies

2. UNIX for Dummies Questions & Answers

vi substitution help

Hi experts, Could someone help me how to figure out the following substitution? I copied and pasted a column of names from an Excel file into another file in vi. The column of data has last names with dash (hyphens) and apostrophes. My goal is to do the following: 1) remove the apostrophes... (10 Replies)
Discussion started by: onlinelearner02
10 Replies

3. Shell Programming and Scripting

vi substitution

Hello, I'm trying to do a substitution in vi. which adds a field for the year to a line. If the line doesnt include a year, it should still add a field (although empty) the fields are: Country:number:number:name(and sometimes year):place this is a desired in and output: Sweden:55:32:John... (2 Replies)
Discussion started by: drareeg
2 Replies

4. Shell Programming and Scripting

substitution help

How do i substitute ' with space in a file using sed or awk i am getting the following two scenarios 1) xyz'd with xyz d if i use sed 's/xyz\\\'d/xy z/g' it is taking ' after \ as closing expr for substitution 2) xyz';d with xyz d please advice (8 Replies)
Discussion started by: mad_man12
8 Replies

5. Shell Programming and Scripting

Substitution

All, I have this text document that contains a listing(See below). What i would like to ask is how i could extract just the information i need which is the files name (CWS*****.***.gz) If anyone has any suggestions i would be very grateful. I am sure its relatively simple but i just... (6 Replies)
Discussion started by: Andyp2704
6 Replies

6. Shell Programming and Scripting

Difference between "Command substitution" and "Process substitution"

Hi, What is the actual difference between these two? Why the following code works for process substitution and fails for command substitution? while IFS= read -r line; do echo $line; done < <(cat file)executes successfully and display the contents of the file But, while IFS='\n' read -r... (3 Replies)
Discussion started by: royalibrahim
3 Replies

7. Shell Programming and Scripting

SED Substitution

Hi , I am stuck up in the below scenario:- I need to read a file name (eg A.txt) name frm another file (eg B.txt) and then I need to search for a particular expression in A.txt and substitute it with another expression. How can I use SED inside SHELL Scripting and command prompt as well to... (1 Reply)
Discussion started by: shubhranshu
1 Replies

8. Shell Programming and Scripting

Substitution using SED

Hi , I am stuck up in the below scenario:- I need to read a file name (eg A.txt) name frm another file (eg B.txt) and then I need to search for a particular expression in A.txt and substitute it with another expression. How can I use SED inside SHELL Scripting and command prompt as... (2 Replies)
Discussion started by: shubhranshu
2 Replies

9. UNIX for Dummies Questions & Answers

Need help in substitution!!!!

In a file I want to globally change a "|" charater by a new line character. I am using the command 1,$s/\|/??/g Can anybody say what should I put in place of ?? in the above command? (3 Replies)
Discussion started by: uLearner
3 Replies

10. Shell Programming and Scripting

substitution

I am trying to substituted a variable to a file using sed. However, the value of that variable is not being substituted. Here is an example of my code. lf=' ' v_whole="${1} ${2} ${3} $lf" cp ${IPPDIR}/ctl/fax_sub_text_a.${4}.${5}.txt... (1 Reply)
Discussion started by: supercbw
1 Replies
Login or Register to Ask a Question