11-27-2014
Yeah you combine but only ONE pair of SINGLE-QUOTE marks (')....
sed 's/|/","/g; s/^/"/; s/$/"/; s/"="/="/g; s/""~/"/g' A4.txt > A5.csv
Also, to prevent double quotes at the beginning and end of lines, you can add:
sed 's/|/","/g; s/^"*/"/; s/"*$/"/; s/"="/="/g; s/""~/"/g' A4.txt > A5.csv
So if a line already begins (or ends) with double- (or tripple-) quotes, it replaces them with one double-quote character.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I need to insert data into a perticular field of a csv file, lets say second field.
Can any one help me to do this?
I found that we can do it with sed. can any one guide me to accomplish this?
thanks in advance. (12 Replies)
Discussion started by: praveen_b744
12 Replies
2. Shell Programming and Scripting
i have this file which has the following contents:
,-0.3000 ,-0.3000 ,-0.3000
,-0.9000 ,-0.9000 ,-0.9000
i would like to get this:
-0.3-0.9-0.3-0.9-0.3-0.9
so far i am trying:
awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2
any help... (4 Replies)
Discussion started by: npatwardhan
4 Replies
3. Programming
hi all,
i have a select query that gives me the output in the following way...
SYSTYPE
--------------------------------------------------------------------------------
Success Failures Total RFT
---------- ---------- ---------- ----------
TYP
1 0 ... (3 Replies)
Discussion started by: sais
3 Replies
4. Shell Programming and Scripting
Hi ,
i want to change this question, i will post soon.. (6 Replies)
Discussion started by: srikanth2567
6 Replies
5. Shell Programming and Scripting
Hi,
I have a requirment where I need to pull different columns from a .csv file.
Here is the sample of the csv file.
account,item,flag1,flag2,flag3,flag4,flag5,......feed,tran
I will be have a config.txt file which will have the following information.
item,flag5,flag10,feed,tran... (2 Replies)
Discussion started by: akdevula
2 Replies
6. Shell Programming and Scripting
Hi,
My requirement is to convert the xls to csv file with utf-8 conversion.
Is there any way please suggest me.
Thanks,
Raja (4 Replies)
Discussion started by: cnraja
4 Replies
7. Shell Programming and Scripting
Hi there,
i have a file like that in attachment (PLEVA3_280711_SAP.txt), i would extract some basic information from it and report in a new file or table like this:
i try to use bash and i extract the single object in this way (see attach scriptino.sh), but i receive a strange... (5 Replies)
Discussion started by: alen192
5 Replies
8. Shell Programming and Scripting
My source file is pipe delimeted file with 53 fields.In 33 rd column i am getting mutlple new line characters,dule to that record is breaking into multiple records.
Note : here record delimter also \n
sample Source file with 6 fields :
1234|abc| \nabcd \n bvd \n cde \n |678|890|900\n
... (6 Replies)
Discussion started by: lakshmi001
6 Replies
9. Shell Programming and Scripting
hi
I have a csv file with few rows
> cat job_stat
1,jobname1,somthing,somthing
2,jobname2,somthing,somthing
3,jobname3,somthing,somthing
4,jobname4,somthing,somthing
I want to add few columns after the 2nd column and then append rest of the columns after the 3rd newly added... (3 Replies)
Discussion started by: midhun19
3 Replies
10. UNIX for Dummies Questions & Answers
Hi I have a file like this:
a=1
b=2
c=3
a=4
b=2
d=3
a=3
c=4
How can I change this to csv format
a,b,c,d
1,2,3,,
4,2,,3
3,,4,,
Please use code tags next time for your code and data. Thanks (10 Replies)
Discussion started by: sandip_2014
10 Replies
LEARN ABOUT FREEBSD
openpam_readword
OPENPAM_READWORD(3) BSD Library Functions Manual OPENPAM_READWORD(3)
NAME
openpam_readword -- read a word from a file, respecting shell quoting rules
LIBRARY
Pluggable Authentication Module Library (libpam, -lpam)
SYNOPSIS
#include <sys/types.h>
#include <stdio.h>
#include <security/pam_appl.h>
#include <security/openpam.h>
char *
openpam_readword(FILE *f, int *lineno, size_t *lenp);
DESCRIPTION
The openpam_readword() function reads the next word from a file, and returns it in a NUL-terminated buffer allocated with malloc(3).
A word is a sequence of non-whitespace characters. However, whitespace characters can be included in a word if quoted or escaped according
to the following rules:
o An unescaped single or double quote introduces a quoted string, which ends when the same quote character is encountered a second time.
The quotes themselves are stripped.
o Within a single- or double-quoted string, all whitespace characters, including the newline character, are preserved as-is.
o Outside a quoted string, a backslash escapes the next character, which is preserved as-is, unless that character is a newline, in which
case it is discarded and reading continues at the beginning of the next line as if the backslash and newline had not been there. In all
cases, the backslash itself is discarded.
o Within a single-quoted string, double quotes and backslashes are preserved as-is.
o Within a double-quoted string, a single quote is preserved as-is, and a backslash is preserved as-is unless used to escape a double
quote.
In addition, if the first non-whitespace character on the line is a hash character (#), the rest of the line is discarded. If a hash charac-
ter occurs within a word, however, it is preserved as-is. A backslash at the end of a comment does cause line continuation.
If lineno is not NULL, the integer variable it points to is incremented every time a quoted or escaped newline character is read.
If lenp is not NULL, the length of the word (after quotes and backslashes have been removed) is stored in the variable it points to.
RETURN VALUES
If successful, the openpam_readword() function returns a pointer to a dynamically allocated NUL-terminated string containing the first word
encountered on the line.
The caller is responsible for releasing the returned buffer by passing it to free(3).
If openpam_readword() reaches the end of the line or file before any characters are copied to the word, it returns NULL. In the former case,
the newline is pushed back to the file.
If openpam_readword() reaches the end of the file while a quote or backslash escape is in effect, it sets errno to EINVAL and returns NULL.
IMPLEMENTATION NOTES
The parsing rules are intended to be equivalent to the normal POSIX shell quoting rules. Any discrepancy is a bug and should be reported to
the author along with sample input that can be used to reproduce the error.
SEE ALSO
openpam_readline(3), openpam_readlinev(3), pam(3)
STANDARDS
The openpam_readword() function is an OpenPAM extension.
AUTHORS
The openpam_readword() function and this manual page were developed by Dag-Erling Smorgrav <des@des.no>.
BSD
September 12, 2014 BSD