create data file from report file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers create data file from report file
# 1  
Old 01-27-2008
MySQL create data file from report file

Dear Ones,
kindly help me to create a data file from the report file as shown here under( i am new one to unix KNOW BASIC COMMANDS)

file:rama.prt

(ist record)(3 to 4 lines of text with different filed names)
Name :M.LALITHA DOB:12/11/45 DESG :JA(P)
STANO:300175 DOA:11/12/07 BASIC:3020.0

(2nd record)(same 3 to 4 lines of text with different DATA same filelds)
NAME :M. RAJA DOB:10/10/65 DESG:CLEANER
STANO:10045 DOA:10/10/07 BASIC:1000.0

I WANT OUTPUT LIKE THIS SO WE CAN USE THIS DATA FILE AT ANYWHERE AND ALSO IN FOX PRO

M.LALILTHA 12/11/45 JA(P) 300175 11/12/07 3020.0 (SO ON...)
M.RAJA 10/10/65 CLEANER 10045 10/10/07 1000.0 (SO ON..)
(THE OUTPUT MAY TAB SEPARATOR ARE DELIMITED WITH" ",OR COMMAS

ADVACE THANKS TO SENIORS AND REQUEST TO GIVE SOLUTION
URS FAITHFULLY
MURTHY
# 2  
Old 01-28-2008
data from csv

give the exact details, from which field onward the name starts and
dob starts and from which line onward?? So that you can use different
commnd. Will you give real data starting from which line after the heading and the real data start point ??
Smilie
# 3  
Old 02-01-2008
create data file from report file

hello sir i have report file lilke this


some heading
1 Name:rama rao dob:20/11/07 doa:10/12/07
faname:raja rao basic:2000 .............
.................

2 Name:sita ........................................

like 4 to 5 lines of text for one record and then second recod continues.

we can grep every record name, dob, doa ....for one record

i want to create a data file like

name dob doa fname basic
rama rao 20/11/07 10/12/07 raja rao 2000
..............

kindly give me hlep
# 4  
Old 02-01-2008
data from csv

dear friend why I have asked to give excat numbers of line of heading , b'coz the grep comd will start from that line onward only for that reason I have asked to give two records with the heading and can give solution .
Any way you can use grep comd with ~ (tilde) and also sed commd
for conveting the report file to data file say your particular digit's starting position is uniq than you can use either of the grep/sed and make data file.
Smilie
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

2. Shell Programming and Scripting

create txt file form data file

File A.txt LL07 LL07_B_1 20 LL85 LL85_A_1 40 LL85 LL85_B_1 40 LL85 LL85_C_1 30 LL37 LL37_A_1 60 LL37 LL37_B_1 20 LL37 LL37_C_1 50 I want cretae diffrent tex file base of above file Should be threee text file LL07.txt LL85.txt LL37.txt Eaach text file have below data... (2 Replies)
Discussion started by: asavaliya
2 Replies

3. Shell Programming and Scripting

create txt file form data file and add some line on it

Hi Guys, I have file A.txt File A Data AK1521 AK2536 AK3164 I want create text file of all data above and write some data on each file. want Output on below folder /home/kka/out AK1521.txt Hi Welocme (3 Replies)
Discussion started by: asavaliya
3 Replies

4. Shell Programming and Scripting

Copy data form File A and Create File B

File A I have list of : ABCND1 ABCND2 ABCnd3 ABCnd4 I want file B like below Start+ S Pate=ABCND1 AAlo1 S Pate=ABCND1 Q1234 S Pate=ABCND1,P12345 (7 Replies)
Discussion started by: asavaliya
7 Replies

5. Solaris

Create file for group of data:

Hi folks, I have the following data.Any help is greatly appreciated. order File_name 7222245 7222245.pdf 7222245 7222245a.pdf 7222245 7222245b.pdf 7222245 7222245c.pdf 7222245 7222245d.pdf 7222250 ... (1 Reply)
Discussion started by: kumar444
1 Replies

6. Shell Programming and Scripting

Create a report for client with a text data file

Hi, I am an amateur bash scriptwriter and I need to write a script which creates a report in a formatted, easy to read table-like that is displayed to standard output. The script has to export the followings: Process ID,User Name, Command Name,Priority..... Now I have a file that I can see all... (3 Replies)
Discussion started by: bashily
3 Replies

7. Shell Programming and Scripting

How to cut data from file and create another file.

I have file which has more than 1000 lines. PFB file info Line 1. <SOAP-ENV:Envelope SOAP-ENV:encodingStyle="" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAPSDK1="http://www.w3.org/2001/XMLSchema" xmlns:SOAPSDK2="http://www.w3.org/2001/XMLSchema-instance"... (8 Replies)
Discussion started by: humaemo
8 Replies

8. Shell Programming and Scripting

create a new file from data file from a column

I have a data file that has a list of data macthing by user. I am able to sort by user and there is multiple rows for each user. Ideally I would like to email only the user of the files they own. Would it be best to create a seperate file by user and all rows showing the files they own? (9 Replies)
Discussion started by: mykey242
9 Replies

9. Shell Programming and Scripting

How to format or create a matrix report from file

Dear Unix champs, I have a input file as attached, i would like to create an report from the file as below FileType | EQUENS0001 | EQUENS0002 | EQUENS1100 | EQUENS0003 --------+-------------------------------------------------------- Msg No |... (3 Replies)
Discussion started by: manas_ranjan
3 Replies
Login or Register to Ask a Question