Sponsored Content
Top Forums Shell Programming and Scripting Removing blank lines from comma seperated and space seperated file. Post 302312559 by devtakh on Friday 1st of May 2009 11:51:18 PM
Old 05-02-2009
Quote:
Originally Posted by zenith
FileA

ABC,ABC,ABC
,,,
ABC,ABC,ABC
ABC,ABC,ABC
ABC,ABC,ABC
,,,
ABC,ABC,ABC
,,,
FileB
ABC ABC ABC

ABC ABC ABC
ABC ABC ABC

ABC ABC ABC
ABC ABC ABC

Thanks
Code:
sed -e '/^$/d' -e '/^,*,/d' fileA fileB


cheers,
Devaraj Takhellambam
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to load comma seperated values file (*.csv) into Oracle table

Hi all I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so... The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Discussion started by: handynas
5 Replies

2. UNIX for Advanced & Expert Users

How to load comma seperated values file (*.csv) into Oracle table

Hi all I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so... The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Discussion started by: handynas
4 Replies

3. UNIX for Dummies Questions & Answers

Search and then concat 4m other file (comma seperated)

My query is now a bit simplified. file1.txt names; ID; value1 ; values N; ABC; 1 ; a18 ; ... CDF; 2 ; b16 ; .. ABC; 1 ; c13 ; ...... EFG; 3 ;d12 ; ... file2.txt ID(Unique);smVals; smVal1; smVal N; 1; ...; ...; ...; 2; ..; ..; ..; 3; ..; ..; ..; ... (1 Reply)
Discussion started by: szchmaltz
1 Replies

4. Shell Programming and Scripting

Trimming fields for comma or pipe seperated file

I have file like this FileA: abc , "helloworld" , america def,asia, japan ghi, africa, ipl Output Needed: abc,"helloworld",america def,asia,japan ghi,africa,ipl I would like to implement using awk. I want to trim each field for its leading and trailing spaces. (7 Replies)
Discussion started by: pinnacle
7 Replies

5. Shell Programming and Scripting

Script to append a value seperated by comma

I have a file like below. How can I add a new value after moss separated by a comma. This adding script should work in such a way that each time i pass a value it should be added one after the other separated by commas. hru:122: hello:123:john,philip,mary,kp,moss hi:124: bye:125: Can... (7 Replies)
Discussion started by: Tuxidow
7 Replies

6. Shell Programming and Scripting

Passing Comma seperated arguments

Hi How to takes coma seperated arguments and and parsing each argument to varaiable that has used further in the script. (1 Reply)
Discussion started by: Reddy482
1 Replies

7. Shell Programming and Scripting

Convert comma seperated file to line seperated.

Hi, I have data like this. 1,2,3,4 Output required: 1 2 3 4 I am trying to use tr function but getting error. Help is appreciated. (6 Replies)
Discussion started by: pinnacle
6 Replies

8. UNIX for Dummies Questions & Answers

Need help removing leading spaces from one field in comma seperated file

Using awk or sed, I'd like to remove leading spaces after a comma and before a right justified number in field 6. Sounds simple but I can't find a solution. Each field's formatting must stay intact. Input: 40,123456-02,160,05/24/2012,02/13/1977, 10699.15,0 Output:... (5 Replies)
Discussion started by: Scottie1954
5 Replies

9. Shell Programming and Scripting

Need Help in rearranging the content of a file comma seperated

I have a file with the below content a = test1 b = test2 a = test3 b= test4 c = test6 b = test5 d = test7 d = test9 Need the output to be as follows a = test1,test3 b = test2, test5 c = test6 d = test7, test9 (4 Replies)
Discussion started by: iron_michael86
4 Replies

10. Shell Programming and Scripting

Seperated a Column from 'ESC' Character seperated file

Hi Experts I have an escape seperated fields in the unix file. And in the below format file I need to extract the first column. Please help its urgent. cat -v op.dat | head 24397028^ I want to extract the file in below format ( with only first column ) 24397028 2439707 thanks. ... (6 Replies)
Discussion started by: neha_suri06
6 Replies
SXID.CONF(5)							File Formats Manual						      SXID.CONF(5)

NAME
sxid.conf - configuration settings for sxid DESCRIPTION
This is the configuration file used by sxid to define it's parameters for execution. By default it is /etc/sxid.conf but can be anything using the --config command line option for sxid. Options in this file are in the form of OPTION = "VALUE" . Note that the VALUE must be contained in double quotes. OPTIONS
ALWAYS_NOTIFY If sxid does not find any changes it will not send an email unless you specify "yes" here. ALWAYS_ROTATE Usually sxid will only rotate the log files when there is a change from the last run. This is usually best, since all logs will record a change rather than just a run of the program. If you want to rotate the logs every time sxid is run, regardless of changes, specify "yes" here. EMAIL Where to send the email containing the output of changes every time sxid is run. Example: EMAIL = "Great Admin <root@host.com>" ENFORCE Normally sxid only flags items which are suid or sgid and are in a FORBIDDEN directory. With this option set to "yes" sxid will remove the s[ug]id bit(s) on any files or directories it finds in forbidden directories and report any changes in the email. Note that directories listed in FORBIDDEN are searched regardless of whether or not they are listed in SEARCH. However, EXCLUDED options still apply to directories that fall under them. EXCLUDE A space seperated list of directories to exclude from the search. Note that if a SEARCH path falls under an EXCLUDE path that it will still be searched. This is useful for excluding whole directories and only specifying one. Example: SEARCH = "/usr /usr/src/linux" EXCLUDE = "/usr/src" EXTRA_LIST File that contains a list of (each on it's own line) of other files that sxid should monitor. This is useful for files that aren't +s, but relate to system integrity (tcpd, inetd, apache...). Example: EXTRA_LIST = "/etc/sxid.list" FORBIDDEN A space seperated list of directories that are not supposed to contain any suid or sgid items. Items which are suid or sgid in these directories are flagged in the email seperately from the other listings whether there are other changes or not. Example: FORBIDDEN = "/tmp /home" IGNORE_DIRS Ignore entries for directories in these paths. This means that only files will be recorded. You can effectively ignore all directory entries by setting this to "/". KEEP_LOGS This is a numerical value for how many log files to keep when rotating. LISTALL Forces a list of all entries to be included in th output. Implies ALWAYS_NOTIFY. LOG_FILE The full path of where to store the log files. These will be rotated, each rotated log being suffixed with a digit. The directories must already exist. This is usually /var/log/sxid.log. Rotated logs would look like /var/log/sxid.log.n where 'n' is the number in the rotation. The current log has no suffix. AIL_PROG Mail program. This changes the default compiled in mailer for reports. You only need this if you have changed it's location and don't want to recompile sxid. SEARCH A space seperated list of directories to search. Sxid will use these as a starting point for it's searches. Example: SEARCH = "/usr /bin /lib" AUTHOR
Ben Collins <bcollins@debian.org> REPORTING BUGS
Report bugs to current maintainer Timur Birsh <taem@linukz.org>. SEE ALSO
sxid(1) sXid 4.0.5 January 2002 SXID.CONF(5)
All times are GMT -4. The time now is 07:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy