10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have this code with me but the condition is If any of the mandatory columns are null then entire file will be rejected.
infile ' ' #specifies the name of a datafile containing data that you want to load
BADFILE ' ' #specifies the name of... (1 Reply)
Discussion started by: raka123
2. Shell Programming and Scripting
Im having csv file with few columns which should contain data as shown below. Want to check if column 3 contain row with duplicate value(9876,9876) then corresponding to this in col2 should contain text "tax" and should not contain text "non".
Word "non" can come but if in column3... (2 Replies)
Discussion started by: as7951
3. Shell Programming and Scripting
I have the below csv file which is comma delimited , now from this file i need to read the value of the column der_id and then want to create a separate text file which will contain the value of the column der_id only please advise how to read the value of the column der_id and then... (3 Replies)
Discussion started by: punpun66
4. Shell Programming and Scripting
I have a file which I am reading line by line and processing it.
But the last line is not getting read in the file loop until I put an enter in the end.
echo "File to be... (2 Replies)
Discussion started by: Chinky23
5. Shell Programming and Scripting
I have a csv file that looks like below
I will get ProdId from... (5 Replies)
Discussion started by: anand.shah
6. Shell Programming and Scripting
I am tryng to read from a csv file and based on some grep command output I will modify one of the column in the same csv.
Intermediate Step:- If 2nd column of... (3 Replies)
Discussion started by: kmajumder
7. Shell Programming and Scripting
I am working on building a script that does the below actions together in my Linux server.
1) First, have to read the list of strings mentioned in CSV and store it in the shell script
2) Second, pick one by one from the string list, and search a particular folder for files that... (2 Replies)
Discussion started by: vikrams
8. Shell Programming and Scripting
Hi I am using KSH and trying to read variables from a csv file. I've set the IFS=, and it workds. Problem is where one of the values is text containing a comma. For example the following lines exist in my file. How can I read everything between the quotes into a single variable?
APW13812,,1... (2 Replies)
Discussion started by: ventris
9. UNIX for Advanced & Expert Users
I have csv file containing the data like this
"Engineering, Machinery & Equipment",Engineerin
Entertainment & Broadcasting,Entertain
The first and third record are fine,The issue with second records as it has comma enclosed with in inverted... (1 Reply)
Discussion started by: mohdtausifsh
10. Shell Programming and Scripting
Can anyone please help me to read the value from the .csv file?
This is my .csv file:
i want to get the two names and create directories correspondingly (1 Reply)
Discussion started by: novice_user