What would be useful is, if you could provide a "working example" of the data you have, the files they are in, what data and columns you expect to "grep", and manipulate, what the headings should be, and where that information might come from, and how the result should be presented.
Otherwise, it might take hours, and we'd have to license the answer to you!
Hi, iam learning MySql. Iam trieing to create a table in the database "guestbook"
at the command line in mysql heres what i type but i get a error
mysql>create table guestbook
->(
-> name varchar(40) null.
-> url varchar(40) null.
-> comments ... (3 Replies)
Dear Folks,
If I have 2 files, say A and B in format:
A:
$1 $2
01032 12856
01041 13351
01042 11071
01042 12854
01042 12862
01042 12866
.
.
.
and
B: (2 Replies)
There is table 'DEPT' in the database with the following desciption:
Name Null? Type
------- -------- ------------------------
DEPTNO NOT NULL NUMBER(2)
DNAME NULL VARCHAR2(14)
LOC NULL VARCHAR2(13)
Using shell script, I need to create a structure for the... (2 Replies)
Hi,
I have four input files and would like to create an output file as a table. Please check the example below.
File 1.
111111
222222
333333
444444
File 2.
555555
666666
777777
888888
File 3.
aaaaa
bbbbb
ccccc
ddddd (2 Replies)
Hi
I want create table based on csv file .I have come up with some informations getting columns names and then no idea from that
.Please any help
file.txt
col1|col2|col3|col4|col5
1234|zxxxx|xcvvv|300|null
file.sh
file=$1
c1=`head -1 $file|tr "|" "\n" |cat -n`
echo "$c1"... (31 Replies)
hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname'
for example
... (6 Replies)
I would like to use awk to parse a file with three columns in, like:
Chennai,01,1
Chennai,07,1
Chennai,08,3
Chennai,09,6
Chennai,10,12
Chennai,11,19
Chennai,12,10
Chennai,13,12
Kerala,09,2
AP,10,1
AP,11,1
Delhi,13,1
Kerala,13,3
Chennai,00,3
Chennai,01,1
Chennai,02,1
Chennai,07,5 (3 Replies)
I have a table ABC with 4 columns and below data
Col1,Col2,Col3,Col4
prod,10,12,joba
prod,10,11,jobb
qa,10,12,jobc
I want to create an output file like this
Server:prod
StartTime:10
EndTime:12
JobName:joba
Server:prod
StartTime:10
EndTime:11
JobName:jobb (3 Replies)
Hi,
I required the output like attached:
I tried using the below command and i'm getting error:
file with data:
.TS
box;
cB s s
c|c|c
PO Download statistics - Host to SOM
Time;Receive Time;Processing Time;PO count
4.30 AM OMHPO File;Tue Feb 21 04:39:55 EST 2012;Tue Feb... (3 Replies)
Hi I am trying to create a table within an awk if statement
awk -F, '{ if ($8 ~ /Match/)
BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' SN1.csv | mailx -s "Your details" abc@123.com
But this doesnt work..
Please suggest (8 Replies)