Convert comma separated file to fix length Post: 302814331

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected...

2. Shell Programming and Scripting

How to format file into comma separated field

Guys, Need you help, i have a a file content that look like this. Nokia 3330 <spaces><spaces><more spaces>+76451883874 Nokia 3610 +87467361615 so on and so forth, - there are so many spaces in between. - e.g....

3. Shell Programming and Scripting

parsing comma separated file

Hi, I have a file with th elist of patches separated by comma, like below: patch1, patch 2, patch 3................ t\The number of patches is not known as it changes every time. I need assistance in writing a routine such as it will take patch1 as first variable and performs the...

4. Shell Programming and Scripting

Comma separated file

Hi all, I have the following files types: FileA: 100, 23, 33, FileB: 22, 45, 78, and i want to make File C: 100,22 23,45 33,78 any nice suggestions for making it easy.

5. Shell Programming and Scripting

Need Help - comma inside double quote in comma separated csv,

Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below,...

6. Shell Programming and Scripting

How to split the comma separated file?

Hi, I have a filein unix like ABC,CDE BCD,KHL and the output i need is like column1 column2 ABC,CDE ABC ABC,CDE CDE BCD,KHL BCD BCD,KHL KHL. Can some body help me out? Hi, The code is working fine. But in my file each row does not have always 1 comma. It may...

7. UNIX for Dummies Questions & Answers

[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...

8. Shell Programming and Scripting

Convert column to quote and comma separated row

Hi, I have a list of tables in a file.txt C_CLAIM C_HLD C_PROVIDER I want the output to be 'C_CLAIM','C_HLD','C_PROVIDER' Currently I'm usin awk and getting output which is almost correct but still has minor defects awk -vORS="','" '{ print $1 }' file.txt The output of...

9. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ...

10. 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...

LEARN ABOUT CENTOS

lgroupmod

lgroupmod(1)						      General Commands Manual						      lgroupmod(1)

NAME

       lgroupmod - Modify an user group

SYNOPSIS

       lgroupmod [OPTION]... group

DESCRIPTION

       Modifies the user group with name group.

OPTIONS

       -A, --admin-add=list
	      Add users in comma-separated list among group's administrators.

       -a, --admin-remove=list
	      Remove  users  in comma-separated list from group's administrators.  Removing users that are not currently among group's administra-
	      tors silently succeeds.

       -g, --gid=gid
	      Change group's group ID to gid.

       -i, --interactive
	      Ask all questions when connecting to the user database, even if default answers are set up in libuser configuration.

       -L, --lock
	      Lock group.  This prevents users from using the group password with newgrp(1) to become a member of group.

       -M, --member-add=list
	      Add users in comma-separated list among group's members.

       -m, --member-remove=list
	      Remove users in comma-separated list from group's members.  Removing users that are not currently  among	group's  members  silently
	      succeeds.

       -n, --name=name
	      Rename group to name.

       -P, --plainpassword=password
	      Set group's password to password.  Note that the password can be viewed while running lgroupmod using tools such as ps(1).

       -p, --password=encrypted
	      Set  group's  password  to the password represented by the hash encrypted.  Note that the hash can be viewed while running lgroupmod
	      using tools such as ps(1).

       -U, --unlock
	      Unlock group.

EXIT STATUS

       The exit status is 0 on success, nonzero on error.

libuser 							    Jan 11 2005 						      lgroupmod(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Discussion started by: Everton_Silveir

2. Shell Programming and Scripting

How to format file into comma separated field

Discussion started by: shtobias

3. Shell Programming and Scripting

parsing comma separated file

Discussion started by: avikaljain

4. Shell Programming and Scripting

Comma separated file

Discussion started by: hen1610