I cant write 22 pipes like "\|.*\|.*".
Why not? ;-)
But try this:
c:\@Work\Perl\monks>perl -wMstrict -le
"my $s = 'RcdA|CON|139|||Kan|13|J|J|607|abc@gmail.com';
print qq{'$s'};
;;
$s =~ s{ (?: [|] [^|]*){4} \z }{}xms;
print qq{'$s'};
"
'RcdA|CON|139|||Kan|13|J|J|607|abc@gmail.com'
'RcdA|CON|139|||Kan|13'
I used your original example data and only removed four instances, not 22 (because there weren't that many), but you get the idea.
Give a man a fish: <%-{-{-{-<
| [reply] [d/l] [select] |
| [reply] |
c:\@Work\Perl\monks>perl -wMstrict -le
"use YAPE::Regex::Explain;
;;
print YAPE::Regex::Explain->new(qr{ (?: [|] [^|]*){4} \z }xms)->expla
+in;
"
The regular expression:
(?msx-i: (?: [|] [^|]*){4} \z )
matches as follows:
NODE EXPLANATION
----------------------------------------------------------------------
(?msx-i: group, but do not capture (with ^ and $
matching start and end of line) (with .
matching \n) (disregarding whitespace and
comments) (case-sensitive):
----------------------------------------------------------------------
(?: group, but do not capture (4 times):
----------------------------------------------------------------------
[|] any character of: '|'
----------------------------------------------------------------------
[^|]* any character except: '|' (0 or more
times (matching the most amount
possible))
----------------------------------------------------------------------
){4} end of grouping
----------------------------------------------------------------------
\z the end of the string
----------------------------------------------------------------------
) end of grouping
----------------------------------------------------------------------
But it's difficult to answer questions you haven't asked. Again, please see perlre, perlretut, and perlrequick. (In particular, perlretut has a lot of info. And all this on-line documentation is available at your local command line via perldocperlretut and etc.) Also, please see the articles in the Pattern Matching, Regular Expressions, and Parsing section of the Monastery Tutorials; some of them may address your questions. All this stuff is free, but there are some good book$ out there if you want some recommendations. davido has a nice regex exerciser; see his personal node for a link. I and others will be very happy to answer your questions, but please try to make them as specific as possible.
Give a man a fish: <%-{-{-{-<
| [reply] [d/l] [select] |