Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help with Flat Files Please!! BASH (New User)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help with Flat Files Please!! BASH (New User)
# 1  
Old 02-27-2006
Question Help with Flat Files Please!! BASH (New User)
Hello All,

I am brand new to the UNIX world and so far and very intrigued and enjoy scripting. This is just a new language for me. I would really like assistance with the below request. Any help would be greatly appreciated!

I want to create a flat file in Vi that has a header field and entries in each field. I then need to run a script that will ask me what I'm looking for and then return the data to a file.

Example:

First_Name,Last_Name,Phone#,City,State
John,Doe,5055551212,Albuquerque,NM
Jane,Doe,8085551212,Maui,HI
Bob,Doe,8085551212,Honolulu,HI

Now I would like the script to ask me "what are you looking for? First_Name, Last_Name, Phone#, City, State.

Then say for example I choose State.

It would then reply with choose a State.

I would enter HI

It would then output all entries from the State of HI to a file.

Is this possible or am I expecting to much from this script?

Thanks
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. OS X (Apple)

Create a bash array from a flat file of whitespaces only.

Hi guys and gals... MacBook Pro. OSX 10.13.2, default bash terminal. I have a flat file 1920 bytes in size of whitespaces only. I need to put every single whitespace character into a bash array cell. Below are two methods that work, but both are seriously ugly. The first one requires that I... (7 Replies)
Discussion started by: wisecracker
7 Replies

2. Shell Programming and Scripting

Converting Multiline Files to Flat Files?

How to convert this: F1-R1 F1-R2 F1-R3 into a flat file for bash?? Each record F2-R1 F2-R2 F2-R3 F3-R1 F3-R2 F3-R3 F4-R1 F4-R2 F4-R3is on one line with all fields for that record, put into an output file. The output file should look like this when converted: F1-R1,F2-R1,F3-R1,F4-R1... (6 Replies)
Discussion started by: bud1738
6 Replies

3. Shell Programming and Scripting

Compare to flat files using awk

compare to flat files using awk .but in 4th field contains non ordered substring. how to do that. file1.txt john|0.0|4|**:25;JP:50;UY:25 file2.txt andy|0.0|4|JP:50;**:25;UY:25 (4 Replies)
Discussion started by: veeruasu
4 Replies

4. Programming

Scripting using flat files

I need some help to create a script that can do the following: I have two flat files with one column that should link the two files' information into one record: 1st Flat File - 3 columns, multiple rows: orderid, Jobnumber, Ordernumber 2nd Flat File - 2 columns, multiple rows: ... (4 Replies)
Discussion started by: Lavelle
4 Replies

5. Infrastructure Monitoring

Possible performance improvement (Bash and flat file)

Hello, I am pretty new to shell scripts and I recently wrote one that seems to do what it should but I am exploring the possibility of improving its performance and would appreciate some help. Here is what it does - Its meant to monitor a bunch of systems (reads in IPs one at a time from a flat... (9 Replies)
Discussion started by: prafulnama
9 Replies

6. Shell Programming and Scripting

Compare 2 flat files

Hi Frnds, I have a flat file with millions of records. . Now I on this. (I prefer for AWK as its gives good performance.) Old_file.txt ------------------ 1 gopi ase .... 2 arun pl ... 3 jack sutha .. 4 peter pm .. ... New_file.txt --------------- 4 peter pm .. .. ... (12 Replies)
Discussion started by: Gopal_Engg
12 Replies

7. Shell Programming and Scripting

Compare 2 flat files

Hi Gurus, I searched the forum but didnt get much info. I want to compare 2 files. 1)Newfile comes today with 2)Old file of previous day. The files are same ,just the new files might have new records sometimes. So I want to capture these new records in another file. Can anyone help... (5 Replies)
Discussion started by: ganesh123
5 Replies

8. Shell Programming and Scripting

Column names in flat files

Hi all, I want to create column names in a flat file and then load the data through some other application. For example, I have a file with emp.txt and I need column names as eno,ename,sal in the first line. The delimiter here is comma and record delimiter is end of line or unix new line. Could... (1 Reply)
Discussion started by: srivsn
1 Replies

9. UNIX for Dummies Questions & Answers

How to join flat files together under unix

Hi, I have 7 big flat files, each contains 24 million records which have been sorted by the first field delimitered by Ctrl B (002). I want to join them together side by side, eg. File A: 1^Ba^Bb 2^Bx^By .... File B: 1^Bc^Bd 2^Bm^Bn .... After merged, it should look like :... (7 Replies)
Discussion started by: xli
7 Replies

10. Shell Programming and Scripting

Flat Files

I have a flat file like this 0001 THER ULT HEAD & NECK VES 0002 THER ULTRASOUND OF HEART 0003 THER ULT PERIPHERAL VES 0009 OTHER THERAPEUTIC ULTSND 0010 IMPLANT CHEMOTHERA AGENT 0011 INFUS DROTRECOGIN ALFA 0012 ADM INHAL NITRIC OXIDE I need to conver this to a comma delimited flat file... (2 Replies)
Discussion started by: thumsup9
2 Replies
Login or Register to Ask a Question

LEARN ABOUT OSF1

sh

sh(1)							      General Commands Manual							     sh(1)

NAME

       sh - Shell, the standard command language interpreter

DESCRIPTION

       [Tru64  UNIX]  Tru64  UNIX  provides two command interpreters with the name sh.	The XCU5.0 and POSIX.2 compliant command interpreter sh is
       available in the file /usr/bin/posix/sh and is described in the sh(1p) reference page.  The Bourne shell,  historically	known  as  sh,	is
       available in the file /usr/bin/sh and is described in the sh(1b) reference page.

       [Tru64 UNIX]  Your initial, or login, shell is determined by your entry in the file /etc/passwd. This file can be changed only by your sys-
       tem administrator. You must use whatever procedures are in place at your location to have this entry changed.

       [Tru64 UNIX]  If available on your system, you may use the passwd -s or the chsh commands to change your login shell.

									  Note

       This option is not available if your site manages passwords through the Network Information Service (NIS) facility.  Check with your system
       administrator.

       [Tru64 UNIX]  Subsequent shells spawned from the initial shell depend on the value in the environment variable BIN_SH.  If this variable is
       set to xpg4, the POSIX shell is started. If this variable is set to svr4, an SVR4 compliant version of the shell is started. If this  vari-
       able  is  unset,  the  Bourne shell is started. If this variable is set to any other value, an error is reported and the results are unpre-
       dictable. See the EXAMPLES section for information on setting this variable.

NOTES

       [Tru64 UNIX]  With Tru64 UNIX Version 4.0 the Korn shell, /usr/bin/ksh is the same as the POSIX shell /usr/bin/posix/sh.

RESTRICTIONS

       [Tru64 UNIX]  The file /etc/shells must include entries for both the POSIX shell /usr/bin/posix/sh and the Bourne  shell,  /usr/bin/sh.	If
       this file is incorrect, see your system administrator.

EXAMPLES

       Using  the  Bourne,  Korn,  or  POSIX  shell, to set the variable BIN_SH to use the POSIX/ XCU5.0compliant shell, enter: BIN_SH=xpg4 export
       BIN_SH Using the Bourne, Korn, or POSIX shell, to set the variable BIN_SH to use the SVR4 compliant shell, enter: BIN_SH=svr4 export BIN_SH
       Using the Bourne, Korn, or POSIX shell, to unset the variable BIN_SH, enter: unset BIN_SH Using the C/ shell, to set the variable BIN_SH to
       use the POSIX/XCU5.0 compliant shell, enter: setenv BIN_SH xpg4 Using the C/ shell, to set the variable BIN_SH to use  the  SVR4  compliant
       shell, enter: setenv BIN_SH svr4 Using the C/ shell, to unset the variable BIN_SH, enter: unsetenv BIN_SH

FILES

       User profile.  Contains user information, including the login shell name.  Contains the names of available and permitted shells.

SEE ALSO

       Commands:  csh(1), ksh(1), Bourne shell sh(1b), POSIX shell sh(1p), passwd(1)

       Files:  passwd(4), shells(4)

       Standards:  standards(5)

																	     sh(1)