Sponsored Content
Top Forums Shell Programming and Scripting FILE_ID extraction from file name and save it in CSV file after looping through each folders Post 302700693 by princetd001 on Friday 14th of September 2012 02:44:14 AM
Old 09-14-2012
script
Code:
#!/usr/bin/env ksh
OUTFILE=test.txt
find 20[0-1][0-9] -type f | while read path
 do
   name=${path##*/}
   name=${name%.trns*}   
   id=${name%_*}
   id=${id##*_}
   id=${id##*000}
   echo "id: $id"
   echo "file name: $name"
  done  > ${OUTFILE}
exit


MY SCRIPT RESULT
Code:
id: 20532
file name: sasmm_fsbc_durds_id00020532_t20120112192606.dat
id: 20533
file name: sasmm_fsbc_durds_id00020533_t20120212192606.dat
id: 20534
file name: sasmm_fsbc_durds_id00020534_t20120312192606.dat


Last edited by Corona688; 09-14-2012 at 01:00 PM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to start looping from the second line in .csv file

I have a .csv file and i use the below while loop to navigate through it But i need to loop from the second line since the first line is the header How will i do it?? please help while IFS=, read Filename Path size readonly do echo "Filename -> ${Filename}" echo "Path -> ${Path}" echo... (8 Replies)
Discussion started by: codeman007
8 Replies

2. Shell Programming and Scripting

Data fetched from text file and save in a csv file

Hi i have wriiten a script which fetches the data from text file, and saves in the output in a text file itself, but i want that the output should save in different columns. I have the output like: For Channel:response_time__24.txt 1547 data points 0.339 0.299 0.448 0.581 7.380 ... (1 Reply)
Discussion started by: rohitkalia
1 Replies

3. Shell Programming and Scripting

select data from oracle table and save the output as csv file

Hi I need to execute a select statement in a solaris environment with oracle database. The select statement returns number of rows of data. I need the data to be inserted into a CSV file with proper format. For that we normally use "You have to select all your columns as one big string,... (2 Replies)
Discussion started by: rdhanek
2 Replies

4. UNIX for Dummies Questions & Answers

CSV file:Find duplicates, save original and duplicate records in a new file

Hi Unix gurus, Maybe it is too much to ask for but please take a moment and help me out. A very humble request to you gurus. I'm new to Unix and I have started learning Unix. I have this project which is way to advanced for me. File format: CSV file File has four columns with no header... (8 Replies)
Discussion started by: arvindosu
8 Replies

5. Shell Programming and Scripting

need to save the space when converting to CSV file

Hi, I have a text file with the following format. Some of the fields are blank. 1234 3456 23 45464 327837283232 343434 5654353 34 34343 3434345 434242 .... .... .... I need to convert this file to a CSV file, like 1234, ,23, ... (3 Replies)
Discussion started by: wintersnow2011
3 Replies

6. Shell Programming and Scripting

CSV file data extraction

Hi I am writing a shell script to parse a CSV file , in which i am facing a problem to separate the columns . Could some one help me with it. IN301330/00001 pvavan kumar limited xyz@ttccpp.com IN302148/00002 PRECIOUS SECURITIES (P) LTD viash@yahoo.co.in IN300239/00000 CENTRE india... (8 Replies)
Discussion started by: nanduri
8 Replies

7. Shell Programming and Scripting

Save output of updated csv file as csv file itself

Hi, all I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file. test.csv SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21 /home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies

8. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies

9. UNIX for Beginners Questions & Answers

Data extraction and converting into .csv file.

Hi All, I have a data file and need to extract and convert it into csv format: 1) Read and extract the line containing string ending with "----" (file sample_linebyline.txt file) and to make a .csv file from this. 2) To read the flat file flatfile_sample.txt which consists of similar data (... (9 Replies)
Discussion started by: abhi_123
9 Replies
geoip(3)							    Version 0.2 							  geoip(3)

NAME
geoip - A Tcl extension for geographic or organisational lookup of IP addresses and hostnames. SYNOPSIS
geoip open [-type TYPE ] [-flags FLAG ] geoip open [-file PATH ] [-flags FLAG ] geoip [COMMAND] geoip [QUERY] arg1 DESCRIPTION
This Tcl extension encapsulates most of GeoIP C API functions into tcl commands. OPEN OPTIONS
open takes either a file path and a set of flags, or a type and a set of flags. Supported types and flags are described below. TYPE Looks under the standard installation share directory, eg /usr/local/share/GeoIP/ for a GeoIP database according to type. PATH Absolute/relative path to GeoIP database. FLAG Flags seperated by ':', eg memory_cache:memory_check COMMAND
Individual singular commands can be one of: close Close the currently open database. db_info Get information about the current database. db_edition Returns edition of opened database. db_avail Test the availability of databases in your system in known locations. e.g db_avail country_edition QUERY
Commands that query the database. All commands return N/A if a result cannot be found. If none already open, a command will attempt to open a suitable database. country commands will open a country_edition database. region commands will open a region_edition_rev1 one. name com- mands will open an org_edition one, and the record_edition will open a city_edition_rev1 database. The commands are: country_code_by_addr Takes an IP address and returns the ISO-3166-1 Alpha-2 code of the country. country_code3_by_addr Takes an IP address and returns the ISO-3166-1 Alpha-3 code the country. country_code_by_name Takes a hostname and returns the ISO-3166-1 Alpha-2 code the country. country_code3_by_name Takes a hostname and returns the ISO-3166-1 Alpha-3 code the country. country_name_by_addr Takes an IP address and returns the country name. country_name_by_name Takes a hostname and returns the country name. name_by_addr Takes an IP address and returns the organisation name (or ISP/ASnum according to the opened database) name_by_name Takes a hostname and returns the organisation name. region_by_addr Takes an IP address and returns these region attributes as in an associative array: country, region region_by_name Takes a hostname and returns the region attributes. record_by_addr Takes an IP address and returns these record attributes as in an associative array: code, code3, region, country, city, postcode, latitude, longitude, dma(dma code), and area (area code) record_by_name Takes a hostname and returns the record attributes. TYPES
Relevant types of databases are: country_edition, org_edition, isp_edition, city_edition_rev1, region_edition_rev1, geoip_asnum_edition. "open -type" will accept their unambiguous abbreviations. FLAGS
Valid flags are: standard, memory_cache, check_cache, index_cache. FILES
./share/GeoIP.dat GeoIP country_edition database. ./share/GeoIPOrg.dat GeoIP org_edition database. ./share/GeoIPCity.dat GeoIP region_city_rev1 database. ./share/GeoIPRegion.dat GeoIP region_edition_rev1 database. ./share/GeoIPASNum.dat GeoIP asnum_edition database. BUGS
Please report to author. AUTHOR
Djihed Afifi <djihed@gmail.com>. SEE ALSO
GeoIP C API documentation <www.maxmind.com> Tcl extension April 2007 geoip(3)
All times are GMT -4. The time now is 07:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy