Sponsored Content
Top Forums Shell Programming and Scripting convert d/m/yyyy to YYYY-MM-DD Post 302351846 by vgersh99 on Wednesday 9th of September 2009 06:04:14 PM
Old 09-09-2009
Code:
nawk -F, -v OFS=, '{split($4,a,"/");$4=sprintf("%s-%02d-%02d", a[3],a[1],a[2])}1' myFile.csv

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Change Date from dd-mmm-yyyy to mm/dd/yyyy

I want to change a date from format dd-mmm-yyyy to mm/dd/yyyy. Is there a way to do this with sed or do you have to write a case statement to convert JAN to 01? Thanks (9 Replies)
Discussion started by: stringzz
9 Replies

2. Shell Programming and Scripting

converting the date field from dd/mm/yyyy to yyyy/mm/dd

How to convert the date field from dd/mm/yyyy to yyyy/mm/dd in unix my script will generate text file which have two fields one is date and another is name of the server for example this is sample date which I have to sort based on older to newer date the problem is when I found out sort will... (4 Replies)
Discussion started by: pareshan
4 Replies

3. Shell Programming and Scripting

Convert DD-MMM-YYYY to MM-DD-YYYY

I have a file which has 100k+ records like this abc,05-JUN-1974,def,lkj,aaa def,11-SEP-1975,ghj,dis,dea I want to convert ex 05-JUN-1974 to 06/05/1974 Please help me with awk script to convert the whole file into MM-DD-YYYY Thank you! (2 Replies)
Discussion started by: nuthalapati
2 Replies

4. Shell Programming and Scripting

Sed: zero-padding dates (or: convert d/m/yyyy to dd/mm/yyyy)

Hi all I have some pipe-separated data in the form: 5/12/2008 00:00:00|31/1/2009 00:00:00|SOMESTUFF|OTHERSTUFF 12/31/2008 00:00:00|15/1/2009 00:00:00|MORESTUFF|REMAININGSTUFF 1/1/1023 00:00:00|16/5/2047 00:00:00|THEREST|YETMORE I need to zero-pad the single-digit days and months, using... (3 Replies)
Discussion started by: jgrogan
3 Replies

5. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

(Attention: Green PHP newbie !) I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Discussion started by: keyboarder
6 Replies

6. Shell Programming and Scripting

Converting date DD MM YYYY to DD MON YYYY

Hello, I am writing a script that parses different logs and produces one. In the source files, the date is in DD MM YYYY HH24:MI:SS format. In the output, it should be in DD MON YYY HH24:MI:SS (ie 25 Jan 2010 16:10:10) To extract the dates, I am using shell substrings, i.e.: read line ... (4 Replies)
Discussion started by: Adamm
4 Replies

7. Shell Programming and Scripting

Date conversion help from dd/mm/yyyy to dd/Mon/yyyy i.e. 28/10/2012 to 28/Oct/2012

Hi I have a problem with Date format in my code. 1st I am trying to convert today's date to yesterday's using YESTERDAY3=`perl -e '@y=localtime(time()-86400); printf "%04d/%02d/%02d",$y+1900,$y+1,$y;$y;'` And once it is done I am trying to using the yesterday date in a grep command to... (3 Replies)
Discussion started by: nithinankam
3 Replies

8. UNIX for Dummies Questions & Answers

Epoch date to YYYY/MM/DD or MM/DD/YYYY

I've seen a lot of posts on this and have tried the following: echo 1257000000| perl -e '($d,$m,$y)=(localtime(time-86400));$m+=1;$y+=1900;printf "$y/$m/$d\n";' But I am unable to convert a past Epoch date into a format such as YYYY/MM/DD or MM/DD/YYYY. I am using bash and don't know... (4 Replies)
Discussion started by: newbie2010
4 Replies

9. Shell Programming and Scripting

Bash to convert to m-d-yyyy

I am using bash that when run downloads a file a verifies that there is data in it. What I am not able to do is have a user enter a date in any format they wish and have it converted to m-d-yyyy. Thank you :). Bash printf " Welcome to NGS analysis, checking for new files and creating a... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. Shell Programming and Scripting

Date format YYYY/MM/DD to DD/MM/YYYY

I am getting output of YYYY-MM-DD and want to change this to DD/MM/YYYY. When am running the query in 'Todd' to_date(column_name,'DD/MM/YYYY') am getting the required o/p of DD/MM/YYYY, But when am executing the same query(Netezza) in linux server(bash) am getting the output of YYYY-MM-DD file... (3 Replies)
Discussion started by: Roozo
3 Replies
SPRINTF(3)								 1								SPRINTF(3)

sprintf - Return a formatted string

SYNOPSIS
string sprintf (string $format, [mixed $args], [mixed $...]) DESCRIPTION
Returns a string produced according to the formatting string $format. PARAMETERS
o $format - The format string is composed of zero or more directives: ordinary characters (excluding %) that are copied directly to the result, and conversion specifications, each of which results in fetching its own parameter. This applies to both sprintf(3) and printf(3). Each conversion specification consists of a percent sign ( %), followed by one or more of these elements, in order: o An optional sign specifier that forces a sign (- or +) to be used on a number. By default, only the - sign is used on a number if it's negative. This specifier forces positive numbers to have the + sign attached as well, and was added in PHP 4.3.0. o An optional padding specifier that says what character will be used for padding the results to the right string size. This may be a space character or a 0 (zero character). The default is to pad with spaces. An alternate padding character can be specified by prefixing it with a single quote ( '). See the examples below. o An optional alignment specifier that says if the result should be left-justified or right-justified. The default is right-justified; a - character here will make it left-justified. o An optional number, a width specifier that says how many characters (minimum) this conversion should result in. o An optional precision specifier in the form of a period ( .) followed by an optional decimal digit string that says how many decimal digits should be displayed for floating-point numbers. When using this specifier on a string, it acts as a cutoff point, setting a maximum character limit to the string. Additionally, the character to use when padding a number may optionally be specified between the period and the digit. o A type specifier that says what type the argument data should be treated as. Possible types: o % - a literal percent character. No argument is required. o b - the argument is treated as an integer, and presented as a binary number. o c - the argument is treated as an integer, and presented as the character with that ASCII value. o d - the argument is treated as an integer, and presented as a (signed) decimal number. o e - the argument is treated as scientific notation (e.g. 1.2e+2). The precision specifier stands for the number of digits after the decimal point since PHP 5.2.1. In earlier versions, it was taken as number of significant digits (one less). o E - like %e but uses uppercase letter (e.g. 1.2E+2). o f - the argument is treated as a float, and presented as a floating-point number (locale aware). o F - the argument is treated as a float, and presented as a floating-point number (non-locale aware). Available since PHP 4.3.10 and PHP 5.0.3. o g - shorter of %e and %f. o G - shorter of %E and %f. o o - the argument is treated as an integer, and presented as an octal number. o s - the argument is treated as and presented as a string. o u - the argument is treated as an integer, and presented as an unsigned decimal number. o x - the argument is treated as an integer and presented as a hexadecimal number (with lowercase letters). o X - the argument is treated as an integer and presented as a hexadecimal number (with uppercase letters). Variables will be co-erced to a suitable type for the specifier: Type Handling +--------+---------------------+ | Type | | | | | | | Specifiers | | | | +--------+---------------------+ | | | |string | | | | | | | | | | s | | | | | | | |integer | | | | | | | | | | d, u, c, o, x, X, b | | | | | | | |double | | | | | | | | | | g, G, e, E, f, F | | | | +--------+---------------------+ Warning Attempting to use a combination of the string and width specifiers with character sets that require more than one byte per character may result in unexpected results The format string supports argument numbering/swapping. Here is an example: Example #1 Argument swapping <?php $num = 5; $location = 'tree'; $format = 'There are %d monkeys in the %s'; echo sprintf($format, $num, $location); ?> This will output "There are 5 monkeys in the tree". But imagine we are creating a format string in a separate file, commonly because we would like to internationalize it and we rewrite it as: Example #2 Argument swapping <?php $format = 'The %s contains %d monkeys'; echo sprintf($format, $num, $location); ?> We now have a problem. The order of the placeholders in the format string does not match the order of the arguments in the code. We would like to leave the code as is and simply indicate in the format string which arguments the placeholders refer to. We would write the format string like this instead: Example #3 Argument swapping <?php $format = 'The %2$s contains %1$d monkeys'; echo sprintf($format, $num, $location); ?> An added benefit here is that you can repeat the placeholders without adding more arguments in the code. For example: Example #4 Argument swapping <?php $format = 'The %2$s contains %1$d monkeys. That's a nice %2$s full of %1$d monkeys.'; echo sprintf($format, $num, $location); ?> When using argument swapping, the n$ position specifier must come immediately after the percent sign ( %), before any other speci- fiers, as shown in the example below. Example #5 Specifying padding character <?php echo sprintf("%'.9d ", 123); echo sprintf("%'.09d ", 123); ?> The above example will output: 000000123 Example #6 Position specifier with other specifiers <?php $format = 'The %2$s contains %1$04d monkeys'; echo sprintf($format, $num, $location); ?> The above example will output: The tree contains 0005 monkeys Note Attempting to use a position specifier greater than PHP_INT_MAX will result in sprintf(3) generating warnings. Warning The c type specifier ignores padding and width o $args - o $... - RETURN VALUES
Returns a string produced according to the formatting string $format. EXAMPLES
Example #7 printf(3): various examples <?php $n = 43951789; $u = -43951789; $c = 65; // ASCII 65 is 'A' // notice the double %%, this prints a literal '%' character printf("%%b = '%b' ", $n); // binary representation printf("%%c = '%c' ", $c); // print the ascii character, same as chr() function printf("%%d = '%d' ", $n); // standard integer representation printf("%%e = '%e' ", $n); // scientific notation printf("%%u = '%u' ", $n); // unsigned integer representation of a positive integer printf("%%u = '%u' ", $u); // unsigned integer representation of a negative integer printf("%%f = '%f' ", $n); // floating point representation printf("%%o = '%o' ", $n); // octal representation printf("%%s = '%s' ", $n); // string representation printf("%%x = '%x' ", $n); // hexadecimal representation (lower-case) printf("%%X = '%X' ", $n); // hexadecimal representation (upper-case) printf("%%+d = '%+d' ", $n); // sign specifier on a positive integer printf("%%+d = '%+d' ", $u); // sign specifier on a negative integer ?> The above example will output: %b = '10100111101010011010101101' %c = 'A' %d = '43951789' %e = '4.39518e+7' %u = '43951789' %u = '4251015507' %f = '43951789.000000' %o = '247523255' %s = '43951789' %x = '29ea6ad' %X = '29EA6AD' %+d = '+43951789' %+d = '-43951789' Example #8 printf(3): string specifiers <?php $s = 'monkey'; $t = 'many monkeys'; printf("[%s] ", $s); // standard string output printf("[%10s] ", $s); // right-justification with spaces printf("[%-10s] ", $s); // left-justification with spaces printf("[%010s] ", $s); // zero-padding works on strings too printf("[%'#10s] ", $s); // use the custom padding character '#' printf("[%10.10s] ", $t); // left-justification but with a cutoff of 10 characters ?> The above example will output: [monkey] [ monkey] [monkey ] [0000monkey] [####monkey] [many monke] Example #9 sprintf(3): zero-padded integers <?php $isodate = sprintf("%04d-%02d-%02d", $year, $month, $day); ?> Example #10 sprintf(3): formatting currency <?php $money1 = 68.75; $money2 = 54.35; $money = $money1 + $money2; // echo $money will output "123.1"; $formatted = sprintf("%01.2f", $money); // echo $formatted will output "123.10" ?> Example #11 sprintf(3): scientific notation <?php $number = 362525200; echo sprintf("%.3e", $number); // outputs 3.625e+8 ?> SEE ALSO
printf(3), sscanf(3), fscanf(3), vsprintf(3), number_format(3). PHP Documentation Group SPRINTF(3)
All times are GMT -4. The time now is 06:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy