Search Results

Hi, garydeena thanks for your suggestion and Scrutinizer thanks for your explanation! It's so helpful!

Hi balajesuri,
I am still getting confused about this code. What does it mean?
/.*\//,""

Hi RudiC,

thanks for your help!
But i don't know yet about this code
sub(/.*\//,"", $1)

Would you mind to tell me about it? Thanks in advance

Hi, all

I need your help and suggestions.
I want to print particular strings in a field of a csv file and show them in terminal. Here is an example of the csv file.
...

Hi, all

Finally i have figured how to deal with this problem. I have edited Don Cragun's script. This is my script and it works well with my whole script.
(head -1 $result && tail -n+2 $result |...

Hi RudiC,

When i run those script individually as Don Cragun wrote, it can work well. But when i try to put them in my whole script, like this:
..... (matching fields script using awk)
}'...

Hi, Don Cragun

Sorry for posting my new problem in my previous thread. I have tried your coding. But, it doesn't work with my whole program/script. The program doesn't want to execute those...

Hi, all

I have a csv file that I would like to remove duplicate lines based on 1st field and sort them by the 1st field. If there are more than 1 line which is same on the 1st field, I want to...

Hi,

I have another problem. I want to sort another csv file by the first field.
result.csv
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw...

Hi, RudiC

Thanks for your help. Would you mind to explain those script to me? I don't understand yet about it. Thanks in advance.

Regards,
Intan

---------- Post updated at 12:36 AM...

Okay, i got it. Thank you so much, protocomm! :D

Thank you so much, protocomm!:D

There is something I want to ask you, why does the script print the fifth field? I dont understand it yet. Thank you.

Regards,
Intan

Thank you so much, Akshay Hegde!:D

Wow, thank you protocomm and Akshay Hegde for your help!:D

But I don't understand yet about the script. Would you mind to explain it to me? Thank you.

Regards,
Intan

Hi, all

I need your help and suggestions.
I want to print particular strings in a field of a csv file and show them in terminal. Here is an example of the csv file.
...

Thanks for your helps, balajesuri, Don Cragun and vgersh99! :D

Now I can save my csv file as csv file itself. and personally, i like one line code because it looks simple and not complex. So, i...

Hi, all

I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file.

test.csv
SourceFile,DateTimeOriginal...

Hi, Don Cragun

Thanks for your help. I have tried to run your code and it works successfully! Thank you so much!:D

Regards,
Intan

I have tried the code and edited some part, like this:
#! /bin/bash

awk -F, 'BEGIN {OFS=","} FNR==NR && FNR>0 {f1[$NF]=$1;next} {idx=($1 " " $2);gsub("/", ":",idx);if (idx in f1);print...

Hi, RudiC
Would you mind to explain it to me?

Intan

Hi, vgersh99
Thanks for your help! I have tried to run your code and i think it works. But, i don't know where the output is saved to. I just can't find new csv file of the output. Would you mind...

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