Remove string between number and character

Top Forums UNIX for Beginners Questions & Answers Remove string between number and character

06-09-2017

Registered User

1,781, 705

Join Date: May 2008

Last Activity: 10 November 2021, 5:38 PM EST

Posts: 1,781

Thanks Given: 62

Thanked 705 Times in 653 Posts

Clean and show:

Code:

perl -nle '@p=/^(\d+).*?(?=DB)(.*)/ and print "@p"' example
35818 DB-3754
44412 DB-3747
54432 DB-3725
55522 DB-3755 DB-3721 DB-3361 DB-3327 DB-3688 DB-3750 DB-3677 DB-3728 DB-3730

Clean and convert:

Code:

perl -nle '($k,$v) = /^(\d+).*?(?=DB)(.*)/; for(split (/\s+/, $v)){print "$k $_"}' example
35818 DB-3754
44412 DB-3747
54432 DB-3725
55522 DB-3755
55522 DB-3721
55522 DB-3361
55522 DB-3327
55522 DB-3688
55522 DB-3750
55522 DB-3677
55522 DB-3728
55522 DB-3730

Aia

View Public Profile for Aia

Find all posts by Aia

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

gawk to remove last character in a line or string

I am outputting a line like this print $2 "/" $4The last character though is a ":" and I want to remove it. Is there any neat way to remove it? Or am I forced to do something like this: print $2 "/" substr($4, 1, length($4) - 1)Thanks.

2. Shell Programming and Scripting

Bash: How to remove the last character of a string?

In bash, how can one remove the last character of a string? In perl, the chop function would remove the last character. However, I do not know how to do the same job in bash. Many thanks in advance.

3. Shell Programming and Scripting

remove the first and last character of a string

How can i remove the first and last character of strings like below: "^^^613*" "admt130" "^^^613*" "123456" "adg8484" "DQitYV09dh1C" Means i wanna remove the quotes(""). Please help

4. Shell Programming and Scripting

remove all occurrences of a character at the beginning of a string

Hi there, i need some help to remove all occurrences of a certain character at the beginning of a string. Example: my string is 00102030 and i want to remove all zeros from beginning of string so the result is 102030

5. Shell Programming and Scripting

Sed is doing my head in! How do you remove the first character of a string?

Hello! Please bare with me, I'm a total newbie to scripting. Here's the sudo code of what I'm trying to do: Get file name Does file exist? If true get length of file name get network id (this will be the last 3 numbers of the file name) loop x 2 If...

6. Shell Programming and Scripting

How to remove last character in a string read from file

Hello, The last character is a comma , I have tried the following: sed -e 's/\,$//' filename-to-read however - there are still commas at the end of each line...:confused:

7. Shell Programming and Scripting

How to remove the first character on a string in a variable

Hi all, Does anyone know how to code in ksh that will remove the first character in a string variable and replace that variable without the first character? Example: var1=ktest1 will become var1=test1 var2=rtest2 will become var2=test2 Need help please.

8. Shell Programming and Scripting

shell script to remove the last character(.) of a string

hi I have a list of words in a text file. these words are appended by "." at their end. They look something like this. word1. word2. word3. word4. word5. I need to remove the last character "." from all the words. The output must look something like this. word1 word2 word3...

9. Shell Programming and Scripting

Remove box like special character from end of string

Hi All, How to remove a box like special character which appears at the end of a string/line/record. I have no clue what this box like special character is. It is transparent square like box. This appears in a .DAT file at the end of header. I'm to compare a value in header with a parameter....

10. Shell Programming and Scripting

Pulling the first and last character/number from a string.

Let's say I have a word "foobar23" in a file, and I want to pull the first "f" and last "3" character out of the world, how would I accomplish that? # cat file foobar23 I want the output to be: f3

LEARN ABOUT SUSE

mlm

FBB::mlm(3bobcat)                                             OFoldStream manipulator                                            FBB::mlm(3bobcat)

NAME

       FBB::mlm - Manipulator modifying left margins of OFoldStream objects

SYNOPSIS

       #include <bobcat/ofoldstream> or
       #include <bobcat/ofoldstreambuf>
       Linking option: -lbobcat

DESCRIPTION

       The  mlm  class  implements  a  manipulator that can be inserted into OFoldStream objects to modify the stream's left margin by a requested
       amount. The request cannot result in a negative left margin value. If a negative left margin would be the arithmetic result of the  request
       then left margin 0 will silently be used.

       Depending  on  the  tab-setting  of  the  OFoldStream  the  inserted value represents the number of blank space characters or the number of
       tab-characters that will be added to the left margin.

       The request will be processed at the next newline character or std::flush or std::endl manipulator that is inserted into the stream.  If  a
       line  is  still empty once an mlm object and a flush manipulator are inserted into the stream then the new left margin will be effective at
       the next word inserted into that line (cf., the example section below)

       A bad_cast exception is thrown when the manipulator is inserted into an ostream that is not using a OFoldStreambuf buffer.

NAMESPACE

       FBB
       All constructors, members, operators and manipulators, mentioned in this man-page, are defined in the namespace FBB.

INHERITS FROM

       -

CONSTRUCTOR

       o      mlm(int addValue):
              The standard copy constructor is available.

MEMBER FUNCTIONS

       There are no public or protected member functions in this class.

EXAMPLE

           #include <iostream>
           #include <bobcat/ofoldstream>

           using namespace std;
           using namespace FBB;

           int main()
           {
               OFoldStream out(cout, 0, 80);
               out << "hello world (left margin is 0)" << mlm(4) << "
"
                      "this uses a 4 character wide left margin
" <<
                       mlm(-10) << flush <<
                       "left margin -6 changed to 0, active on this line
";
               return 0;
           }

FILES

       bobcat/mlm - defines the class interface

SEE ALSO

       bobcat(7), manipulators(3bobcat), lm(3bobcat), ofoldstream(3bobcat)

BUGS

       None Reported.

DISTRIBUTION FILES

       o      bobcat_3.01.00-x.dsc: detached signature;

       o      bobcat_3.01.00-x.tar.gz: source archive;

       o      bobcat_3.01.00-x_i386.changes: change log;

       o      libbobcat1_3.01.00-x_*.deb: debian package holding the libraries;

       o      libbobcat1-dev_3.01.00-x_*.deb: debian package holding the libraries, headers and manual pages;

       o      http://sourceforge.net/projects/bobcat: public archive location;

BOBCAT

       Bobcat is an acronym of `Brokken's Own Base Classes And Templates'.

COPYRIGHT

       This is free software, distributed under the terms of the GNU General Public License (GPL).

AUTHOR

       Frank B. Brokken (f.b.brokken@rug.nl).

libbobcat1-dev_3.01.00-x.tar.gz                                      2005-2012                                                   FBB::mlm(3bobcat)

UNIX for Beginners Questions & Answers