Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help require for vLookup Utility same as in EXCEL

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help require for vLookup Utility same as in EXCEL
# 8  
Old 01-04-2013
Still not:
Code:
line 7: syntax error near unexpected token `done'
line 7: `done > File3b.txt

---------- Post updated at 09:28 PM ---------- Previous update was at 09:25 PM ----------

Still not getting through:
Code:
line 7: syntax error near unexpected token `done'
line 7: `done > File3b.txt

Last edited by Franklin52; 01-04-2013 at 12:52 PM.. Reason: code tags
# 9  
Old 01-04-2013
Very odd. It works fine for me on AIX 4.3.3, 5.1 (yes I know they're pretty old!) & 6.1 and also on RH Linux 6. Did you save the attachment and FTP it to the server, or copy & paste the contents?



Robin
# 10  
Old 01-04-2013
im running this through Cygwin
# 11  
Old 01-04-2013
Well, I think that is just an X-windows server. What is the underlying Unix server you are using?

Did you just paste the contents of my file into the screen or did you save them, FTP them to the server and then run them as a script?



Robin
# 12  
Old 01-04-2013
i saved the content into another text file, renamed it as .sh and then executed it on Windows-machine through Cygwin...i am using cygwin as i do not have any linux machine to execute...Smilie
# 13  
Old 01-04-2013
Could I direct you to look at the Cygwin home page here

The section that states what it isn't makes me worry that we're trying to do something that Cygwin is not designed for. You might well be better with a DOS batch file, an Excel Macro or some Visual Basic code etc.

If anyone wants to leap in and correct me, feel free as I am happy to learn.




Robin
# 14  
Old 01-04-2013
Me2....however i am using Cygwin for all my shell scripts and it is working fine....let me see if i can get a linux server from my friend...or will ask him to test their...whether it works...


alternately if someone has some suggestion to this problem....pls WELCOME..



also if someone can help me with a different code for my second request....that would be great... Smilie

thanks
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Vlookup on 2 files - inserting vlookup command on another command

Hello, i am trying to print group name column(etc/group) on script (etc/passwd) since group name is not listed on etc/passwd columns. Im trying to do a vlookup. but i cant figure out how i can insert the vlookup command FNR==NR inside the print out command or the output. I also tried exporting... (2 Replies)
Discussion started by: joonisio
2 Replies

2. Shell Programming and Scripting

Vlookup in Linux

Hello Everybody I am looking for vlookup like functionality in Linux since two files I have are very big(1000MB each) and its not opening completely in excel. Here the requirement file1 11,12,13 16,14,12 28,21,22 22,23,24 file 3 18,16,16 14,12,12 23,22,24 16,11,13 here... (8 Replies)
Discussion started by: shanul karim
8 Replies

3. Shell Programming and Scripting

Excel vlookup function like value mapping with awk

I have two files File1 175552 st_497858.1 rs86052.1 rs92185.1 st_001022416.1 174841 175552_174841 179912 st_001122967.2 rs90435.1 rs89122.1 st_001022583.1 175545 179912_175545 179912 st_001122967.2 rs90435.1 rs89122.1 st_001022584.1 175545 179912_175545 179967 st_001256606.1 rs93516.2... (1 Reply)
Discussion started by: sammy777888
1 Replies

4. Shell Programming and Scripting

Vlookup using awk

Hi folks, awk 'NR==FNR {m=$0; next} $1 in m{$0=m} {print}' file2 file1 Works a charm for a vlookup type query, sourced from https://www.unix.com/shell-programming-and-scripting/215998-vlookup-using-awk.html However my column content has white spaces and numbers. Example file1 The Man... (6 Replies)
Discussion started by: pshields1984
6 Replies

5. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

6. Shell Programming and Scripting

Vlookup using awk

Hello, I am trying to use vlookup (Excel function) using awk but there is some problem :( --file1-- ABC123 101F X1 A $P=Z X2 A $P=X X3 B $P=F X4 C $P=G MNK180 END --file2-- X1 A_t $P=Z X2 A_t $P=X X3 B_u $P=F X4 C_o $P=G (2 Replies)
Discussion started by: young
2 Replies

7. Shell Programming and Scripting

How to Unzip a file using unzip utility for files zipped without zip utility ?

Hi, I need to zip/compress a data file and send to a vendor. The vendor does have only unzip utility and can accept only .ZIP files. I do not have zip utility in my server. How do I zip/compress the file so that it can be deflated using unzip command ? I tried gzip & compress commands, but... (1 Reply)
Discussion started by: Sabari Nath S
1 Replies

8. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies

9. Shell Programming and Scripting

Want to implement VLOOKUP (Excel function) in Unix

Dear All, i want to implement vookup function which is there in excel into Unix. Suppose i have 2 files. The files are given below. File1: MSC Cell SDCA Patna-1 12 Bihar Patna-2 45 Ranchi Bhopal-1 85 Raigarh Bhopal-2 ... (8 Replies)
Discussion started by: pravani1
8 Replies

10. Shell Programming and Scripting

VLOOKUP utility in UNIX

Kindly help me to build the script similar to VLOOKUP function of MS Excell. (5 Replies)
Discussion started by: hjoshi
5 Replies
Login or Register to Ask a Question