reading fixed length flat file and calling java code using shell scripting


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting reading fixed length flat file and calling java code using shell scripting
# 1  
Old 08-03-2009
reading fixed length flat file and calling java code using shell scripting

I am new to shell scripting and I have to to the following

I have a flat file with storename(lenth 20) , emailaddress(lenth 40), location(15). There is NO delimiters in that file.

Like the following str00001.txt

StoreName emailaddress location
---------------- ------------------ -----------
xxxxxxx iiiiiiiiii@yahoo.com mmmmm
yyyyyyyyyyy acb@gmail.com lllllllllllllllllllllllll
zzz zzz@email.com ujeuri


I have to read line by line in the flat file get the email address and location and then make a call my java servlet by passing in the URL
1. Read line by line
2. Set email address and location in a variable
String email = "acb@gmail.com”;
String loc = “lllllllllllllllllllllllll”;
3. set it my url like this (i know how to call the servlet through shell scripting)

http://localhost:8080/emailer/sslPages/sendemailservlet?emailAddress= email% location= loc
4. process next line from the flat file (loop until end of the file)
5. end of the loop I have to delete str00001.txt file

# 2  
Old 08-04-2009
Read flat file without delimiters(fixed length)

Hi Gurus,

Thanks in advance...

I am new to writing shell scripting and help me out reading a flat file with fixed length.


I have a fixed length flat file with storename(lenth 6) , emailaddress(lenth 15), location(10). There is NO delimiters in that file.

Like the following str00001.txt

StoreName emailaddress location
---------------- ------------------ -----------
xxxxxxiiiiiiiiii@yahoo.com mmmmm
yyyyy aewwcb@gmail.com lllllllllllllllllllllllll
* zzzz@email.com ujeuri


I have to read line by line in the flat file get the email address and location.and set it in a string
1. Read line by line
2. Set email address and location in a variable
String email = "
iiiiiiiiii@yahoo.com”;
String loc = “
mmmmm”;
4. if
(email == null)
throught error
else loc == null
thorugh error
5. end of the loop I have to delete str00001.txt file
# 3  
Old 08-04-2009
Just yesterday was this example.

---------- Post updated at 08:44 AM ---------- Previous update was at 08:42 AM ----------

Add this test after you parsed the fields.
Code:
if [ "$email" = "" ] ; then
   echo "no email" >&2
else
   loc=""
fi

# 4  
Old 08-04-2009
Use the dd command to add carriage control information to the file. Write the output of the dd command to a new temp file or you can read from stdout
Code:
dd if=inputfile  cbs=75 conv=unblock | 
while read junk email location
do
  # your code here
done

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Help on Shell Scripting - to store output to a fixed file

Hi I have a file called "test.txt" and it looks like this x y z x/c y/c/b now, i want to run a command and its output will be like this x 10 y/c/b 20 z 78 -------- my requirement is, i want to add the command output to "test.txt" as like below x 10 y ... (1 Reply)
Discussion started by: siva kumar
1 Replies

2. Shell Programming and Scripting

How to add trailer record at the end of the flat file in the unix ksh shell scripting?

Hi, How to add trailer record at the end of the flat file in the unix ksh shell scripting can you please let me know the procedure Regards Srikanth (3 Replies)
Discussion started by: srikanth_sagi
3 Replies

3. Shell Programming and Scripting

Flat file-make field length equal to header length

Hello Everyone, I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table. Input Data- ------ ------------------------ ---- ----------------- WFI001 Xxxxxx Control Work Item A Number of Records ------ ------------------------... (5 Replies)
Discussion started by: sonali.s.more
5 Replies

4. Shell Programming and Scripting

Fixed length flat file extraction

Hii ,I am new to Unix ,i have a flat file which is (fixed length) sitting in unix,Which is holding the data for a table.I want to extract one column(length7-10) on the basis of another column(length13-15) and want only one single row Example: Below is the sample of flat file. 1111 AAAA 100 ... (4 Replies)
Discussion started by: laxmi1166
4 Replies

5. Shell Programming and Scripting

how to read fixed length flat file....

Hi Gurus, Thanks in advance... I am new to writing shell scripting and help me out reading a flat file with fixed length. I have a fixed length flat file with storename(lenth 6) , emailaddress(lenth 15), location(10). There is NO delimiters in that file. Like the following str00001.txt... (2 Replies)
Discussion started by: willywilly
2 Replies

6. Shell Programming and Scripting

Exporting a flat fixed length file (Urgent)

Hi All, So far, I've been extracting data from db2 tables and exporting the file as a tab delimited file into a UNIX server using the following command: export to /.../.../.../.../.../SM_RAW_DATA.dat of del modified by coldel| nochardel select a.accno, a.CUR_BL_AM, ... (1 Reply)
Discussion started by: jj2485
1 Replies

7. UNIX for Dummies Questions & Answers

Conditional sorting on fixed length flat file

I have a fixed length file that need to be sorted according to the following rule IF B=1 ORDER by A,B Else ORDER by A,C Input file is ABC 131 112 122 231 212 222 Output needed ABC 112 131 122 212 231 222 (1 Reply)
Discussion started by: zsk_00
1 Replies

8. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies

9. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

10. Shell Programming and Scripting

Fixed Length records- Korne Shell Program.

Hi, I need some help regarding in writing a Korne shell script, in determining the fixed length records in a data file. We have already utility in place, which does this work. The Code for this is as below. In the below $1 is the parameter passed to the script, which is the data file name. ... (4 Replies)
Discussion started by: nrajesh_2009
4 Replies
Login or Register to Ask a Question