04-19-2013
Do you want delete 6th delimiter not last delimeter right ??
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have some files, with some extra lines in weird characters on the top and bottom of the. I want to get rid of those line. Is there a way I can do that?
example of the input file. I want to get rid of those lines in bold
... (8 Replies)
Discussion started by: CamTu
8 Replies
2. UNIX for Dummies Questions & Answers
Hi...
I am quite new to Unix and would like an issue to be resolved.
I have a file in the format below;
4,Reclaim,ECXTEST02,abc123,Harry Potter,5432 6730 0327 5469,0603,,MC,,1200,EUR,sho-001,,1,,,abc123,1223
I would like my output to be as follows;
4,Reclaim,ECXTEST02,abc123,Harry... (4 Replies)
Discussion started by: Sho
4 Replies
3. Shell Programming and Scripting
Hi,
I need a help in deleting extra spaces in a text.
I have a huge file, a part of it is :-
3 09/21/08 03:32:07 started undef mino Oracle nmx004.wwdc.numonyx.com Message Text : The Oracle session with the PID 1103 has a CPU time ... (6 Replies)
Discussion started by: vikas027
6 Replies
4. Shell Programming and Scripting
Hi,
I have a source file as mentioned below: I want to remove all the extra spaces between the fields.
a b--------|sa df-------|3232---|3
sf sa------|afs sdf-----|43-----|33
a b c------|adfsa dsf---|23-32|23
*Here '-' idicates spaces
Now, I want output as below:
a b|sa df|3232|3... (7 Replies)
Discussion started by: srilaxmi
7 Replies
5. Shell Programming and Scripting
Hi,
I have a string like this and i want to remove extra spaces that exists between the words.
Here is the sentence.
$string="The small DNA genome of hepadnaviruses is replicated by reverse transcription via an RNA intermediate. This RNA "pregenome" contains ... (2 Replies)
Discussion started by: vanitham
2 Replies
6. Shell Programming and Scripting
Hi
I am using cat <filename> command in one of my datastage job(Command Activity). It is giving actual value but giving extra line.
Eg: Displayed Output: 1 and showing extraline(Eg: 1
) I had checked even wc -c it is giving one character extra.
If the file contains 11. wc -c says 3. ... (3 Replies)
Discussion started by: cnrj
3 Replies
7. UNIX for Dummies Questions & Answers
Guys, I have a file that contains entries like this:
LaxOrdID=19220288<8>
LaxOrdID=19220288
I would like to remove <> and the values inside it anywhere its found.
How? (2 Replies)
Discussion started by: DallasT
2 Replies
8. Shell Programming and Scripting
HI,
I need the help from the experts like I have created one file with text like:
a b c d
e f g h
i j k l
So my question is that i have to write the script in which like in the first sentence it will take only one space after d and remove all the extra space in the end.I dont... (8 Replies)
Discussion started by: bhanudhingra
8 Replies
9. Shell Programming and Scripting
Hi All
I am trying to perform the below operation -count=`cat abc.txt | wc -l`
echo$count
5
Head=Start"$DATE"00000"$count"File
echo $HEAD
START15020300000 5File
There is a space coming before 5 which is not needed . How to ignore that . (4 Replies)
Discussion started by: honey26
4 Replies
10. UNIX for Beginners Questions & Answers
The input file is this:
a|b|c|d
x|y|z|n|||||||||
p|q|r|s|||
g|h|i|
w|e|r||
Now as per requirement , each row should have only 3 delimiter.
Now the 2nd row & last row has an extra delimiter, How to remove that ? In some large file having 100K data , there can be 100 such rows having... (4 Replies)
Discussion started by: ikdKunal
4 Replies
EXPLODE(3) 1 EXPLODE(3)
explode - Split a string by string
SYNOPSIS
array explode (string $delimiter, string $string, [int $limit])
DESCRIPTION
Returns an array of strings, each of which is a substring of $string formed by splitting it on boundaries formed by the string $delimiter.
PARAMETERS
o $delimiter
- The boundary string.
o $string
- The input string.
o $limit
- If $limit is set and positive, the returned array will contain a maximum of $limit elements with the last element containing the
rest of $string. If the $limit parameter is negative, all components except the last -$limit are returned. If the $limit parame-
ter is zero, then this is treated as 1.
Note
Although implode(3) can, for historical reasons, accept its parameters in either order, explode(3) cannot. You must ensure that the
$delimiter argument comes before the $string argument.
RETURN VALUES
Returns an array of strings created by splitting the $string parameter on boundaries formed by the $delimiter.
If $delimiter is an empty string (""), explode(3) will return FALSE. If $delimiter contains a value that is not contained in $string and a
negative $limit is used, then an empty array will be returned, otherwise an array containing $string will be returned.
CHANGELOG
+--------+-----------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-----------------------------------------+
| 5.1.0 | |
| | |
| | Support for negative $limits was added |
| | |
+--------+-----------------------------------------+
EXAMPLES
Example #1
explode(3) examples
<?php
// Example 1
$pizza = "piece1 piece2 piece3 piece4 piece5 piece6";
$pieces = explode(" ", $pizza);
echo $pieces[0]; // piece1
echo $pieces[1]; // piece2
// Example 2
$data = "foo:*:1023:1000::/home/foo:/bin/sh";
list($user, $pass, $uid, $gid, $gecos, $home, $shell) = explode(":", $data);
echo $user; // foo
echo $pass; // *
?>
Example #2
explode(3) return examples
<?php
/*
A string that doesn't contain the delimiter will simply
return a one-length array of the original string.
*/
$input1 = "hello";
$input2 = "hello,there";
var_dump( explode( ',', $input1 ) );
var_dump( explode( ',', $input2 ) );
?>
The above example will output:
array(1)
(
[0] => string(5) "hello"
)
array(2)
(
[0] => string(5) "hello"
[1] => string(5) "there"
)
Example #3
$limit parameter examples
<?php
$str = 'one|two|three|four';
// positive limit
print_r(explode('|', $str, 2));
// negative limit (since PHP 5.1)
print_r(explode('|', $str, -1));
?>
The above example will output:
Array
(
[0] => one
[1] => two|three|four
)
Array
(
[0] => one
[1] => two
[2] => three
)
NOTES
Note
This function is binary-safe.
SEE ALSO
preg_split(3), str_split(3), mb_split(3), str_word_count(3), strtok(3), implode(3).
PHP Documentation Group EXPLODE(3)