Cut date using y hat as delimiter Post: 302129549

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Cut date using y hat as delimiter Post 302129549 by tekster757 on Tuesday 31st of July 2007 12:00:38 PM

07-31-2007

Registered User

Cut date using y hat as delimiter

QUESTION: How can I cut out the date from just the first line and reformat it to 31-Jul-2007? I'll restate the question at the bottom again...

DESCRIPTION: I need to cut a date out of a file - an example of the date's format in the file is 2007-07-31. It's in the 5th field and is separated by y with an accent over it, so I need to print the value of that delimiter. There are 10's of thousands of lines in the file, but I only need to scan the first line for this date. So far I have the following, and while it at least gives me some kind of output, it's obviously not what I need (actually, it's returning every line in the file - I know this because it tried to do that before I copied it to a 'test' file and deleted all the other lines but the first):

DATE=`cut -d 'printf "\375"' -f5 < file.test`

echo $DATE returns the whole line (or really, the whole file), something like this (the y's have a forward accent over them):

18y835y000000ySy2007-06-13y09:40:38y

QUESTION: how can I cut out the date from just the first line and reformat it to 31-Jul-2007?

I found part of the answer:

cat tlog.test | cut -f5 -d`printf "\375"` | tail -1

Produces (I mentioned the wrong date above):

2007-06-13

Now how do I reformat it to 13-Jun-2007 without using a hard-coded date?

Last edited by tekster757; 07-31-2007 at 01:24 PM.. Reason: I found part of the answer

tekster757

View Public Profile for tekster757

Find all posts by tekster757

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

\r as delimiter in cut

I need to use \r as a delimiter in the -d option of the cut comand . Any help ? Thanks in advance . SD

2. Shell Programming and Scripting

Cut Number which appear before a delimiter

Hi All, How can i use the cut option to only output the number of rows, which is 2 is this case ? Pls note that the number of digit before the delimiter ":" is always varying. $ grep -n uuu xxx 2:** xxx yyy gg 44 tt uuu 2007 $

3. UNIX for Advanced & Expert Users

use a word as a delimiter with cut

Is there a way to use a word as a delimiter with cut? Or is there a way to use sed or awk with a word as a delimiter? I don't care which program I use for a delimiter I just want to use a word as a delimiter.

4. Shell Programming and Scripting

cut -d with more than 1 delimiter?

I need to cut or otherwise get the 4th and 5th position output of for i in `date +%H` ; do vnstat --dumpdb | grep "h;$i" ; done example output is: h;13;1310318701;443;93 I only need ";443;93" from any given run of "for i in `date +%H` ; do vnstat --dumpdb | grep "h;$i" ; done" Thanks...

5. Shell Programming and Scripting

Cut columns with delimiter

HI, I have a file like below "103865","103835","Zming","","Zhu","103965","Sunnyvale","US", "116228","116227","Morlla","","Kowalski","113228","Paese "(Treviso)""IT" I want to validate the 7th column which is below. "Sunnyvale" "Paese In the above 7th column Paese is not ended with...

6. Shell Programming and Scripting

how to cut all string after the last delimiter?

hi all, suppose a string: abc/def/ghi/jkl/mn.txt and i want to get the file name without the path. however, different files have different paths, therefore the number of delimiter is uncertain. thanks so much!

7. Shell Programming and Scripting

How to cut by delimiter, and delimiter can be anything except numbers?

Hi all, I have a number of strings like below: //mnt/autocor/43�13'(33")W/ and i'm trying to get the numbers in this string, for example 431333 please help thanks ahead

8. Shell Programming and Scripting

cut with delimiter respect text

9. Shell Programming and Scripting

cut delimiter and save

i have list of names in a text file and I wanted to delete the commas en every line. for example: inside the text is a list of names in it with commas after each line. I wanted to delete these commas. which command must I execute for this? unix, dale, shawn, aaron,

10. Shell Programming and Scripting

Cut cmd with delimiter as |#|

Hi All- We have a file data as below with delimiter as |#| 10|#|20|#|ABC 13|#|23|#|PBC If I want to cut the 2nd field out of this, below command is not working as multiple pipe is causing an issue , it seems cut -f2 -d"|#|" <file_name> can you please help to provide the correct command...

LEARN ABOUT MOJAVE

conjunct

CONJUNCT(1)						      General Commands Manual						       CONJUNCT(1)

NAME

       conjunct - find dates of equinox or new or full moon

SYNOPSIS

       conjunct [options]

DESCRIPTION

       conjunct  searches  for	one of these events: spring equinox (default), summer solstice, autumn equinox, winter solstice, new moon, or full
       moon.

OPTIONS

       -s, --start date
	      Set starting date (default is current date).  The date may be either a Julian day number (e.g. 2454180.0 for noon, 2007 March 20) or
	      an ISO 8601 date (e.g. 2007-03-20).

       -e, --end date
	      Set ending date (default is one year from now).

       -V, --vernal, --spring
	      Search for spring equinox (default).

       -S, --summer
	      Search for summer solstice.

       -A, --autumn, --fall
	      Search for autumn equinox.

       -W, --winter
	      Search for winter solstice.

       -N, --newmoon
	      Search for new moon.

       -F, --fullmoon
	      Search for full moon.

       -h, --help
	      Show summary of options.

SEE ALSO

       aa(1).

AUTHOR

       conjunct was written by Stephen L. Moshier <steve@moshier.net>.

       This manual page was written by James R. Van Zandt <jrv@debian.org>, for the Debian project (but may be used by others).

								  August 24, 2006						       CONJUNCT(1)