Search Results

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.

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,
...

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...

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...

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....

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

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?

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.

nawk is not an option for me :(

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

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...

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

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 ...

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....

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}'...

I want to create a new file;
print the entire odd line and append the even line but only column 10.

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 ...

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.

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...