Sponsored Content
Top Forums Shell Programming and Scripting Print each paragraph in a text file into excel file Post 302777941 by prash358 on Friday 8th of March 2013 07:26:21 PM
Old 03-08-2013
Not sure i am getting below syntax errors.

Quote:
awk '
NR==1||/^ *$/{rec++}
{
sep=a[rec,$1]?"\n":"";
a[rec,$1]=a[rec,$1] sep $2
}
END{printf("dn\tuser_ok\tuser_bad\n");
for(i=1;i<=rec;i++)
printf("\"%s\"\t\"%s\"\t\"%s\"\n", a[i,"dn"], a[i,"user_ok"], a[i,"user_bad"])
}' FS=": *"


Quote:
test@unix1 >./test.sh input.txt > out.csv
awk: syntax error near line 4
awk: illegal statement near line 4
awk: syntax error near line 5
awk: illegal statement near line 5
awk: syntax error near line 9
awk: illegal statement near line 9
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

text file to excel or csv

Hi, I have a text file like ---------------------- aaa|bbb|ccc|ddd|eee fff|gggg|hhhhhh|kkkk -------------------- I have a script which will transfer(thourgh FTP) this text file to windows system. But I want to covert it into excel or CSF then upload into windows system.. thanks (9 Replies)
Discussion started by: srikanthus2002
9 Replies

2. UNIX for Dummies Questions & Answers

Script to generate text file from excel file

Hello, I have a excel file which has almost ten columns on the shared drive. I have to write a shell script to ftp that daily to unix server and then extract some columns from there and generate oracle standard text file. The columns should be in proper order and aligned properly, otherwise... (1 Reply)
Discussion started by: isingh786
1 Replies

3. UNIX for Dummies Questions & Answers

Output text from 1st paragraph in file w/ a specific string through last paragraph of file w/ string

Hi, I'm trying to output all text from the first paragraph in a file that contains a specific string through the last paragraph in that file that contains that string. Previously, I was outputting just each paragraph with that search string with: cat in_file | nawk '{RS=""; FS="\n";... (2 Replies)
Discussion started by: carpenn
2 Replies

4. Shell Programming and Scripting

Easy way to pull a paragraph from a text file?

I have a collection of text files that comprise a mailing list archive. I grep them to find an email that interests me, then open the file in a text editor to find the surrounding paragraph of text. Is there an easy way to do this from the shell instead? (2 Replies)
Discussion started by: CRGreathouse
2 Replies

5. Shell Programming and Scripting

How to print excel file / csv file in solaris server ?

Hi, I have to print a excel file in solaris server. I am using lexmark printer with post script printer driver . But the problem is when i am using " lp -d <printer name> <somefile name.xls>" command it is not printing correctly. but for pdf file using the same command it printing correctly. ... (2 Replies)
Discussion started by: Sambuddha
2 Replies

6. Shell Programming and Scripting

How to convert excel file to csv file or text file?

Hi all, I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion. so for instance input.xls description of... (6 Replies)
Discussion started by: johnkim0806
6 Replies

7. Shell Programming and Scripting

Need to convert delimited text file in UNIX to an Excel file

Dear Users , Need to convert delimited text files in UNix server to an Excel file and move the excel file to Windows environment. Am trying to automate the whole process. Can anyone share the ideas,if they have done similar ones before...Thanks -Meera (1 Reply)
Discussion started by: meerakrish
1 Replies

8. Shell Programming and Scripting

Need help to write a shell script to convert text file to excel file.

Hi Everyone, I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet. Example input: IpAdress:InstanceName:Port:ServerName 10.255.255.1:abc:2232:xyz_abc Output should be an excel sheet like below: Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies

9. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies

10. Shell Programming and Scripting

Match text to lines in a file, iterate backwards until text or text substring matches, print to file

hi all, trying this using shell/bash with sed/awk/grep I have two files, one containing one column, the other containing multiple columns (comma delimited). file1.txt abc12345 def12345 ghi54321 ... file2.txt abc1,text1,texta abc,text2,textb def123,text3,textc gh,text4,textd... (6 Replies)
Discussion started by: shogun1970
6 Replies
ossmix(1)							 OSS User Commands							 ossmix(1)

NAME
ossmix - Open Sound System command-line mixer program. SYNOPSIS
ossmix [-d <dev#>] [-achqD] [control name] [value] DESCRIPTION
ossmix is a simple command-line mixer utility that is used to display the mixer settings of physical and virtual audio devices. OSS version 4 has an extended mixer API which supports some device specific features that may not available using other mixer applications. OPTIONS
-D Display device information. -a Dump mixer settings for all mixers (normal format). -c Dump mixer settings for all mixers (command format). -h Display usage information. -q Quiet mode. -v[1|2] Verbose mode. -v2 prints more detailed infoamation than -v1. ctrl# value Change value of a mixer control. <no arg> Display current/possible settings. USAGE
ossmix without any arguments displays the current settings of the default mixer device (usually the motherboard sound chip). This printout can also be used to find out the supported control names and their possible values. Currently all controls accept an ON/OFF value, a mono value (0 to 100) or a stereo value (left:right where both channel volumes can be between 0 and 100). The value can also be expressed in a relative form (e.g. +1 to add 1 to the previous volume). An ON/OFF control can also receive a TOGGLE value. If a control has a name in quotes following the normal output, than the name can be used instead of the control when setting a value. The following is a sample printout produced by ossmix: Selected mixer 0/Creative AudioPCI Known controls are: vol <both/leftvol>[:<rightvol>] (currently 50:50) pcm <both/leftvol>[:<rightvol>] (currently 50:50) speaker <monovol> (currently 21) line <both/leftvol>[:<rightvol>] (currently 32:32) line.rec ON|OFF (currently OFF) mic <monovol> (currently 16) mic.rec ON|OFF (currently ON) cd <both/leftvol>[:<rightvol>] (currently 100:100) cd.rec ON|OFF (currently OFF) pcm2 <both/leftvol>[:<rightvol>] (currently 75:75) line1 <both/leftvol>[:<rightvol>] (currently 32:32) line1.rec ON|OFF (currently OFF) line2 <monovol> (currently 32) line2.rec ON|OFF (currently OFF) line3 <monovol> (currently 0) line3.rec ON|OFF (currently OFF) mic.micboost ON|OFF (currently ON) mic.micbias ON|OFF (currently ON) mute.pcmmute ON|OFF (currently OFF) mute.pcm2mute ON|OFF (currently OFF) mute.micmute ON|OFF (currently OFF) mute.cdmute ON|OFF (currently OFF) mute.linemute ON|OFF (currently OFF) mute.line1mute ON|OFF (currently OFF) mute.line2mute ON|OFF (currently OFF) mute.line3mute ON|OFF (currently OFF) SELECTING MIXER DEVICE
It's possible to select the mixer device by using the -d<mixernumber> command line argument. This argument (when used) should be the first one on the command line. By default the mixer number 0 will be accessed. To find the available mixer devices, type ossinfo -x and look under the Mixers heading for available mixer devices. CHANGING MIXER SETTINGS
Changing the values is done just like with the original "mixer" applet. For example: ossmix pcm 50:60 The above sets the pcm control (audio playback volume) so that the left channel volume is 50 and the right channel volume is 60. With just "ossmix pcm 50" the both channel volumes will be set to 50. In addition to the old mixer there are now some (usually ON/OFF) settings. These settings are device specific and don't work with all soundcards. The easiest way to find them out is to start ossmix without command line arguments (other than -d#). Some control names contain a dot ("."). This dot is required when changing the value. For example: "ossmix -d0 mic.micboost ON". EXAMPLES
ossmix vol 50 Set the vol control volume to 50. If the pcm control is a stereo control, than both channels will be set to 50. ossmix vol 50:60 Set the vol control so that the left channel volume is 50 and the right channel volume is 60. ossmix vol +2 Raise vol volume by 2. ossmix -- vol +2:-2 Raise the left channel volume by 2, and lower right channel volume by 2. The "--" is needed on some systems so that the "-2" won't be mistaken for a parameter. ossmix micboost ON Set micboost to ON. ossmix micboost TOGGLE Toggle micboost. ossmix mplayer +2 Raise mplayer volume by 2. This would only work if mplayer is using the virtual mixer. FILES
/usr/bin/ossmix SEE ALSO
ossdevlinks(1), ossxmix(1), savemixer(1) AUTHOR
4Front Technologies 16 December 2012 ossmix(1)
All times are GMT -4. The time now is 05:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy