Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers [solved] Comma separated values to space separated
# 1  
Old 04-16-2013
[solved] Comma separated values to space separated
Hi,

I have a large number of files which are written as csv (comma-separated values).

Does anyone know of simple sed/awk command do achieve this?

Thanks!

---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ----------

Guess I asked this too soon. Found the solution

Code:
awk -F "\"*,\"*" '{print $1, $2}'  file.csv

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert fixed value fields to comma separated values

Hi All, Hope you are doing Great!!!. Today i have came up with a problem to say exactly it was for performance improvement. I have written code in perl as a solution for this to cut in specific range, but it is taking time to run for files thousands of lines so i am expecting a sed... (9 Replies)
Discussion started by: mad man
9 Replies

2. Shell Programming and Scripting

Parsing Comma Separated values to UNIX variable from PLSQL

Hi All, I'm trying to pass the comma separated values (string) returned from Plsql Procedure to UNIX variable. getting the below log message cat: -: Bad file descriptor awk: cmd. line:1: fatal: error reading input file `-': Bad file descriptor The output coming from plsql procedure is... (3 Replies)
Discussion started by: Mahesh3089
3 Replies

3. Shell Programming and Scripting

Assign comma separated values to a variable

Hi All, I wrote a database command that queries our application and outputs a whole bunch of values to a text file. I need to assign the output to two values. Here is a sample of the output: valueOne, checkOne valueTwo, checkTwo valueThree, checkThree I would like... (9 Replies)
Discussion started by: jeffs42885
9 Replies

4. Shell Programming and Scripting

Comma separated values to individual lines

My OS : RHEL 6.7 I have a text file with comma separated values like below $ cat testString.txt 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', . . . . I want these values to appear like below 'JOHN' , 'KEITH' , 'NEWMAN' , 'URSULA' , 'ARIANNA' , 'CHENG', .... (4 Replies)
Discussion started by: kraljic
4 Replies

5. Shell Programming and Scripting

Needs help in parsing comma separated values

hello experts, i am retrieving values in variables jobKey and jobName within my shell script. these values are returned to me within braces and i am using following command to remove those braces: jobKeys=`echo $jobKeys | sed 's:^.\(.*\).$:\1:'` jobNames=`echo $jobNames | sed... (1 Reply)
Discussion started by: avikaljain
1 Replies

6. Shell Programming and Scripting

To agregate Comma separated values

Hi pls help me to get the code: i have a file in which content is : 2.01304E+11 2.01304E+11 ori 2 01:00 2.01304E+11 2.01304E+11 ori 2 01:02 2.01304E+11 2.01304E+11 ori 3 01:02 2.01304E+11 2.01304E+11 ori 3 ... (7 Replies)
Discussion started by: Aditya.Gurgaon
7 Replies

7. Shell Programming and Scripting

Input Validation of comma separated values

Hello all, I am working on a script and have the first part solved of numerical input validation. Below the code validates that the input is a numerical value between 100 and 1000. If not, it errors out. Now I need to be able to read values separated by a comma. For example, instead of my... (5 Replies)
Discussion started by: LinuxRacr
5 Replies

8. Shell Programming and Scripting

script to store comma separated values in different variables

Hello friends, I need ur help.I want to write a script. The script should read contents from a file namely xyz. e.g xyz abcd,1234,efgh,7854378 dhnsa,dsakjkdl,43432,ZXDsa the script should store comma (,) seperated values in different variables. Once pointer will reach end of line (\n), it should... (1 Reply)
Discussion started by: akhtar.bhat
1 Replies

9. Shell Programming and Scripting

Extracting the values separated by comma

Hi, I have a variable which has a list of string separated by comma. for ex , Variable=/usr/bin,/usr/smrshbin,/tmp How can i get the values between the commas separately using shell scripts.Please help me. Thanks, Padmini. (6 Replies)
Discussion started by: padmisri
6 Replies

10. Shell Programming and Scripting

Splitting comma separated values into an array

I'm attempting to create a KSH array out of a string like this: ",,,value1,value2,," I have created the array but I only get two elements, one for value1 and one for value2. I have ended up with something like this but I don't like it: set -A JUNK xx=0 for i in $(print ",,,value1,value2,,"... (3 Replies)
Discussion started by: tmarikle
3 Replies
Login or Register to Ask a Question

LEARN ABOUT CENTOS

sssd-simple

SSSD-SIMPLE(5)						   File Formats and Conventions 					    SSSD-SIMPLE(5)

NAME

       sssd-simple - the configuration file for SSSD's 'simple' access-control provider

DESCRIPTION

       This manual page describes the configuration of the simple access-control provider for sssd(8). For a detailed syntax reference, refer to
       the "FILE FORMAT" section of the sssd.conf(5) manual page.

       The simple access provider grants or denies access based on an access or deny list of user or group names. The following rules apply:

       o   If all lists are empty, access is granted

       o   If any list is provided, the order of evaluation is allow,deny. This means that any matching deny rule will supersede any matched allow
	   rule.

       o   If either or both "allow" lists are provided, all users are denied unless they appear in the list.

       o   If only "deny" lists are provided, all users are granted access unless they appear in the list.

CONFIGURATION OPTIONS

       Refer to the section "DOMAIN SECTIONS" of the sssd.conf(5) manual page for details on the configuration of an SSSD domain.

       simple_allow_users (string)
	   Comma separated list of users who are allowed to log in.

       simple_deny_users (string)
	   Comma separated list of users who are explicitly denied access.

       simple_allow_groups (string)
	   Comma separated list of groups that are allowed to log in. This applies only to groups within this SSSD domain. Local groups are not
	   evaluated.

       simple_deny_groups (string)
	   Comma separated list of groups that are explicitly denied access. This applies only to groups within this SSSD domain. Local groups are
	   not evaluated.

       Specifying no values for any of the lists is equivalent to skipping it entirely. Beware of this while generating parameters for the simple
       provider using automated scripts.

       Please note that it is an configuration error if both, simple_allow_users and simple_deny_users, are defined.

EXAMPLE

       The following example assumes that SSSD is correctly configured and example.com is one of the domains in the [sssd] section. This examples
       shows only the simple access provider-specific options.

	       [domain/example.com]
	       access_provider = simple
	       simple_allow_users = user1, user2

SEE ALSO

       sssd(8), sssd.conf(5), sssd-ldap(5), sssd-krb5(5), sssd-simple(5), sssd-ipa(5), sssd-ad(5), sssd-sudo(5),sss_cache(8), sss_debuglevel(8),
       sss_groupadd(8), sss_groupdel(8), sss_groupshow(8), sss_groupmod(8), sss_useradd(8), sss_userdel(8), sss_usermod(8), sss_obfuscate(8),
       sss_seed(8), sssd_krb5_locator_plugin(8), sss_ssh_authorizedkeys(8), sss_ssh_knownhostsproxy(8),pam_sss(8).

AUTHORS

       The SSSD upstream - http://fedorahosted.org/sssd

SSSD
								    06/17/2014							    SSSD-SIMPLE(5)