Sponsored Content
Full Discussion: Format a log file using sed
Top Forums Shell Programming and Scripting Format a log file using sed Post 302698675 by Tuxidow on Monday 10th of September 2012 11:30:46 AM
Old 09-10-2012
awesome... I was looking for an answer and got 4 different working answers.. This is super cool.. Thank you all. Smilie

---------- Post updated at 07:30 AM ---------- Previous update was at 07:00 AM ----------

Code:
10.28.76.15 2Fflights-search-error.html%26successURL%3D%2Ftravel%2Fflights%2Ftransport-results.html%26intcmp%3Dhome1_flights%26DPAIR%3DNONE%26isEurostarSearch%3DFalse%26DPODT%3D0001%26DPNOS%3D0%26DPIDT%3D0001%26DPDAP%3DLON%26DPAAP%3DYTO%26DPNOA%3D1%26DPNOC%3D0%26DPNOI%3D0%26date_out_day%3D25%26date_out_month%3D12%26date_in_day%3D28%26date_in_month%3D12%26DPCLS%3DY%26DPTTT%3DR%26DP1WF%3D0&source=aff-td1377904&tduid=bb69e501d40cf8b5dbd3a3a2a398d4f8SSLC=Z42" www.crazynet.com "GET /site/transportationScripts.js?skin=enhk.muttusoochi.com.hk HTTP/1.1" 200 10351
 8245 "71.19.175.130, 10.28.76.15"

How can I extract if the sample is like the above?
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to number format a data file without using SED?

Hi I have a file which contains data (list of data) and I want to put a number with bracket 1) 2) 3) etc at the beginning of every successive line I can do it with SED and I can also do it using the nl route but am looking for a different method. I'm guessing I would need some sort of loop... (3 Replies)
Discussion started by: Cactus Jack
3 Replies

2. UNIX for Advanced & Expert Users

Sed to format data in a file

Hi , i need help with formatting a file i am generating which is to be used in mainframe app so the file length has to be 80 for each rows. The file that m able to generate looks like this (consists of two rows only) E 1006756 1006756 Active T E 0551055 0551055 Active T I... (2 Replies)
Discussion started by: cnilashis
2 Replies

3. Shell Programming and Scripting

convert date format to mysql date format in log file

I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column. I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this? Sample input 02/27/09,23:52:31 02/27/09,23:52:52... (3 Replies)
Discussion started by: hazno
3 Replies

4. Shell Programming and Scripting

SED - log file format

Hello everyone, I have a log file : \data\file\script\command_0001 \data\file\script\command_0002 \data\file\script\command_0003 I need to make all lines on this way \data\file\script\command_0001 \data\file\script\command_0002 \data\file\script\command_0003 I know this could be done... (11 Replies)
Discussion started by: Aswex
11 Replies

5. Shell Programming and Scripting

awk or sed to format text file

hi all, i have a text file which looks like the below 01 02 abc Top 40 music Kidz Only! MC 851 MC 852 MC 853 7NOW Arch_Diac xyz2 abc h211 Commacc1 Commacc2 Commacc3 (4 Replies)
Discussion started by: posner
4 Replies

6. Shell Programming and Scripting

Log File - Format

Dear all, I need help to format a log file : Here is the output (Go to the end of the Wrap Code to see caracter at the end of line): FILE='/OPERATIONNEL/SATURNE/PHYS_MOD/NOWMOD/SATURNE_1DAV_20110201_20110202_ICEMOD_R20110202.NC ... (5 Replies)
Discussion started by: Aswex
5 Replies

7. Shell Programming and Scripting

Format log file - SED

Hello, I need help to format a log file...again ; )) Here is what I have : FILE='/OPERATIONNEL/SATURNE/MASTER/SATURNE_MASTER_PRE_R20110119.TAR.GZ ... (5 Replies)
Discussion started by: Aswex
5 Replies

8. Shell Programming and Scripting

Need awk/sed to format a file

My content of source file is as below scr1 a1 scr2 a2 b2 scr3 a3 b3 c3 I need a awk/sed command (to be used in C shell)to format it to something like below scr1 $a1 >file1 scr2 $a2 $b2 >file2 scr3 $a3 $b3 $c3 >file3 (12 Replies)
Discussion started by: animesharma
12 Replies

9. Shell Programming and Scripting

Help on Log File format using sed or awk

Hello Gurus, First, i would like to know is there any way to solve my problem. i have a log file like this: INFO - ABCDRequest :: processing started for the record <0> TransactionNo <Txn#1> recordID <recID#1> INFO - ABCDRequest :: processing started for the record <0> TransactionNo... (9 Replies)
Discussion started by: VasuKukkapalli
9 Replies

10. Shell Programming and Scripting

Datestamp format 2nd change in csv file (awk or sed)

I have a csv file formatted like this: 2014-08-21 18:06:26,A,B,12345,123,C,1232,26/08/14 18:07and I'm trying to change it to MM/DD/YYYY HH:MM for both occurances. I have got this: awk -F, 'NR <=1 {print;next}{"date +%d/%m/%Y\" \"%H:%m -d\""$1 "\""| getline dte;$1=dte}1' OFS="," test.csvThis... (6 Replies)
Discussion started by: say170
6 Replies
iconv_646(5)						Standards, Environments, and Macros					      iconv_646(5)

NAME
iconv_646 - code set conversion tables for ISO 646 DESCRIPTION
The following code set conversions are supported: +-----------------------------------------------------------------------+ | Code Set Conversions Supported | +----------+---------------+--------------+--------+--------------------+ | Code | Symbol |Target Code |Symbol | Target Output | +----------+---------------+--------------+--------+--------------------+ |ISO 646 | 646 |ISO 8859-1 |8859 |US ASCII | +----------+---------------+--------------+--------+--------------------+ |ISO 646de | 646de |ISO 8859-1 |8859 |German | +----------+---------------+--------------+--------+--------------------+ |ISO 646da | 646da |ISO 8859-1 |8859 |Danish | +----------+---------------+--------------+--------+--------------------+ |ISO 646en | 646en |ISO 8859-1 |8859 |English ASCII | +----------+---------------+--------------+--------+--------------------+ |ISO 646es | 646es |ISO 8859-1 |8859 |Spanish | +----------+---------------+--------------+--------+--------------------+ |ISO 646fr | 646fr |ISO 8859-1 |8859 |French | +----------+---------------+--------------+--------+--------------------+ |ISO 646it | 646it |ISO 8859-1 |8859 |Italian | +----------+---------------+--------------+--------+--------------------+ |ISO 646sv | 646sv |ISO 8859-1 |8859 |Swedish | +----------+---------------+--------------+--------+--------------------+ CONVERSIONS
The conversions are performed according to the following tables. All values in the tables are given in octal. ISO 646 (US ASCII) to ISO 8859-1 For the conversion of ISO 646 to ISO 8859-1, all characters in ISO 646 can be mapped unchanged to ISO 8859-1 ISO 646de (GERMAN) to ISO 8859-1 For the conversion of ISO 646de to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646de | ISO 8859-1 | ISO 646de | ISO 8859-1 | |100 | 247 |173 |344 | |133 | 304 |174 |366 | |134 | 326 |175 |374 | |135 | 334 |176 |337 | +---------------+----------------+----------------+---------------+ ISO 646da (DANISH) to ISO 8859-1 For the conversion of ISO 646da to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646da | ISO 8859-1 | ISO 646da | ISO 8859-1 | |133 | 306 |173 |346 | |134 | 330 |174 |370 | |135 | 305 |175 |345 | +---------------+----------------+----------------+---------------+ ISO 646en (ENGLISH ASCII) to ISO 8859-1 For the conversion of ISO 646en to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------+ | Conversions|Performed | | ISO 646en | ISO 8859-1 | |043 |243 | +-----------------------------+-----------------------------+ ISO 646es (SPANISH) to ISO 8859-1 For the conversion of ISO 646es to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646es | ISO 8859-1 | ISO 646es | ISO 8859-1 | |100 | 247 |173 |260 | |133 | 241 |174 |361 | |134 | 321 |175 |347 | |135 | 277 | | | +---------------+----------------+----------------+---------------+ ISO 646fr (FRENCH) to ISO 8859-1 For the conversion of ISO 646fr to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646fr | ISO 8859-1 | ISO 646fr | ISO 8859-1 | |043 | 243 |173 |351 | |100 | 340 |174 |371 | |133 | 260 |175 |350 | |134 | 347 |176 |250 | |135 | 247 | | | +---------------+----------------+----------------+---------------+ ISO 646it (ITALIAN) to ISO 8859-1 For the conversion of ISO 646it to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646it | ISO 8859-1 | ISO 646it | ISO 8859-1 | |043 | 243 |140 |371 | |100 | 247 |173 |340 | |133 | 260 |174 |362 | |134 | 347 |175 |350 | |135 | 351 |176 |354 | +---------------+----------------+----------------+---------------+ ISO 646sv (SWEDISH) to ISO 8859-1 For the conversion of ISO 646sv to ISO 8859-1, all characters not in the following table are mapped unchanged. +-----------------------------------------------------------------+ | | Conversions|Performed | | | ISO 646sv | ISO 8859-1 | ISO 646sv | ISO 8859-1 | |100 | 311 |140 |351 | |133 | 304 |173 |344 | |134 | 326 |174 |366 | |135 | 305 |175 |345 | |136 | 334 |176 |374 | +---------------+----------------+----------------+---------------+ FILES
/usr/lib/iconv/*.so conversion modules /usr/lib/iconv/*.t conversion tables /usr/lib/iconv/iconv_data list of conversions supported by conversion tables SEE ALSO
iconv(1), iconv(3C), iconv(5) SunOS 5.10 28 Apr 1997 iconv_646(5)
All times are GMT -4. The time now is 03:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy