Sponsored Content
Top Forums Shell Programming and Scripting Multiple records need to convert UNIXtime to human readable datatime and all output in one format Post 302789763 by manishK on Thursday 4th of April 2013 07:38:11 AM
Old 04-04-2013
Multiple records need to convert UNIXtime to human readable datatime and all output in one format

Hello Experts,

Below is the record i have:
Moderator's Comments:
Mod Comment sample data attached


I want this record of each row to be in single line and there are multiple rowise unixtime mentioned e.g 11996327 , This needs to be converted to Human readdable data and time from multiple rows

Can you help me , it will be big tme help to all Shell Genius Heroes

Last edited by radoulov; 04-04-2013 at 10:12 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

formatting output in human readable numbers

Hi, The following command provides the usage in 1024-byte blocks du -ks * | sort -n | echo "$1" ... 1588820 user10 2463140 user11 2464096 user12 5808484 user13 6387400 user14 ..... I am trying to produce an output of first coulmn by multiplying by 1024 so that the output should... (11 Replies)
Discussion started by: ghazi
11 Replies

2. UNIX for Dummies Questions & Answers

To convert multi format file to a readable ascii format

Hi I have a file which has ascii , binary, binary decimal coded,decimal & hexadecimal data with lot of special characters (like öƒ.ƒ.„İİ¡Š·œƒ.„İİ¡Š· ) in it. I want to standardize the file into ASCII format & later use that as source . Can any one suggest a way a logic to convert such... (5 Replies)
Discussion started by: gaur.deepti
5 Replies

3. Shell Programming and Scripting

script to convert epoch into human-readable

This is what I have to start out with more file 1208217600 1208131200 1193806800 I want to convert the epoch column into a human-readable format. My file has hundreds of these epoch times that I want to loop through and convert. (The epoch time is really the last column of the line) ... (3 Replies)
Discussion started by: snoman1
3 Replies

4. Shell Programming and Scripting

convert unix date to readable format

Dear Experts, I need your help to convert a unix date and time format number in to readable format like dd/mm/yyyy . I have a text file of more than 10,000 records and it is like NAME DATE1 COUNTRY DATE2 ABD 1223580395699 USA 1223580395699... (3 Replies)
Discussion started by: shary
3 Replies

5. UNIX for Dummies Questions & Answers

How to make user's qutoa in human readable format?

$ quota Disk quotas for user cqlouis (uid 1254): Filesystem blocks quota limit grace files quota limit grace /dev/sdb1 64 300000 320000 8 0 0 $ I want to make the output of command quota in human readable format? How to? As we... (2 Replies)
Discussion started by: cqlouis
2 Replies

6. Shell Programming and Scripting

convert timezone into human output

Hi I have a command which returns a timezone, Ej: root@bsades2: /usr/local/bin # lsuser -a time_last_login israel israel time_last_login=1279032223 Question: I want to parse this timezone '1279032223' into a 'martes, 13 de julio de 2010 16:43:43' from the ksh shell. Is itt possible? ... (3 Replies)
Discussion started by: iga3725
3 Replies

7. Shell Programming and Scripting

Convert epoch to human readable date & time format

Hello I have log file from solaris system which has date field converted by Java application using System.currentTimeMillis() function, example is 1280943608380 which equivalent to GMT: Wed, 04 Aug 2010 17:40:08 GMT. Now I need a function in shell script which will convert 1280943608380... (3 Replies)
Discussion started by: Yaminib
3 Replies

8. UNIX for Dummies Questions & Answers

Display Directories with their sizes in human readable format

Hi, I want to list all the directories present in a particular location and want to display their sizes as well. I know "ls -lh" but it doesn't show the size of the complete directory. So i want something like dir1 266 MB dir2 2 KB dir3 22 MB ... ... file1 10 Kb ..... Thanks Sarbjit (4 Replies)
Discussion started by: sarbjit
4 Replies

9. Shell Programming and Scripting

Convert epoch time stamp into human readable format

Can someone help me to write a shell script to convert epoch timestamp into human readable format 1394553600,"test","79799776.0","19073982.728571","77547576.0","18835699.285714" 1394553600,"test1","80156064.0","19191275.014286","62475360.000000","14200554.720000"... (10 Replies)
Discussion started by: Moon1234
10 Replies

10. Programming

How to parse .nessus file to get result in human readable format?

Scripting Language: bash shell script, python I want to parse .nessus file in human readable format. If any one have any ideas please help me. (2 Replies)
Discussion started by: sk151993
2 Replies
BIO(1)                                                        General Commands Manual                                                       BIO(1)

NAME
bio - Barry Input / Output SYNOPSIS
bio -i <input type> [input args] -o <output type> [output args] [-o <output type> ...] DESCRIPTION
bio is a command line tool that treats devices, backups, and data streams as input and output. bio supports the following types of IO (actual type name shown in bold): device tar (backup files) boost (serialization files and streams) mime streams ldif streams human readable and hex text dump sha1 sum output cstore for extracting Content Store records Each command line consists of at least one input and output option, along with their switches. More than one output can be used, as long as they do not conflict with each other. For example, it is not possible to read and write from the same device PIN. This tool combines a lot of the functionality of btool, btardump, brecsum, and bs11nread, but does it more flexibly, and improves function- ality in some cases, such as Boost archives being able to contain more than one database. DEVICE TYPE OPTIONS
The device type is used to read or write from a device connected via USB. Some of the options below are valid only in one input or output mode, some in both. -d db Name of database to load, when using the device type as input. Can be used multiple times. See btool -t for a list of databases on the device. -A Selects all databases found on the device, instead of adding them manually via the -d option. -p pin PIN of device to talk to. Valid for both input and output. Only needed if you have more than one Blackberry connected at once. -P password Simplistic method to specify device password. In a real application, this would be done using a more secure prompt. -w mode Set write mode when using the device type in output mode. This must be specified, or nothing will be written. Can be one of: erase, overwrite, addonly, addnew. erase Erases all records from existing database and adds all new records to the device, using their Unique IDs, if available. This is what you would normally use to restore a backup. overwrite Adds any new records, and for records with Unique IDs that already exist on the device, overwrite them. addonly Adds any new records, but if a record exists in the device with the same Unique ID, skip that record and don't write it to the device. addnew Adds all incoming records as brand new records, generating a new Unique ID for each one, and leaving any existing records intact. This may cause data duplication if you're restoring data that initially came from this same device. Use this for copying data from another device, while keeping your existing records. TAR TYPE OPTIONS
The tar type is used to read or write from a backup file created by btool or the backup GUI. -d db Name of database to load, when using the tar type as input. Can be used multiple times. Note that if no -d options are specified, bio defaults to reading all available databases. -f file The tar backup file to read or write from. Bio uses gzip compressed tar files, so suitable extensions would be .tgz and .tar.gz. Unfortunately, due to internal limitations, an actual file must be specified here, and not - for stdin / stdout. BOOST TYPE OPTIONS
The boost type is used to read and write parsable records in Boost Serialization format. These files were historically written and read by btool and bs11nread. Bio is more flexible, in that it can contain multiple databases in one serialization archive. -f file Filename to read from or write to. Use - to specify stdin or stdout. If not specified for input, defaults to stdin, but since out- put can contain non-ASCII chars, you must use -f - if you want to write to stdout. LDIF TYPE OPTIONS
The ldif type is used to read or write ldif output, like the output of the LDAP command line tool ldapsearch. -c dn When using ldif as output, specify the base DN. -C dnattr Again, for output, specify the attribute name to use when building the FQDN. MIME TYPE OPTIONS
The mime type is used to read or write VCARD, VEVENT, VTODO, or VJOURNAL records based on the Address Book, Calendar, Tasks, or Memos data- bases respectively. -f file Filename to read from or write to. Defaults to - for stdin or stdout. DUMP TYPE OPTIONS
The dump type is used only for output, and sends human readable record data to stdout. Parsable records are parsed; unknown records are dumped in hex format. -n Use hex format for all records. SHA1 TYPE OPTIONS The sha1 type is used to mimic the behaviour of the brecsum command. It calculates a SHA1 sum on the raw record data and sends the sum to stdout. -t Include the DB Name, Type, and Unique record ID in the checksum for each record. CSTORE TYPE OPTIONS
The cstore type is used to parse Content Store records. -l List the filenames and folders found in the Content Store database. -f file Select a filename from the above list to extract and save locally. Specify the entire path as shown in the -l list. If the file is found in the device, it will be written to the current directory, using the base filename as the name. If a file by that name exists already, the filename will be modified to avoid overwriting local files. STANDALONE OPTIONS
-h Displays a detailed summary of command line options. -I cs Set the international charset for string conversions. Valid values here are available with iconv --list -S Show list of supported database parsers and builders. -v Dump verbose low level protocol data during USB operations, to stdout. EXAMPLES
1) Backup a full device to tar backup: bio -i device -A -o tar -f mybackup.tar.gz 2) Read a backup file and convert the Address Book to MIME bio -i tar -f mybackup.tar.gz -d "Address Book" -o mime 3) Restore a single database to a device bio -i tar -f mybackup.tar.gz -d "Address Book" -o device -w erase 4) Copy the Calendar from one device to another, and dump the records to stdout in human readable format at the same time bio -i device -p 3009efe3 -d Calendar -o device -p 204062f3 -w erase -o dump 5) Read LDIF input and convert the contacts to MIME format ldapsearch -x | bio -i ldif -o mime 6) Test the record code by running the Tasks database through the Boost storage and back to human readable bio -i device -d Tasks -o dump vs. bio -i device -d Tasks -o boost -f - | bio -i boost -f - -o dump AUTHOR
bio is part of the Barry project. SEE ALSO
http://www.netdirect.ca/barry May 17, 2011 BIO(1)
All times are GMT -4. The time now is 12:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy