Sponsored Content
Top Forums Shell Programming and Scripting remove trailing and leading spaces using tr command Post 302293880 by rikxik on Wednesday 4th of March 2009 04:04:27 AM
Old 03-04-2009
Quote:
Originally Posted by steven_TTG
echo "3301|2009-02-01 00:00:00 |K|GGG|TR|2009-02-12 16:30:58 |ad |12" |tr ' ' '|'
3301|2009-02-01|00:00:00||K|GGG|TR|2009-02-12|16:30:58||ad||12
That does not match the desired output - you have put a | between date and time.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Leading and Trailing Spaces

Hi, how to i remove leading and trailing spaces from a line? the spaces can be behind or in front of any field or line example of a line in the input data: Amy Reds , 100 , /bin/sh how to i get it to be: Amy Read,100,/bin/sh i saw something on this on the Man pages for AWK... (7 Replies)
Discussion started by: sleepster
7 Replies

2. Shell Programming and Scripting

Strip leading and trailing spaces only in a shell variable with embedded spaces

I am trying to strip all leading and trailing spaces of a shell variable using either awk or sed or any other utility, however unscuccessful and need your help. echo $SH_VAR | command_line Syntax. The SH_VAR contains embedded spaces which needs to be preserved. I need only for the leading and... (6 Replies)
Discussion started by: jerardfjay
6 Replies

3. UNIX for Dummies Questions & Answers

Removing leading and trailing spaces of data between the tags in xml.

I am having xml document as below. <transactionid> 00 </transactionid> <tracknumber> 0 </tracknumber> <key> N/A </key> But the data contains leading and trailing spaces between the tags. Please let me know how can i remove these leading and trailing spaces between the tags.... (2 Replies)
Discussion started by: jhmr7
2 Replies

4. UNIX for Dummies Questions & Answers

How to remove trailing spaces

Hi, I have a file like this (ADD_MONTHS((Substr(Trim(BOTH FROM Translate(Maximum(closeDa ------------------------------------------------------------ 2007-06-30 00:00:00 I have a requirement where i need just the date. When i do: tail -1... (2 Replies)
Discussion started by: mahek_bedi
2 Replies

5. UNIX for Dummies Questions & Answers

Remove Trailing spaces after a delimiter

Hi, I am trying to remove trailing white spaces using this command in awk nawk -F '|' '/^TR/{t = $4 }/^LN/{gsub(/ */,"");printf "%s|%s\n", t, $0 }' $i>>catman_852_files.txt My delimiter is '|'. THere are some description fields which are being truncated. I dont want to remove spaces... (1 Reply)
Discussion started by: kiran_418
1 Replies

6. Shell Programming and Scripting

Removing leading and trailing spaces only in PERL

Hi All, I have a file with the following contents with multiple lines 172445957| 000005911|8| 400 Peninsula Ave.#1551 | And,K |935172445957|000005911 607573888 |000098536 | 2|Ane, B |J |Ane |1868 |19861206|20090106|20071001 I want to trim the "leading and trailing spaces only" from... (2 Replies)
Discussion started by: kumar04
2 Replies

7. Shell Programming and Scripting

Remove of extra spaces from the trailing

HI, I need the help from the experts like I have created one file with text like: a b c d e f g h i j k l So my question is that i have to write the script in which like in the first sentence it will take only one space after d and remove all the extra space in the end.I dont... (8 Replies)
Discussion started by: bhanudhingra
8 Replies

8. Shell Programming and Scripting

Remove the leading and trailing date from a CSV file

I'm a newbie to shell scripting. Can anyone help with the below requirement ? The leading and trailing date of a files to be removed. 2017-07-12_gmr_tag_log_20170711.csv 2017-07-12_gmr_call_log_20170711.csv 2017-07-12_gmr_outgoing_log_20170711.csv I'm looking for output like... (7 Replies)
Discussion started by: shivamayam
7 Replies

9. Shell Programming and Scripting

Remove leading and trailing spaces from a file

Hi, I am trying to remove leading and trailing spaces from a file using awk but somehow I have not been able to do it. Here is the data that I want to trim. 07/12/2017 15:55:00 |entinfdev |AD ping Time ms | .474| 1.41| .581|green |flat... (9 Replies)
Discussion started by: svajhala
9 Replies

10. Shell Programming and Scripting

How to remove leading and trailing spaces for variable in shell script?

Hi I have variable named tablename. The value to tablename variable has leading and trailing white spaces. How to remove the leading and training white spaces and write the value of the tablename without space to a file using shell script. ( for e.g. tablename= yyy ) INPUT ... (10 Replies)
Discussion started by: pottic
10 Replies
DATETIME.CREATEFROMFORMAT(3)						 1					      DATETIME.CREATEFROMFORMAT(3)

DateTime::createFromFormat - Returns new DateTime object formatted according to the specified format

       Object oriented style

SYNOPSIS
publicstatic DateTime DateTime::createFromFormat (string $format, string $time, [DateTimeZone $timezone]) DESCRIPTION
Procedural style DateTime date_create_from_format (string $format, string $time, [DateTimeZone $timezone]) Returns new DateTime object formatted according to the specified format. PARAMETERS
o $format - The format that the passed in string should be in. See the formatting options below. In most cases, the same letters as for the date(3) can be used. The following characters are recognized in the $format parameter string +--------------------------+--------------------------------------+---+ | $format character | | | | | | | | | Description | | | | | | | | Example parsable values | | | | | | +--------------------------+--------------------------------------+---+ | | | | | Day | | | | | | | | | --- | | | | | | | | --- | | | | | | | | | | | d and j | | | | | | | | | Day of the month, 2 digits with or | | | | without leading zeros | | | | | | | | | | | | 01 to 31 or 1 to 31 | | | | | | | | | | | D and l | | | | | | | | | A textual representation of a day | | | | | | | | | | | | Mon through Sun or Sunday through | | | | Saturday | | | | | | | | | | | S | | | | | | | | | English ordinal suffix for the day | | | | of the month, 2 characters. It's | | | | ignored while processing. | | | | | | | | | | | | st, nd, rd or th. | | | | | | | | | | | z | | | | | | | | | The day of the year (starting from | | | | 0) | | | | | | | | | | | | 0 through 365 | | | | | | | | | | | Month | | | | | | | | | --- | | | | | | | | --- | | | | | | | | | | | F and M | | | | | | | | | A textual representation of a month, | | | | such as January or Sept | | | | | | | | | | | | January through December or Jan | | | | through Dec | | | | | | | | | | | m and n | | | | | | | | | Numeric representation of a month, | | | | with or without leading zeros | | | | | | | | | | | | 01 through 12 or 1 through 12 | | | | | | | | | | | Year | | | | | | | | | --- | | | | | | | | --- | | | | | | | | | | | Y | | | | | | | | | A full numeric representation of a | | | | year, 4 digits | | | | | | | | Examples: 1999 or 2003 | | | | | | | | | | | y | | | | | | | | | A two digit representation of a | | | | year (which is assumed to be in the | | | | range 1970-2069, inclusive) | | | | | | | | Examples: 99 or 03 (which will be | | | | interpreted as 1999 and 2003, | | | | respectively) | | | | | | | | | | | Time | | | | | | | | | --- | | | | | | | | --- | | | | | | | | | | | a and A | | | | | | | | | Ante meridiem and Post meridiem | | | | | | | | | | | | am or pm | | | | | | | | | | | g and h | | | | | | | | | 12-hour format of an hour with or | | | | without leading zero | | | | | | | | | | | | 1 through 12 or 01 through 12 | | | | | | | | | | | G and H | | | | | | | | | 24-hour format of an hour with or | | | | without leading zeros | | | | | | | | | | | | 0 through 23 or 00 through 23 | | | | | | | | | | | i | | | | | | | | | Minutes with leading zeros | | | | | | | | | | | | 00 to 59 | | | | | | | | | | | s | | | | | | | | | Seconds, with leading zeros | | | | | | | | | | | | 00 through 59 | | | | | | | | | | | u | | | | | | | | | Microseconds (up to six digits) | | | | | | | | Example: 45, 654321 | | | | | | | | | | | Timezone | | | | | | | | | --- | | | | | | | | --- | | | | | | | | | | | e, O, P and T | | | | | | | | | Timezone identifier, or difference | | | | to UTC in hours, or difference to | | | | UTC with colon between hours and | | | | minutes, or timezone abbreviation | | | | | | | | Examples: UTC, GMT, Atlantic/Azores | | | | or +0200 or +02:00 or EST, MDT | | | | | | | | | | | Full Date/Time | | | | | | | | | --- | | | | | | | | --- | | | | | | | | | | | U | | | | | | | | | Seconds since the Unix Epoch (Janu- | | | | ary 1 1970 00:00:00 GMT) | | | | | | | | Example: 1292177455 | | | | | | | | | | |Whitespace and Separators | | | | | | | | | --- | | | | | | | | --- | | | | | | | | | | | (space) | | | | | | | | | One space or one tab | | | | | | | | Example: | | | | | | | | | | | # | | | | | | | | | One of the following separation | | | | symbol: ;, :, /, ., ,, -, ( or ) | | | | | | | | Example: / | | | | | | | | | | |;, :, /, ., ,, -, ( or ) | | | | | | | | | The specified character. | | | | | | | | Example: - | | | | | | | | | | | ? | | | | | | | | | A random byte | | | | | | | | Example: ^ (Be aware that for UTF-8 | | | | characters you might need more than | | | | one ?. In this case, using * is | | | | probably what you want instead) | | | | | | | | | | | * | | | | | | | | | Random bytes until the next separa- | | | | tor or digit | | | | | | | | Example: * in Y-*-d with the string | | | | 2009-aWord-08 will match aWord | | | | | | | | | | | ! | | | | | | | | | Resets all fields (year, month, day, | | | | hour, minute, second, fraction and | | | | timzone information) to the Unix | | | | Epoch | | | | | | | | Without !, all fields will be set to | | | | the current date and time. | | | | | | | | | | | | | | | | | | | | | Resets all fields (year, month, day, | | | | hour, minute, second, fraction and | | | | timzone information) to the Unix | | | | Epoch if they have not been parsed | | | | yet | | | | | | | | | | | | Y-m-d| will set the year, month and | | | | day to the information found in the | | | | string to parse, and sets the hour, | | | | minute and second to 0. | | | | | | | | | | | + | | | | | | | | | If this format specifier is present, | | | | trailing data in the string will not | | | | cause an error, but a warning | | | | instead | | | | | | | | Use DateTime::getLastErrors to find | | | | out whether trailing data was | | | | present. | | | | | | +--------------------------+--------------------------------------+---+ Unrecognized characters in the format string will cause the parsing to fail and an error message is appended to the returned struc- ture. You can query error messages with DateTime::getLastErrors. If $format does not contain the character ! then portions of the generated time which are not specified in $format will be set to the current system time. If $format contains the character !, then portions of the generated time not provided in $format, as well as values to the left-hand side of the !, will be set to correspond- ing values from the Unix epoch. The Unix epoch is 1970-01-01 00:00:00 UTC. o $time - String representing the time. o $timezone - A DateTimeZone object representing the desired time zone. If $timezone is omitted and $time contains no timezone, the current timezone will be used. Note The $timezone parameter and the current timezone are ignored when the $time parameter either contains a UNIX timestamp (e.g. 946684800) or specifies a timezone (e.g. 2010-01-28T15:00:00+02:00). RETURN VALUES
Returns a new DateTime instance or FALSE on failure. EXAMPLES
Example #1 DateTime.createFromFormat(3) example Object oriented style <?php $date = DateTime::createFromFormat('j-M-Y', '15-Feb-2009'); echo $date->format('Y-m-d'); ?> Procedural style <?php $date = date_create_from_format('j-M-Y', '15-Feb-2009'); echo date_format($date, 'Y-m-d'); ?> The above examples will output: 2009-02-15 Example #2 Intricacies of DateTime.createFromFormat(3) <?php echo 'Current time: ' . date('Y-m-d H:i:s') . " "; $format = 'Y-m-d'; $date = DateTime::createFromFormat($format, '2009-02-15'); echo "Format: $format; " . $date->format('Y-m-d H:i:s') . " "; $format = 'Y-m-d H:i:s'; $date = DateTime::createFromFormat($format, '2009-02-15 15:16:17'); echo "Format: $format; " . $date->format('Y-m-d H:i:s') . " "; $format = 'Y-m-!d H:i:s'; $date = DateTime::createFromFormat($format, '2009-02-15 15:16:17'); echo "Format: $format; " . $date->format('Y-m-d H:i:s') . " "; $format = '!d'; $date = DateTime::createFromFormat($format, '15'); echo "Format: $format; " . $date->format('Y-m-d H:i:s') . " "; ?> The above example will output something similar to: Current time: 2010-04-23 10:29:35 Format: Y-m-d; 2009-02-15 10:29:35 Format: Y-m-d H:i:s; 2009-02-15 15:16:17 Format: Y-m-!d H:i:s; 1970-01-15 15:16:17 Format: !d; 1970-01-15 00:00:00 SEE ALSO
DateTime.__construct(3), DateTime.getLastErrors(3), checkdate(3), strptime(3). PHP Documentation Group DATETIME.CREATEFROMFORMAT(3)
All times are GMT -4. The time now is 02:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy