Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Urgent for shell script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Urgent for shell script
# 1  
Old 03-03-2008
Urgent for shell script
Hi friends,

I am working as a DataStage developer. I need help in writing shell script.
I have following file and I want to remove data from 1st field and store it into other file.

Convert this file,

A100 Tylenol 100mg
A100 PCML 500mg
B120 CFDR 250mg
C345 PFLX 600mg

remove 1st column data to

Tylenol 100mg
PCML 500mg
CFDR 250mg
PFLX 600mg

can anyone help me?

thanks
sunny
# 2  
Old 03-04-2008
Code:
awk '{print $2,$3} ' sunny
Tylenol 100mg
PCML 500mg
CFDR 250mg
PFLX 600mg

# 3  
Old 03-04-2008
maybe this is what you wanted??

Code:
#> cat sunny
A100 Tylenol 100mg
A100 PCML 500mg
B120 CFDR 250mg
C345 PFLX 600mg
#> awk '{print $1 > "sunny.out"} ; {print $2,$3} ' sunny
Tylenol 100mg
PCML 500mg
CFDR 250mg
PFLX 600mg
#> cat sunny.out
A100
A100
B120
C345

# 4  
Old 03-04-2008
thanks for the solution timj123.

this work if i have know number of columns, what if i don't know how many columns are in this file. this file is ftped to us everyday and i have to remove 1st field data from the file. It may possible that number of columns will be different each time

let me know ur input.

thanks
sunny
# 5  
Old 03-04-2008
Code:
 2:39pm # cat data
A100 Tylenol 100mg
A100 PCML 500mg
B120 CFDR 250mg
C345 PFLX 600mg
 2:39pm # awk '{print $1 > "data.OUT"} ; {a=""; for (i=2;i<=NF;i++) {a=a $i " "} print a} ' data > data.OK
 2:40pm # cat data.OK
Tylenol 100mg
PCML 500mg
CFDR 250mg
PFLX 600mg
 2:40pm # cat data.OUT
A100
A100
B120
C345

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script urgent help please

Hello, I have below string, even I have hundreds of lines in a file. I want to exactly match last two consecutive strings. 2017-09-30|ACBD,TVF|01234|NULL|18|NULL|686091802|BANK OF ABCD, LIMITED, THE|2017-09-30 00:00:00 I want to extract the string 2017-09-30 00:00:00 How can I do... (1 Reply)
Discussion started by: shellquery26666
1 Replies

2. Shell Programming and Scripting

Shell script assistance Urgent

write a script using shift and case to receive 11 argument and do the following --arg1 - print hello message and the current proccess id --arg2 - read and edit a file based on the value which came along with the arg2. --arg3 - validate whether all... (1 Reply)
Discussion started by: saku
1 Replies

3. Shell Programming and Scripting

URGENT Reading a file and assessing the syntax shell script URGENT

I am trying to write a shell script which takes an input file as an arguement in the terminal e.g. bash shellscriptname.sh input.txt. I would like for the file to be read line by line each time checking if the .txt file contains certain words or letters(validating the syntax). If the line being... (1 Reply)
Discussion started by: Gurdza32
1 Replies

4. Shell Programming and Scripting

Need urgent help with korn shell script

Hi All, Need urgent help with korn shell script, which monitors AIX WPARs Status. Basically WPARs run on a LPAR, So there is a Command "lswpar" which displays WPARs status. This script should be checking the WPARs Status and email support if WPAR is down or broken. General lswpar output is as... (3 Replies)
Discussion started by: aix_admin_007
3 Replies

5. Shell Programming and Scripting

URGENT HELP ON A SHELL SCRIPT

I have been asked to create a shell script that accepts a number of SQL select queries as input, runs them in sequence, spools the output to an EXCEL workbook, where, each worksheet is an output of a Select statement run above. The workbook should be in a .XLS format. If a particular select... (1 Reply)
Discussion started by: ShellNovice1
1 Replies

6. Shell Programming and Scripting

Needed urgent help with shell script

Hi, Thanks for the reply to the previous posting.I need a shell script to the following.I am entirely new to the comapny and please help me with this. 1) Create the file with a timestamp i.e. nrt_readership.mmddyyyyhhmm 2) The processing job will look for files of the pattern... (0 Replies)
Discussion started by: pharishraja
0 Replies

7. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

8. UNIX for Dummies Questions & Answers

Need help in shell script (Urgent : Please help)

i have load.bat file in my windows ...IN WINDOWSwe have a loader.exe file which loads the data in some queue.We keep this data in a particular folder i.e "in" folder. Now this loader.exe file picks the data from the "in" folder and loads it in an MQueue.I dont know exactly how this loader.exe file... (8 Replies)
Discussion started by: vnmshenoy
8 Replies

9. Solaris

Urgent help needed - shell script

Dear friends, I am trying to prepare a shell script which do the following task. Being a beginner in scripting I need a bit of help from you all for shell script which does the following job. 1.Check for existence of a file in a shared directory (at some remote location ) once in a day ... (3 Replies)
Discussion started by: aarora_98
3 Replies
Login or Register to Ask a Question