I am writing a shell script to parse a CSV file , in which i am facing a problem to separate the columns . Could some one help me with it.
Output:
Moderator's Comments:
Please use CODE tags of sample input, output, and code.
What you are trying to do is not clear. From what you have shown us, we could guess that what you want to do is:
Ignore everything except the 1st line in your input,
print a line containing $id= followed by the first field in your input line,
print a line containing $name= followed by the contents of the 2nd through the next to the last fields in your input line with the case shifted for the first character in each field and separate each of those fields by a single space character, and
print a line containing $email= followed by the contents of the last field from your input line.
Is this what you want?
If not please provide a complete description of what you are trying to do. And, if more than one line of input is to be processed, show us the complete output that you want (using CODE tags for input and output) for the sample input provided.
Please also get into the habit of always telling us what OS and shell you're using. Different systems have different utilities and many common utilities have additional/different options depending on what OS is being used. And, various shells have some common features, and some very different extensions that aren't available in other shells. Help us help you.
What have code have you tried to solve your problem?
hi everybody,
i have a file, in it I need to extract some data that follows a particular pattern..
For example: my file contains like
now running Speak225
sep 22 mon 16:34:05 2008
--------------------------------
... (4 Replies)
Hi All,
I have a requirement where I have to search the file with some text say "Exception". This exception word can be repeated for more then 10 times.
Suppose the "Exception" word is repeated at line numbers say x=10, 50, 60, 120. Now I want to extract all the lines starting from x-5 to... (3 Replies)
Hi Freinds,
I have a file1.txt in the following format
File1.txt
I want to get 2 files from the above file filextra.txt should have the lines which are ending with "<" and remaining lines in the filecompare.txt file.
Please help. (3 Replies)
FILE_ID extraction from file name and save it in CSV file after looping through each folders
My files are located in UNIX Server, i want to extract file_id and file_name from each file .and save it in a CSV file. How do I do that?
I have folders in unix environment, directory structure is... (15 Replies)
Hey all,
i´ve got the following problem:
i´m aquiring data with an instrument and i get data in a .txt file.
This is how the txt file looks like:
Report of AU program poptau
F1P=-49.986ppm F2P=-110.014ppm
Target directory for serfile: D:/data/Spect500/nmr/Thoma/882
Linear... (17 Replies)
Hallo Friends,
I need you help. My file has 5000 or so lines and currently looks like below(sample).
Service Type,Origin,Destination,Rate Per Minute,Minimum Charge,Time Based Rate,Time Based From Day,Time Based To Day,Time Based From Time,Time Based To Time,Destination Prefix List,,
VoIS... (3 Replies)
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.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Hello,
I'm attempting to extract 13 digit numbers beginning with 978 from a data file with the following command:
awk '{ for(i=1;i<=NF;i++) if($i ~ /^978/) print $i; }' datafile > outfile
This typically works. However, the new data file is an .xml file, and this command is no longer working... (6 Replies)
Hi All,
I have a data file and need to extract and convert it into csv format:
1) Read and extract the line containing string ending with "----" (file sample_linebyline.txt file) and to make a .csv file from this.
2) To read the flat file flatfile_sample.txt which consists of similar data (... (9 Replies)