Create new file by searching another file Post: 42541

Sponsored Content

Top Forums Shell Programming and Scripting Create new file by searching another file Post 42541 by Simerian on Thursday 30th of October 2003 04:08:42 PM

10-30-2003

Registered User

Of course, if you wished to proceed using solely the ksh, you could replace if the many if statements with a case/esac.

Also, I would cut up each record as follows:

Code:

cat inputfile | while read inputrecord
do
   echo ${inputrecord} | read tagfield datafield
   case ${tagfield} in
      "e-mail") F1=${datafield};;
      "forename") F2=${datafield};;
      "middlename") F3=${datafield};;
      "surname") F4=${datafield};;
         echo "${F1},${F2},${F3},${F4}"
         unset F1 F2 F3 F4
         ;;   
   esac
done

Note the code above assumes that the surname field is always last!

Simerian

View Public Profile for Simerian

Find all posts by Simerian

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Append a field to the end of each line of a file based on searching another file.

Hi All, I have two comma separated value(CSV) files, say FileA and FileB. The contents looks like that shown below. FileA EmpNo,Name,Age,Sex, 1000,ABC,23,M, 1001,DES,24,F, ...

2. Shell Programming and Scripting

searching a log file and appending to a .txt file

I'm new to shell scripting and am writing a script to help me log the free memory and hd space on a server. As of now, the script just runs 'df -h' and appends the output to a file and then runs 'top' and appends the output to a log file. What I want to do, is have the script also search the...

3. Shell Programming and Scripting

create file as variable for searching point

Hi Friends, I need expert help:), I have bellow script that function for searching string in multiple file, the script is working well. but I thing it still can be optimize since so many repetition in bellow command, where string that I marked BOLD italic is clue for what I am looking for...

4. Shell Programming and Scripting

Searching for Log / Bad file and Reading and writing to a flat file

Need to develop a unix shell script for the below requirement and I need your assistance: 1) search for file.log and file.bad file in a directory and read them 2) pull out "Load_Start_Time", "Data_File_Name", "Error_Type" from log file 4) concatinate each row from bad file as...

5. UNIX for Dummies Questions & Answers

Help with searching for a file in a directory and copying the contents of that file in a new file

Hi guys, I am a newbie here :wall: I need a script that can search for a file in a directory and copy the contents of that file in a new file. Please help me. :confused: Thanks in advance~

6. Shell Programming and Scripting

Help in searching a particular string in a file name (not inside the file contents)

Dear Unix Gurus, I am new to shell scripting and in the process of learing. I am trying to find whether a file name has today's date in MMDDYYYY format. I am using the following code and it doesn't seem like working. #!/usr/bin/ksh today=$(date '+%m%d%Y') echo today: $today file=`find...

7. Shell Programming and Scripting

searching a file with a specified text without using conventional file searching commands

without using conventional file searching commands like find etc, is it possible to locate a file if i just know that the file that i'm searching for contains a particular text like "Hello world" or something?

8. Shell Programming and Scripting

Searching a file inside a .tar.gz file by date

Hi, I would like to ask if there is a way to search for a file inside a .tar.gz file without extracting it? If there is, is there a way to search for that file by date? Thanks!

9. Shell Programming and Scripting

Searching the content of one file using the search key of another file

I have two files: file 1: hello.com neo.com,japan.com,example.com news.net xyz.com, telecom.net, highlands.net, software.com example2.com earth.net, abc.gov.uk file 2: neo.com example.com abc.gov.uk file 2 are the search keys to search in file 1 if any of the search key is...

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Append a field to the end of each line of a file based on searching another file.

Discussion started by: ultimate

2. Shell Programming and Scripting

searching a log file and appending to a .txt file

Discussion started by: enator45

3. Shell Programming and Scripting

create file as variable for searching point

Discussion started by: budi.mulya

4. Shell Programming and Scripting

Searching for Log / Bad file and Reading and writing to a flat file

Discussion started by: mlpathir

5. UNIX for Dummies Questions & Answers

Help with searching for a file in a directory and copying the contents of that file in a new file

Discussion started by: zel2zel

6. Shell Programming and Scripting

Help in searching a particular string in a file name (not inside the file contents)

Discussion started by: shankar1dada

7. Shell Programming and Scripting

searching a file with a specified text without using conventional file searching commands

Discussion started by: arindamlive

8. Shell Programming and Scripting

Searching a file inside a .tar.gz file by date

Discussion started by: erin00

9. Shell Programming and Scripting

Searching the content of one file using the search key of another file

Discussion started by: csim_mohan