Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help me with file conversion [Shell Script]
Top Forums Shell Programming and Scripting Help me with file conversion [Shell Script] Post 302356437 by csierra on Friday 25th of September 2009 01:31:11 PM
Old 09-25-2009
Help me with file conversion [Shell Script]
Hello Group,

I request your help with a shell script for filter an ascii file (this is small piece of the file):

Code:
09/24/2009,00:00,1.0268,1.0268,1.0249,1.0250,518
09/24/2009,01:00,1.0251,1.0261,1.0249,1.0259,424
09/24/2009,02:00,1.0258,1.0272,1.0258,1.0269,372
09/24/2009,03:00,1.0270,1.0276,1.0266,1.0270,389
09/24/2009,04:00,1.0269,1.0277,1.0267,1.0268,488
09/24/2009,05:00,1.0267,1.0275,1.0262,1.0269,575
09/24/2009,06:00,1.0270,1.0271,1.0248,1.0248,670
09/24/2009,07:00,1.0249,1.0254,1.0238,1.0238,1314
09/24/2009,08:00,1.0239,1.0259,1.0238,1.0240,1111
09/24/2009,09:00,1.0241,1.0245,1.0219,1.0220,1291
09/24/2009,10:00,1.0221,1.0242,1.0207,1.0236,1389
09/24/2009,11:00,1.0237,1.0241,1.0221,1.0221,1049
09/24/2009,12:00,1.0220,1.0235,1.0210,1.0216,1189
09/24/2009,13:00,1.0215,1.0249,1.0211,1.0237,1125
09/24/2009,14:00,1.0239,1.0290,1.0238,1.0268,1837
09/24/2009,15:00,1.0269,1.0292,1.0264,1.0278,1290
09/24/2009,16:00,1.0277,1.0282,1.0262,1.0273,874
09/24/2009,17:00,1.0272,1.0322,1.0268,1.0319,1080
09/24/2009,18:00,1.0318,1.0320,1.0299,1.0300,674
09/24/2009,19:00,1.0301,1.0305,1.0291,1.0298,636
09/24/2009,20:00,1.0299,1.0304,1.0292,1.0293,220
09/24/2009,21:00,1.0295,1.0298,1.0282,1.0293,332
09/24/2009,22:00,1.0292,1.0299,1.0291,1.0298,183
09/24/2009,23:00,1.0297,1.0315,1.0290,1.0296,543
09/25/2009,00:00,1.0295,1.0319,1.0290,1.0310,669

The second field above correspond to the hour and I need only the hours between 12:00 and 22:00 and discard the others rows.

I have Ubuntu in my computer

I really appreciate it your help

Sincerely,

Carlos
USD_CHF-1H.rar (31.6 KB) 
Last edited by vgersh99; 09-25-2009 at 02:49 PM.. Reason: code tags, PLEASE!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script conversion to binary

My question is: i have a script called getevent to run i just call ./getevent can i convert this to make it binary executable and not letting my clients open it and see the code.??:( I am using Solaris 8. (3 Replies)
Discussion started by: bcheaib
3 Replies

2. AIX

Need timestamp conversion shell script !!

Can anyone provide me with a ksh or bash script which will accept a timestamp (format is YYYY-MM-DD-HH24.Mi.Ss) and time offset (in hours). The output will be (timestamp passed - time offset passed deducted from it) in the same YYYY-MM-DD-HH24.Mi.Ss format. Basically I am trying to convert the... (1 Reply)
Discussion started by: shibajighosh
1 Replies

3. Shell Programming and Scripting

Shell script for CSV conversion

thanks for allowing me join your forum i have an output of linux command "who" which provides following details..... CURRENT USER/ACCT INFO 17:31:36 up 4:49, 4 users, load average: 0.03, 0.04, 0.00 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT root :0 - 12:59 ?xdm? 4:54 0.02s /bin/sh /usr/bi... (1 Reply)
Discussion started by: ayyappancheta
1 Replies

4. Shell Programming and Scripting

shell or perl script needed for ldif file to text file conversion

This is the ldf file dn: sdcsmsisdn=1000000049,sdcsDatabase=subscriberCache,dc=example,dc=com objectClass: sdcsSubscriber objectClass: top postalCode: 29600 sdcsServiceLevel: 10 sdcsCustomerType: 14 givenName: Adelia sdcsBlackListAll: FALSE sdcsOwnerType: T-Mobile sn: Actionteam... (1 Reply)
Discussion started by: LinuxFriend
1 Replies

5. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies

6. Shell Programming and Scripting

Shell Script for Epoch Time Conversion

Hi there I came across this script online to convert Epoch time to proper date format, but I am receiving the following error Also, I have HISTTIMEFORMAT set in user's .profile so that their history output shows time stamps. Additionally I have changed their .history location to a dedicated... (9 Replies)
Discussion started by: hedkandi
9 Replies

7. Shell Programming and Scripting

Conversion batch shell script

while converting batch file to shell script ...dis command is ther i dunno how to change...can anyone knws how to change into shell script rm !(D:\temp\XX.txt) (3 Replies)
Discussion started by: monisha
3 Replies

8. Shell Programming and Scripting

Batch to shell script conversion

Hi All, I have a small tool which is currently configured in batch scripts only. But my need is to run it on Linux platform, so I have been trying to convert a batch script to shell script. below is the batch script: @echo off IF "%1"== "" GOTO ARGERR REM UPDATE THESE PROPERTIES TO... (2 Replies)
Discussion started by: sukhdip
2 Replies

9. UNIX for Beginners Questions & Answers

powershell script to unix shell script conversion.

Here is a powershell script to use restful API to create ticket in our ticketing tool. Can anyone please convert it to a shell script sothat, I can run it in Unix servers, below is the code: $body = @{ Customer= ''test' Summary= 'test summary' Impact= '4-Minor/Localized' ... (2 Replies)
Discussion started by: pandeybhavesh18
2 Replies

10. UNIX for Beginners Questions & Answers

Shell script ouput conversion

Hi All, I am trying to print all the packages info in solaris 11 using below script. #!/usr/bin/env bash pkginfo -l | egrep '(BASEDIR|NAME|VERSION)' | awk '{print}' > /tmp/cp1 /usr/bin/nawk -F: ' {for (i=1; i<=NF; i++) {gsub (/^ *| *$/, "", $i) ... (5 Replies)
Discussion started by: sravani25
5 Replies
All times are GMT -4. The time now is 06:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy