All Questions
19
questions
-1
votes
3
answers
686
views
Searching in a CSV for multiple values and get the associated values from it
I have a file.csv
"ItemNo","Name","Weight"
"a001","Item a","1.1"
"a002","Item x","1.2"
"a003","...
-3
votes
1
answer
153
views
Splitting a line in CSV to two columns
I have a CSV where each line is like below
**./ABC/dce/app/config/fgh/pqr/app.properties** **app.pass**
I want to use space as the seperator and get two seperate columns in the CSV like below
...
0
votes
0
answers
35
views
Filter csv file with AWK passing a variable in the regex [duplicate]
I need to filter a very large csv file in the most efficient way. I already tried csvgrep but is not efficient timewise, so I'm now trying to use AWK for this task.
The csv file has a ; separator, and ...
3
votes
7
answers
503
views
(AWK) Csv separating same variables in columns into different files
I have a test1.csv file with two columns
group,email
[email protected],[email protected]
[email protected],[email protected]
[email protected],[email protected]
[email protected],[email protected]
group2@email....
1
vote
1
answer
319
views
Filtering CSV data into multiple separate files
I have a CSV file named file1.csv:
something;AD;sss;Andorra;nothing;type_1;sss
something222;AD;sss222;Andorra;nothing222;type_2;aaa
thing;NL;thing3;Netherlands;thing;type_2;bb
etc;US;etc;United ...
0
votes
3
answers
2k
views
Find a value in a specific position when the only information you have is the position
I have a csv file approximately 16,000 rows long, with two fields. The first field contains a list of numeric values, and the second field contains a list of first and names delimited by semi-colons ...
2
votes
2
answers
3k
views
Finding a substring in a column of CSV file
I have a csv file with around 15000 lines and multiple columns. The data set looks like this:
A,B,C, message D, E, F
a,b,c,Hi how are you ? d,e,f
a,b,c,Hi Hello.Are you ok? ...
0
votes
1
answer
60
views
How do I pull a single value from every row in a csv?
I have a large amount of data formatted like this:
value1,value2,value3
value1,value2,value3
value1,value2,value3
etc..
I want to know how to pull only value2 from every row and output that result. ...
4
votes
3
answers
2k
views
Shell script to extract data from a list of files and saving it as a csv
I'm on CentOS. I have a list of files that I want to read, extract data from them and organize it as a csv file.
The log files text format is:
...
{"name":"test-api","hostname":"ci47","pid":3202,"...
2
votes
4
answers
780
views
Move files into separate directories based on grouping defined in a CSV file
RELATED: Move all files with matching prefixes to folder based on a csv list
I have a two-column CSV file (comma-separated values), with headers:
"id","group"
"F1256","old"
"E51651","new"
"X56369","...
0
votes
1
answer
5k
views
Fixing a .csv file where some rows have missing columns
I am currently working with data of many merged .csv files. Unfortunately, those merges are faulty sometimes.
This is best explained by this example:
"var1", "var2", "var3", "var4", "var5"
"...
2
votes
3
answers
985
views
Customized Sort and remove double quotes join by underscore of multiple columns from tab delimited file
Custom Sort based on subject column order should be Maths, English, Science
when I use this below command
awk -F',' '{if (NR!=1) {print $2,$3,$5,$4}}' myfile.csv
on my myfile.csv I am getting ...
3
votes
4
answers
725
views
Selecting lines in a file that do not contain the value in the other file
I have two files. One is a CSV of data with 60490 lines. Each line is a set of values such as a customer name, service dates, etc.
One of these values in the first file is a VIN value.
I have a ...
0
votes
2
answers
2k
views
Need to format output in csv format
This is abc.txt file
NAME="MARK" StartTime="14:11:26.710583" TotalElapsedTime="0" Pool="10" ThreadsReached="0"
NAME="MARK" StartTime="14:11:26.710583" TotalElapsedTime="0" Pool="10" ThreadsReached="0"...
2
votes
1
answer
90
views
Take info from .csv file and add it after certain pattern
I am working with this student's info:
name: Romeo
e_mail: [email protected]
Room: 0/48
street: 1/0/48
name: April
e_mail: [email protected]
Room: 0/4
street: 1/0/4
name: Julian
e_mail: ...