|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk to parse comma separated field and removing comma in between number and double quotes
Post 303015826 by RudiC on Friday 13th of April 2018 04:27:18 AM
04-13-2018
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear All,
I have a comma-separated file.
1. The first line of the file(header) should have 4 commas(5 fields).
2. The last line of the file should have 1 comma(2 fields).
Pls help me in checking this condition in a shell script.
And the number of lines between the first line and last... (11 Replies)
Discussion started by: KrishnaSaran
11 Replies
2. Shell Programming and Scripting
I have a csv file with lines like the followings
123456,"ABC CO., LTD","XXX"
789012,"DEF LIMITED", "XXX"
before I bcp this file to database, the comma in "CO.," need to be removed first.
My script is cat <filename> | sed 's/"CO.,"/"CO."/g'
but it doesn't work. Can anyone here able to... (2 Replies)
Discussion started by: joanneho
2 Replies
3. Shell Programming and Scripting
I have a situation where I am reading a text file line-by-line. Those lines of data contain comma separated fields of data. However, each line can vary in the number of fields it can contain. What I need to do is parse apart each line and write each field of data found (left to right) into a file.... (7 Replies)
Discussion started by: 2reperry
7 Replies
4. Shell Programming and Scripting
Hi Friends,
I'm working on a perl script, which seems to be simpler. But I'm very new to PERL scripting.
I have a comma separated data file, from which I need to extract only the seventh field data out of available twenty fields to an array using perl.
Any help would be much appreciated.
... (17 Replies)
Discussion started by: ganapati
17 Replies
5. Shell Programming and Scripting
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.... (5 Replies)
Discussion started by: shtobias
5 Replies
6. Shell Programming and Scripting
I have a list of files with the same name, but they have a different date stamp in the name. I can find the first file, but I need to find the second file. I am using this information to create a variable I use later. Here is a example of how I find the first file.
"ls -mr... (11 Replies)
Discussion started by: NoMadBanker
11 Replies
7. Shell Programming and Scripting
Hi, all
I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes.
sample input:
for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies
8. Shell Programming and Scripting
I need to arrange output of SQL query into a comma separated format and I'm struggling with processing the output...
The output is something like this:
<Attribute1 name><x amount of white spaces><Atribute value>
<Attribute2 name><x amount of white spaces><Atribute value>
<Attribute3... (2 Replies)
Discussion started by: Juha
2 Replies
9. Shell Programming and Scripting
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,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies
10. Shell Programming and Scripting
I am trying to re-format a .csv file using awk. I have 6 fields in the .csv file. Some of the fields are enclosed in double quotes and contain comma's inside the quotes. awk is breaking this into multiple fields.
Sample lines from the .csv file:
Device Name,Personnel,Date,Solution... (1 Reply)
Discussion started by: jxrst
1 Replies
LEARN ABOUT OSF1
group
group(4) Kernel Interfaces Manual group(4) NAME
group - Group file DESCRIPTION
The /etc/group database contains the following information for each group: Group name Encrypted password Numerical group ID A comma-sepa- rated list of all users allowed in the group Note: Do not put any spaces between a comma and a username; otherwise, the username following the comma will not be made a part of the desired group. The /etc/group file is an ASCII file, with the fields separated by colons. Each group is separated from the next by a new line. If the password field is null, no password is demanded. Because of the encrypted passwords, it can and does have general read permission and can be used, for example, to map numerical group IDs to names. Note that commands or scripts used for adding users to groups are subject to the 225 character limit on line lengths. However, you can split lines as appropriate. RESTRICTIONS
Increasing the number of groups that a user is in beyond 16 can affect services that use ONC RPC. Tru64 UNIX ONC RPC supports up to 32 groups for compatibility with ULTRIX Version 4.2 and higher. Other vendors may support only 16 groups. ULTRIX versions before 4.2 support up to 8 groups. Users who increase their group membership beyond 8 or 16 groups will not be able to NFS mount file systems from servers that only support 8 or 16 groups over NFS. In addition, if root group membership is increased beyond 8 or 16, the NIS service will not work in a mixed NIS server environment where the servers support only 8 or 16 groups. The addgroup command limits the length of a group name to eight characters or less. FILES
/etc/group RELATED INFORMATION
Commands: addgroup(8), groupadd(8), adduser(8), groups(1), passwd(1) Functions: setgroups(2) Routines: initgroups(3) Files: passwd(4) delim off group(4)