OFF 00280456 - 2014|1|2020_STATUS|GROUP_NAME|SUBGROUP_NAME|CLASS_NAME|GROUP_ID|SUBGROUP_ID
I have above header in file. I need to replace 2020_STATUS with STATUS.
2020_STATUS is not always same but the column name will have STATUS all of the time. For instance column name might be 2019_STATUS or 2021_STATUS etc so when i look at these multiple files I need to replace the column with STATUS for these.
I ran this below command and it is working but looks strange to me because in pattern when I keep ^\1 then only it is working so I am not sure why.
Below command is not working.
Code:
sed 's/^[0-9]*\_STATUS/STATUS/' outputOFF_00280456_2014_TEST.txt
Below command is working
Code:
sed 's/^1\|[0-9]*\_STATUS/STATUS/' outputOFF_00280456_2014_TEST.txt
Can you please suggest me what is the best option to do this?
Thanks
Jay
Last edited by Scrutinizer; 12-06-2019 at 04:06 PM..
Reason: code tags please
I am using GnuWin32 sed and am having trouble with the regexp - i.e., they don't behave the same way as in UNIX (POSIX and and all that). I have a stream of data, e.g.:
11111'222?'22'33?'333'44444'55555'
I want to insert a \n after those apostrophes that are *not* preceded by a ?.
... (2 Replies)
please help:
I want to add 1 space between string and numbers:
input file:
abcd12345
output file:
abcd 1234
The following sed command does not work:
sed 's/\(+\)\(+\)/\1 \2/' file
Any ideas, please
Andy (2 Replies)
Basically it should identify what ever is in between /*< >*/ (tags) and replace dbname ending with (.) with the words in between the tags
i.e.
DELETE FROM /*<workDB>*/epd_test./*<multi>*//*<version>*/epd_tbl1 ALL; into
DELETE FROM... (4 Replies)
Hi all,
I have one question regarding sed regexp (or any regexp in general),
I have some path like this
C:/Abc/def/ghi/jkl in a file file1
Now if i use following code
cat file1 | sed 's#\(.*\)/.*#\1#'
Now it give me following output
C:/Abc/def/ghi, which is fine
But i just... (2 Replies)
Hi,
I am not that good with reg exp and sed. But I was just looking at something the other day and came across a situation.
When I ran the below command:
echo "123 word" | sed 's/*/(&)/'
the op was:
(123) word
But when I ran:
echo "123 word" | sed 's/*/(&)/g'
the o/p was:
(123)... (4 Replies)
Dear all
i have the code which print 1 line of context before and after regexp, with line number
sed -n -e '/regexp/{=;x;1!p;g;$!N;p;D;}' -e h
the code work well but any one can tell me what each letter mean {=;x;1!p;g;$!N;p;D;}
also how i can print 2 line before and onle line after ... (2 Replies)
Hi!
I have a file with multiple lines following this format:
<a href="xxx.aaa_bbb_ccc.yyy">xxx.aaa_bbb_ccc.yyy</a>
The goal is to replace the title (not modifying the href) so the new lines looks like this:
<a href="xxx.aaa_bbb_ccc.yyy">Aaa bbb ccc</a>
The number of underscores in the... (2 Replies)
Dealing with Linux servers
script would be in korn or bash shell syntax
file is /etc/fstab
I want to insert something if regex is matched to all matched lines in the /etc/fstab file and print out entire /etc/fstab file with the changes
example
58.228.111.111:/my/file/system... (5 Replies)
Hi everyone, I would really appreciate any help I could get on the following topic.
I am not very familiar with reg expressions nor with sed, I just know the basic uses. What I am trying to do is the following: I have a huge text file where I would like to replace all occurnces of a certain... (13 Replies)
G'day,
Here's a teaser for a sed guru, which I surely am not one, as even my
basic sed skills are rusted from years of not practising ... lol
Ok ... we have a string of digits such as:
632413741610252847552619172459483022433027602515212950543016701812771409213148672112
we want it split... (9 Replies)
Discussion started by: naderra
9 Replies
LEARN ABOUT DEBIAN
cfourcc
cfourcc(1) User Commands cfourcc(1)NAME
cfourcc - tool for changing FourCC in Microsoft RIFF AVI files
SYNOPSIS
cfourcc [-i] <file.avi>
cfourcc -u <CODE> <file.avi>
OPTIONS -h Show summary of options.
-d CODE
Sets FOURCC codec decription string.
-f Force changing FOURCC on unsupported file
-i Display FOURCC information (default).
-u CODE
Set FOURCC codec.
None.
DESCRIPTION
Program identifies the codec used in AVI files (*.avi) and allows the user to change the FourCC description code (like fourcc-changer in
Windows). Useful for people working with Microsoft AVI file. A Linux clone of AviC fourcc changer tool.
EXAMPLES
Note that you only need to change the -u codec field most of the time and not touch the -d description:
cfourcc -u DIVX -d DIVX file.avi
ENVIRONMENT
None.
FILES
None.
SEE ALSO ffmpeg(1)mplayer(1)AUTHORS
cfourcc was written by Mohammad Hafiz bin Ismail aka "mypapit" <info@mypapit.net>.
This manual page was written by Jarno Elonen <elonen@debian.org>, for the Debian project (but may be used by others). Updated by Jari Aalto
<jari.aalto@cante.net>. Released under license GNU GPL v2 or (at your option) any later version. For more information about license, visit
<http://www.gnu.org/copyleft/gpl.html>.
cfourcc 2012-04-02 cfourcc(1)