Visit The New, Modern Unix Linux Community

Search Results

Search: Posts Made By: mykey242
5,507
Posted By mykey242
I run psql with command options from #!/bin/sh ...
I run psql with command options from #!/bin/sh

i actually figured it out

AND
dataset.create_time < (current_date - interval '3 months')

was added to the end of the file.
5,507
Posted By mykey242
PostgreSQL view output older than 90 days
I am trying to find the correct syntax to give me row output only older than 90 days. I am using psql NOT mySQL or MSSQL!

Here is the sql command i am running

SELECT
dataset.id,
...
1,235
Posted By mykey242
i could not get the close statement to work. I...
i could not get the close statement to work. I decided to create a reference file for now.
printed the user column and removed duplicates to file userlist.txt
created script to read per line from...
1,235
Posted By mykey242
input data file user1 file1.txt ...
input data file

user1 file1.txt %datecreated% file_size
user1 file2.txt %datecreated% file_size
user1 file3.txt %datecreated% file_size
user2 file4.txt %datecreated% file_size...
1,235
Posted By mykey242
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....
Forum: Linux 05-20-2011
1,338
Posted By mykey242
compression of large (3-4 GB each) data sets ...
compression of large (3-4 GB each) data sets
speed = able to handle 300-400 files at once
system resources can not cripple the machine.

bzip2 works but we need to look at other possibilities
Forum: Linux 05-20-2011
1,338
Posted By mykey242
General compression question
I am looking for an alternate solution other than gzip or bzip2 to compress files that are 3 to 4 GB each and will be hundreds per day. Aside from increasing storage anybody found a good tool?
4,755
Posted By mykey242
Yes the awk method worked. Thank you very much. ...
Yes the awk method worked. Thank you very much.
I am getting more in depth with awk at my job, any good study guides to suggest. currently only finding targeted related scenarios in my searches.
4,755
Posted By mykey242
nawk is not an option for me :(
nawk is not an option for me :(
4,755
Posted By mykey242
awk padding column
Hello, i am trying to pad a column

A1
A2
A10
B2
B8
B12

to look like

A01
A02
A10
B02
B08
B12


using awk
957
Posted By mykey242
i hit enter too soon. the two small files both...
i hit enter too soon. the two small files both have column two, i want to append to the original file associated with. example:
Plate_1 xxxxx and A30590GVS
Plate_2 xxxxx and A30590GVS
Plate_3...
957
Posted By mykey242
med.txt and dev.txt have two coulmns. Plate_1 to...
med.txt and dev.txt have two coulmns. Plate_1 to Plate_4 three times. Reason is the first big file at the first column has only three values:
A3059GVS, A3059GVT, A3059GVU
957
Posted By mykey242
combine 3 files by grouping
I have a file, which is really large but i shortened it:

A3059GVS 1 A 01 Plate_1 40 25.37016 14.6298
A3059GVS 2 A 01 Plate_2 40 ...
3,279
Posted By mykey242
This has been resolved. It turned out the...
This has been resolved. It turned out the original file was from a windows machine and created a carraige return which always caused the second line. had to perform dos2unix to convert the file....
3,279
Posted By mykey242
Trying a different approach. goal: print even...
Trying a different approach. goal: print even line and then odd line. worry about sorting after this goal is met.
awk -v FS="\t" -v OFS="\t" '(NR%2)==1 { temp=$0} (NR%2)==0 { print temp, $0}'...
3,279
Posted By mykey242
I want to create a new file; print the entire...
I want to create a new file;
print the entire odd line and append the even line but only column 10.
3,279
Posted By mykey242
i trimmed the files to keep it easier but here is...
i trimmed the files to keep it easier but here is my input file:
1 A 01 Plate_1 1 A3059GVS sample cib Endogenous Control 25.37016 0.6680705 ...
3,279
Posted By mykey242
Apologies, i want the 4 columns from the first...
Apologies, i want the 4 columns from the first line and only the 6th column from the second line. output combined in one line.

currently my print comes out in two lines.
3,279
Posted By mykey242
awk and combining lines to stdout
I am trying to come up with a good approach to taking a file and only printing 10 columns.
The input file has duplicate lines but only the 6th column has real value.
I just need to combine the...
Showing results 1 to 19 of 19

 

Featured Tech Videos

All times are GMT -4. The time now is 07:35 PM.
Unix & Linux Forums Content Copyright 1993-2020. All Rights Reserved.
Privacy Policy