All Questions
5 questions
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 ...
0
votes
3
answers
2k
views
Replacing comma if found inside double quotations in a CSV file using sed
I have a CSV file which I need to load to a MySQL table. I rely of identifying the columns end by the , character. That's why it is important that the , does not appear elsewhere other than as a ...
0
votes
1
answer
79
views
Search list of names and their values from a file to another files?
I have two .csv files. First file has one column of list of names and second file has sixty columns including names and their values in all columns. I am looking to search names from first file to ...
2
votes
1
answer
1k
views
How do I replace tokens from one file with data from another?
I'm using Amazon Linux with bash shell. I have a file with comma delimited data, where each row looks like this
2049,576804C7DF554416A9EA25B2A5A81514,X,
Then I have a second file, with comma ...
5
votes
3
answers
29k
views
Search for values in 2 columns from CSV
I have a csv files with say 20 odd columns.
I need to get the 14th and 15th column values where value in 14th column is say "VALUE1" and value in 15th column is "VALUE2".
My condition gets satisfied ...