Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: CSV file in unix
Top Forums Shell Programming and Scripting CSV file in unix Post 302581318 by jim mcnamara on Monday 12th of December 2011 10:08:28 PM
Old 12-12-2011
Note: this sounds like homework to me - for an intro class. We have a forum for that.
No teacher will believe you wrote the code below.

Code:
#!/bin/bash
declare -a prompt=('Enter full name:' 'email:', 'birth date:', 'gender:')
rec=""
while true 
do
  for i in 0 1 2 3
  do
     echo "${prompt[i]} \c"; read rec[i]
  done
  echo "${rec[0]},${rec[0]},${rec[0]},${rec[0]}" >> myfile.csv
  echo "Enter more Y/N \c"; read ok
  [ $ok = 'Y' ]  && continue
  break
done
sort -t',' -k 4 -o myfile.csv myfile.csv

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

FORMAT OF CSV FILE under unix environment.

hi I unload the table results from oracle to csv file foramt. i need increse the width of each column using unix commands could you pl tell me how to increase the width of each column to spefic width uisng sed unix command or na other unix commands i have file name called report.csv inside... (38 Replies)
Discussion started by: raosurya
38 Replies

2. UNIX for Advanced & Expert Users

Problem in converting password protected excel file to csv file in unix

I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner. I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
2 Replies

3. UNIX and Linux Applications

UNIX sorting - csv file

Hi, Please help me to solve sorting in CSV file. I have 25 columns in my CSV. (Delimiter is ",") Summary columns are from 10 to 13 which are should not be sorted. From 1-9 and 14-25 should be able to sort in ascending. how should i do this using Sort command in unix. If no simple commands pls... (0 Replies)
Discussion started by: rajani_p
0 Replies

4. Shell Programming and Scripting

How to convert a excel file to a .csv file from unix script

Hi I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this? Thanks Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies

5. Shell Programming and Scripting

How can I create a CSV file from PL/Sql in UNIX?

Can someone help me on creating a script that will manage/create a csv file from Pl/Sql using UNIX?Any advice is welcome,thank you so much,:) (2 Replies)
Discussion started by: Atrap
2 Replies

6. UNIX for Advanced & Expert Users

Replacing the comma in .csv file in unix

Hi All, Could some one help me on one of my requirement below: I have a sequential file with 4fields in it and it is a comma (,) seperated file. Delimeter is 'comma'. But in of the file column for ex: 3rd column it is 'Description' (column name) I am getting the values with commas.... (6 Replies)
Discussion started by: eskay_s
6 Replies

7. UNIX Desktop Questions & Answers

Format csv file using Unix

Hi All, I have an csv file with three rows, where first containing header deatils. is there any way to make the first row to appear bold using UNIX command. Input File: Name Rank arun 1 babu 2 Expected Output: Name Rank arun 1 babu 2 (7 Replies)
Discussion started by: arunmanas
7 Replies

8. UNIX for Advanced & Expert Users

Need help on moving .csv file from UNIX to windows file path

Need help on moving .csv file from unix to windows file path. (1 Reply)
Discussion started by: lakshmanraok117
1 Replies

9. UNIX for Advanced & Expert Users

Convert CSV file to nested XML file using UNIX/PERL?

we have a CSV which i need to convert to XML using Perl or Unix shell scripting. I was able to build this XML in oracle database. However, SQL/XML query is running for long time. Hence, I'm considering to write a Perl or shell script to generate this XML file. Basically need to build this XML... (3 Replies)
Discussion started by: laknar
3 Replies

10. Shell Programming and Scripting

Read csv file, convert the data and make one text file in UNIX shell scripting

I have input data looks like this which is a part of a csv file 7,1265,76548,"0102:04" 8,1266,76545,"0112:04" I need to make the output data should look like this and the output data will be part of text file: 7|1265000 |7654899 |A| 8|12660000 |76545999 |B| The logic behind the... (6 Replies)
Discussion started by: RJG
6 Replies

LEARN ABOUT REDHAT

play

play(1) 						      General Commands Manual							   play(1)

NAME

       play - play any sound file to audio device

       rec  - record audio to any sound file format

SYNOPSIS

       play [fopts] infile [effect]

       rec [fopts] outfile [effect]

DESCRIPTION

       This manual page briefly documents the play and rec commands.

       play  and  rec are programs that allow you to play and record different types of sound files from the command line.  They are front ends to
       the more general sox(1) package.  Normally, the play command will automatically detect the type and other parameters of the  soundfile.	If
       it can't do so, the parameters can be changed through options.

OPTIONS

       A summary of common options are included below.	For a complete description of options and their values, see the sox(1) man page.

       -c [channels], --channels=[channels]
	      Define the number of channels in the file.

       -d [device], --device=[device]
	      Specify a different device to play the sound file to.

       -f [format], --format=[format]
	      Specify bit format of the sample. One of s, u, U, A, a, or g.

       -r [rate], --rate=[rate]
	      Specify the sample rate of the audio data (samples per second).

       -s [size], --size=[size]
	      Specify the width of each sample.  One of b, w, l, f, d, or D.

       -t [type], --type=[type]
	      Specify audio file format to use.  Useful if it can not be automatically determined.

       -v [volume], --volume=[volume]
	      Change the audio volume

       -x , --xinu
	      Reverse the byte order of the sample (only works with 16 and 32-bit data).

       -h, --help
	      Show summary of options.

       --version
	      Show version of play/rec.

       Description of effects are described in the
	      sox(1) man page.

SEE ALSO

	sox(1)
	soxexam(1)

AUTHOR

       This manual page was written by Guenter Geiger <geiger@iem.mhsg.ac.at>, for the Debian GNU/Linux system.

       Updates by Anonymous.

								 December 11, 2001							   play(1)
All times are GMT -4. The time now is 03:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy