Search Results

Once again thank you! That worked great.

Thank you again!

Once last question as I'm sure they will change the data on me again at some point. How would I compensate for a change to the data where they leave off the "M"? like in the...

Ok that totally work can you explain how that worked? I did not have any idea that awk would have done that.

Thank you!!!!

Hi Everyone,
Im currently using the below code to pull data from a large CSV file and put it into smaller files with just the data associated with the number that I "grep".

grep 'M053'...

Thank you that worked great!!!

Now I get my data just like I need it. I will look over this code and see what I was missing....thank you a bunch!!! Below is what I can now get from my API and...

awk -F, '{n=split ($6, T, " "); print T[1], T[2]}' file.csv

1 h
9 d
21 h
1 h
1 h
1 h
3 d
7 d
7 d
1 h
1 h
1 h
1 h
I get these results

---------- Post updated at 02:56 PM ----------...

awk -F, '{n=split ($6, T, " "); print T[1]}' file1h4m
1h21m
1h21m
1h20m
1h20m
1h19m
1h18m
1h18m
That worked....This is what I get back but how would I now sort this and show the entire line...

I do but I want to be able to sort off the number of d(ays). So if something is older than 14 days I can get back just the lines that are >=14 in that column.

They both did the same thing they listed the letter after the number in the 6th column. Sorry but Im not sure how I would be able to use this?

Could I just remove all "spaces" from the file? Then run the awk command? Using the [,] as field separator?

This is a nice piece of code THANKS! It showed me that I sometimes have 12 fields or 13 or 14. I would guess that this is where my problem is. This is where I now think a while loop or something...

124mob7,iOS 8.3,iPad Air 2,6.3,DMPNRMTHG5VJ,1 h 4 m,908D6C582D84
M215POD2,iOS 8.3,iPod touch 5th gen,6.2,CCQPM37YFMJF,10 d 22 m,48E9F12FD989
M155POD072,iOS 8.2,iPod touch 5th...

Ahhh.....now I see it. Thanks Again!

Fantastic that worked!!!

Any chance you can explain how that worked?

What does the $4=="d" do? Is that looking 4 placed in front of d?

Thank you this is helpful but still not 100% what I need.

This brings back data that has h(hours) and m(inutes) I need to get data that is only for x-number of d(ays) and this is also stopping at...

Thanks I tired that as well it works as well!!!

Now I have a new problem how would I set the sort to show any number of days like if I wanted to show data that was 14 D or older? Also the...

Awesome thanks that worked!

Yes its only listing days and hours

Hi Everyone,

I need help on figuring out a way to filter some data that I get back from an API. Im able to get all the data that Im looking for but I would like to know a way for me to filter it...