Sponsored Content
Top Forums Shell Programming and Scripting awk/sed to search & replace data in first column Post 302542880 by yazu on Friday 29th of July 2011 12:53:06 AM
Old 07-29-2011
Ok, you do not have GNU date and you have two patterns in your input file. You want that there is only one pattern.

Mon Jul 18 00:32:52 EDT 2011,NULL,UAT # changes to Jul 18 2011,NULL,UAT
Jul 19 2011,NULL,UAT # not changes

Yes?

---------- Post updated at 11:53 AM ---------- Previous update was at 11:49 AM ----------

You don't need and date command if I'm right about pattern but it's just a habit (maybe bad one) to ask about it any time when I see questions about date manipulations.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help, sed search&replace

Plzzzz, tell me some script about this... What does this mean ? sed '/^ */s///' sed '/^/s// /' and why it's diferent ??? sed '/ */s// /g' and sed 's/ */ /g'. It's all the same ??? Thanks you very much (2 Replies)
Discussion started by: mle
2 Replies

2. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies

3. Shell Programming and Scripting

Help with sed search&replace between two strings

Hi, i read couple of threads here on forum, and googled about what bugs me, yet i still can't find solution. Problem is below. I need to change this string (with sed if it is possible): This is message text that is being quoted to look like this: This is message text that is being quotedI... (2 Replies)
Discussion started by: angrybb
2 Replies

4. Shell Programming and Scripting

awk/sed string search and replace

Need help with either sed or awk to acheive the following file1 ----- In the amazon forest The bats eat all the time... mon tue wed they would eat berries In the tropical forest The bats eat all the time... on wed bats eat nuts In the rain forest The bats eat all the time... on... (2 Replies)
Discussion started by: jville
2 Replies

5. Shell Programming and Scripting

Using sed to search and replace data

Hi, Kindly need your expertise in this problem. I have to search and replace data. The problem is, the data is in the same format but slightly different content. What I need is sed commands that can work for those "slightly different content". input: ... (3 Replies)
Discussion started by: Alvin123
3 Replies

6. Shell Programming and Scripting

Search & replace content using awk/gsub

Hi, I have two files master.txt & reference.txt. Sample below Master.txt 2372,MTS,AP 919848001104,Airtel,DL 0819,MTS,MUM 919849788001,Airtel,AP 1430,Aircel MP,20 Reference.txt 2372,919848701430,46467 919848002372,2372,47195 2372,919849788001,59027 0819,028803,1 0819,029801,1... (2 Replies)
Discussion started by: siramitsharma
2 Replies

7. Shell Programming and Scripting

Search & Replace content of files using gsub in awk

Hi,I have 2 files master.txt & reference.txt as shown below & i require o/p as mentioned in file 3 using awk but content is not replacing properlymaster.txt:... (15 Replies)
Discussion started by: siramitsharma
15 Replies

8. Shell Programming and Scripting

awk to search for specific line and replace nth column

I need to be able to search for a string in the first column and if that string exists than replace the nth column with "-9.99". AW12000012012 2.38 1.51 3.01 1.66 0.90 0.91 1.22 0.82 0.57 1.67 2.31 3.63 0.00 AW12000012013 1.52 0.90 1.20 1.34 1.21 0.67 ... (14 Replies)
Discussion started by: ncwxpanther
14 Replies

9. Shell Programming and Scripting

How to search and replace string in column in file with command sed?

how to search and replace string in column in file with command sed or other search "INC0000003.in" and replace column 4 = "W" $ cat file.txt INC0000001.in|20150120|Y|N|N INC0000002.in|20150120|Y|N|N INC0000003.in|20150120|Y|N|N INC0000004.in|20150120|Y|N|Noutput... (4 Replies)
Discussion started by: ppmanja3
4 Replies

10. Shell Programming and Scripting

awk search and replace nth column by using a variable.

I am passing a variable and replace nth value with the variable. I tried using many options in awk command but unable to ignore the special characters in the output and also unable to pass the actual value. Input : "1","2","3" Output : "1","1000","3" TempVal=`echo 1000` Cat... (2 Replies)
Discussion started by: onesuri
2 Replies
DOVEADM-SEARCH-QUERY(7) 					      Dovecot						   DOVEADM-SEARCH-QUERY(7)

NAME
doveadm-search-query - Overview of search queries for doveadm mailbox commands DESCRIPTION
Several doveadm(1) commands use a search_query in order to act only on matching messages. This manual page describes all SEARCH KEYS, which can be used in a search_query. Each search_query consists at least of one SEARCH KEY. Most of the SEARCH KEYS require an argument. All SEARCH KEYS are case-insensitive. The shortest valid search_query is ALL. For example: doveadm search ALL Multiple search query expressions will be combined with the AND operator by default. To find all messages that are new and greater than 50 kilobyte, one can use: doveadm search NEW LARGER 50k OR-ed SEARCH KEYS have to be written in parenthesis, when mixing ANDs and ORs. Shells commonly require escaping for parentheses. To find messages that were saved on the "13th of April 2007" AND have the Seen and/or Flagged flag set, one can use for example: doveadm search SAVEDON 2007-04-13 ( SEEN OR FLAGGED ) It's also possible to specify the mailbox, in which should be searched. Use either the keyword mailbox and the name of the mailbox or the keyword mailbox-guid and the mailbox's globally unique identifier in the search_query. To find all messages in the mailbox with the GUID "44f68b13ce97044b837f000035ca9452" use: doveadm search mailbox-guid 44f68b13ce97044b837f000035ca9452 ALL To list all deleted messages in the "Trash" folder use: doveadm search mailbox Trash DELETED SEARCH KEYS
The following search keys from the specification of IMAP version 4 revision 1 (see: RFC 3501, section 6.4.4) are supported: ALL Matches all messages. ANSWERED Matches messages with the IMAP flag Answered set. BCC pattern Matches messages, which contain pattern in the BCC field of the message's IMAP envelope structure. BEFORE date specification Matches messages with an internal date before date specification. BODY pattern Matches messages, which contain pattern in the body part. CC pattern Matches messages, which contain pattern in the CC field of the message's IMAP envelope structure. DELETED Matches messages with the IMAP flag Deleted set. DRAFT Matches messages with the IMAP flag Draft set. FLAGGED Matches messages with the IMAP flag Flagged set. FROM pattern Matches messages, which contain pattern in the FROM field of the message's IMAP envelope structure. HEADER field pattern Matches messages, which either have the named header field, when empty pattern was given. Or messages, where the given header field's value contains the specified pattern. KEYWORD keyword Matches messages with the given IMAP keyword (e.g. $Forwarded) flag set. LARGER size Matches messages that are larger than the specified size. MAILBOX name Matches messages in the mailbox with the specified name. MAILBOX-GUID guid Matches messages in the mailbox with the specified guid. NEW Matches messages, which have the IMAP flag Recent set but not the IMAP flag Seen. NOT search key Inverse matching - matches massages, where the search doesn't match the specified search key or its value. OLD Matches messages, which do not have the IMAP flag Recent set. ON date specification Matches messages whose internal date matches the given date specification. search key OR search key Matches messages where one of the OR-ed search keys matches. Note: IMAP4rev1 uses the syntax: OR search key search key RECENT Matches messages with the IMAP flag Recent set. SEEN Matches messages with the IMAP flag Seen set. SENTBEFORE date specification Matches messages with a Date: header before date specification. SENTON date specification Matches messages with a Date: header matching the given date specification. SENTSINCE date specification Matches messages with a Date: header matching or after the given date specification. SINCE date specification Matches messages whose internal date is within or after the given date specification. SMALLER size Matches messages with a size smaller than the given size. SUBJECT pattern Matches messages, which contain pattern in the SUBJECT field of the message's IMAP envelope structure. TEXT pattern Matches messages, which contain pattern in the message body. TO pattern Matches messages, which contain pattern in the TO field of the message's IMAP envelope structure. UID sequence Matches messages with the given UID(s). A sequence may be a single UID. Can be a sequence range, written as from:to, e.g. 100:125. As comma separated list of UIDs, e.g. 11,50,4. It's also possible to combine multiple sequences, e.g. 1,3,5,7,10:20. UNANSWERED Matches messages, which do not have the IMAP flag Answered set. UNDELETED Matches messages, which do not have the IMAP flag Deleted set. UNDRAFT Matches messages, which do not have the IMAP flag Draft set. UNFLAGGED Matches messages, which do not have the IMAP flag Flagged set. UNKEYWORD keyword Matches messages, which do not have the given IMAP keyword flag set UNSEEN Matches messages, which do not have the IMAP flag Seen set. DOVEADM SEARCH KEYS Additional search keys, provided by doveadm(1). SAVEDBEFORE date specification Matches messages, which were saved before date specification. SAVEDON date specification Matches messages whose save date matches the given date specification. SAVEDSINCE date specification Matches messages with a save date matching or after the given date specification. DATE SPECIFICATION
doveadm(1) supports a few additional date specification formats. They can be used anywhere, where a date specification value is obliga- tory. day-month-year Default IMAP4rev1 date format. day, the day of month: 1-31. month, the abbreviated month name: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov or Dec. year, four digits of year, e.g. 2007. For example the "13th of April 2007" will be represented as 13-Apr-2007. interval Combination of a positive integer number and a time unit. Available time units are: weeks (abbr: w), days (abbr: d), hours (abbr: h), mins (abbr: m) and secs (abbr: s). To match messages from last week, you may specify for example: since 1w, since 1weeks or since 7days. Unix timestamp A 10 digit Unix timestamp, seconds since the 1st of January 1970, 00:00:00 UTC. For example the "13th of April 2007" will be repre- sented as 1176418800. YYYY-MM-DD Extended ISO-8601 calendar date format. For example the "13th of April 2007" will be represented as 2007-04-13. SIZE
doveadm(1) provides also an additional size representation format. The following formats can be used anywhere, where a size value is obligatory. octets The message size in octets, as specified in the IMAP4rev1 specification. size The message size in B (byte), k (kilobyte), M (megabyte), G (gigabyte) or T (terabyte). To match messages, bigger than 1 megabyte, you may specify for example: larger 1M or larger 1024k. SEE ALSO
doveadm(1), doveadm-search(1) Dovecot v2.2 2011-11-24 DOVEADM-SEARCH-QUERY(7)
All times are GMT -4. The time now is 08:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy