10-28-2008
substitute commas with pipe
Hi All,
I have a file that contain value below:
test,mno,mno, +asc
mno,lok,msyu,tts
test,poi,test,0,90, 3,00
i need to substitute the comma's into pipe where i used the command below
:s/,/|/g
then it change to below:
test|mnb|mno| +asc
mno|lok|msyu|tts
test|poi|test|0|90| 3|00
my objective is to change all the commas to pipe but for the 0|90 and 3|00 i want it to maintain the comma's which is 0,90 and 3,00?So any suggestion?
10 More Discussions You Might Find Interesting
1. HP-UX
I've a text file which is delimeted by a comma. But there are some commas in side a quoted string. For ex:
My file a1.txt contains:
"ab,bef",a,b,1,2,"abcde",0,
If you look at the above line, the shell script should give me a count of commas which is 7 according to the above example.... (2 Replies)
Discussion started by: obedkhan
2 Replies
2. UNIX for Dummies Questions & Answers
There is one question. I have a string(suppose $str). If it starts with a comma(there can be more than one comma at the start),I have to remove all the commas from the beginning.So i have to check if the string starts with a comma.If it does,I have to delete all the commas which are at the start of... (1 Reply)
Discussion started by: abhinavsinha
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
Newbie here. I have a file that consists of data that I want to convert to a csv file. For example:
Jul 20 2008 1111 / visit home / BlackBerry8830/4.2.2 Profile/MIDP-2.0 Configuration/CLOC-1.1 VendorID/105
Jul 21 2008 22222 / add friend / BlackBerry8830/4.2.2 Profile/MIDP-2.0... (3 Replies)
Discussion started by: kangaroo
3 Replies
4. Shell Programming and Scripting
Hi,
Can any one tell me how to replace one or more tabs from start of the line and in between the words with commas in the file using unix commands?
My actual data in the text file is as below with spaces.The spaces are not being shown in the post..please see them while replying to the post.... (1 Reply)
Discussion started by: tucs_123
1 Replies
5. Shell Programming and Scripting
i have the below line as output from a script. I want to delete the string "," and get the output without comma,
cat D* | grep "bytes free" | awk '{print $3}' | ?????
output:
40,966,189,056
Desired O/P:
40966189056 (1 Reply)
Discussion started by: ali560045
1 Replies
6. Shell Programming and Scripting
Hi All ,
Is there any way to replace the pipe ( | ) with the broken pipe (0xA6) in unix (1 Reply)
Discussion started by: saj
1 Replies
7. Shell Programming and Scripting
Hi experts,
I would like a favour from you guys to get the info from 5th column which was separated by the delimeter comma ( , )
The Data file is as below:-
1,USER1,"90, TEST AVENUE, OLD ROAD",test1,124,N
2,USER2,88 TEST STREET NEW ROAD,test2,123,N
The User File is as below:-
USER1... (1 Reply)
Discussion started by: shenkz
1 Replies
8. Shell Programming and Scripting
Hey guys,
I have the following text:
1,2,3,4,5,6,'NULL','when',NULL,1,2,0,'NULL'
1,2,3,4,5,6,'NULL','what','NULL',1,2,0,1
I need the same text with the word NULL without commas
u know something like this:
1,2,3,4,5,6,NULL,'when',NULL,1,2,0,NULL
1,2,3,4,5,6,NULL,'what','NULL',1,2,0,1
... (1 Reply)
Discussion started by: lmyk72
1 Replies
9. Shell Programming and Scripting
Hi guys,
I need to know how i can ignore Pipe '|' if Pipe is coming as a column in Pipe delimited file
for eg:
file 1:
xx|yy|"xyz|zzz"|zzz|12...
using below awk command
awk 'BEGIN {FS=OFS="|" } print $3
i would get xyz
But i want as :
xyz|zzz to consider as whole column... (13 Replies)
Discussion started by: rohit_shinez
13 Replies
10. UNIX for Beginners Questions & Answers
Original content:
ACACCTCAT 129 | ACACCTCAT 0
ACACCTCATX 171 | ACACCTCATX 0
ACACRESRT 0 ACACRESRT 0
ACACRESRTX 0 ... (4 Replies)
Discussion started by: loktamann
4 Replies
test(1sh5) test(1sh5)
Name
test - condition evaluation command
Syntax
test expr
[ expr ]
Description
The command evaluates the expression expr. If the value of expr is true, the command returns a zero exit status; otherwise, it returns a
nonzero exit status. The command also returns a nonzero exit status if no arguments are specified. The following primitives are used to
construct expr:
-r file True if file exists and is readable.
-w file True if file exists and is writable.
-x file True if file exists and is executable.
-f file True if file exists and is a regular file.
-d file True if file exists and is a directory.
-c file True if file exists and is a character special file.
-b file True if file exists and is a block special file.
-p file True if file exists and is a named pipe (fifo).
-u file True if file exists and its set-user-ID bit is set.
-g file True if file exists and its set-group-ID bit is set.
-k file True if file exists and its sticky bit is set.
-s file True if file exists and has a size greater than zero.
-t [ fildes ] True if the open file whose file descriptor number is fildes (1 by default) is associated with a terminal device.
-z s1 True if the length of string s1 is zero.
-n s1 True if the length of the string s1 is non-zero.
s1 = s2 True if strings s1 and s2 are identical.
s1 != s2 True if strings s1 and s2 are not identical.
s1 True if s1 is not the null string.
n1 -eq n2 True if the integers n1 and n2 are algebraically equal. Any of the comparisons -ne, -gt, -ge, -lt, and -le may be used in
place of -eq.
These primitives can be combined with the following operators:
! unary negation operator.
-a binary and operator.
-o binary or operator (-a has higher precedence than -o).
( expr ) parentheses for grouping.
Note that all the operators and flags are separate arguments to the command. Note also that parentheses are meaningful to the Shell and
must be escaped. In the form of the command that uses square brackets ([]), instead of the word test, the brackets must be delimited by
blanks.
See Also
find(1), sh5(1), test(1)
test(1sh5)