Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: remove first few characters from each line
Top Forums Shell Programming and Scripting remove first few characters from each line Post 302636133 by ratheeshjulk on Monday 7th of May 2012 05:22:13 AM
Old 05-07-2012
remove first few characters from each line
Hi,

I have a file with lines like below.
I need to remove first few characters from each line until a date format is found.

Code:
05/06/12 20:47:02 GUMGUY@98.192.174.74{42B42A72AC955F5926621273E3A15059.tomcat2}TP-Processor15 LogExchUsage: ERROR:
05/06/12 20:47:02 GUMGUY@98.192.174.74{42B42A72AC955F5926621273E3A15059.tomcat2}TP-Processor15 LogExchUsage: ERROR:
51129.77605/02/12 11:44:32 NEARRIDGIDAGHLAR@98.251.109.147{E889D36D2B2082668147CB1E0A47A91B.tomcat1}TP-Processor26 LogExchUsage:
18797.45204/13/12 06:55:40 BYE67BYE@96.254.176.116{3FC897AF82897CF3683FE06D6A21997E.tomcat8}TP-Processor18 LogExchUsage: ERROR:
Request for getNextPage.................04/26/12 06:44:20 BAOBEIBUNNY@96.242.252.247{2E29DD4B985715A69EA18021E6EB088B.tomcat4}TP-Processor29 LogExchUsage:

I need to remove first few characters from each line until a date format is found.
out put should be like this.

Code:
05/06/12 20:47:02 GUMGUY@98.192.174.74{42B42A72AC955F5926621273E3A15059.tomcat2}TP-Processor15 LogExchUsage: ERROR: 
05/06/12 20:47:02 GUMGUY@98.192.174.74{42B42A72AC955F5926621273E3A15059.tomcat2}TP-Processor15 LogExchUsage: ERROR:
05/02/12 11:44:32 NEARRIDGIDAGHLAR@98.251.109.147{E889D36D2B2082668147CB1E0A47A91B.tomcat1}TP-Processor26 LogExchUsage:
04/13/12 06:55:40 BYE67BYE@96.254.176.116{3FC897AF82897CF3683FE06D6A21997E.tomcat8}TP-Processor18 LogExchUsage: ERROR:
04/26/12 06:44:20 BAOBEIBUNNY@96.242.252.247{2E29DD4B985715A69EA18021E6EB088B.tomcat4}TP-Processor29 LogExchUsage:

Any clue...
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to remove line greater then 3000 characters.

I am using awk and it stops when it encounter line greater then 3000 character. Is there any command which will help me remove line greater then 3000 characters. (10 Replies)
Discussion started by: naren_14
10 Replies

2. Shell Programming and Scripting

sed remove last 10 characters of a line start from 3rd line

hello experts, I need a sed command that remove last 10 characters of a line start from 3rd line. any suggestions? Thanks you (7 Replies)
Discussion started by: minifish
7 Replies

3. UNIX for Dummies Questions & Answers

remove characters from line

Hello, I have multiple lines in a file, each of which will have data that looks like this: xxxxxyyyyzzzz4abcdXYZXYZXYZ pqrstPQRST2cdPQRSTPQRST lmnopqr6abcdefgRST.3abc I want to be able to remove the number 4 + the following 4 characters (abcd) in the first line. For the second line,... (1 Reply)
Discussion started by: Gussifinknottle
1 Replies

4. Shell Programming and Scripting

How to remove special characters from each line?

Hello, Is there a simpler way to remove special characters (color codes) from each lines in a log file? I use sed like in the example below but I think there should be a more simple way to achieve the same result: $ cat -vet file1 ^, , , , Maybe to convert the file somehow? ... (5 Replies)
Discussion started by: majormark
5 Replies

5. UNIX for Advanced & Expert Users

Remove new line characters if found between 1 to 10 columns

Hi, I have a file with ';' delimeter which has some new line characters. How can I delete the new line characters if they are found between 1 to 10 fields. Thanks (3 Replies)
Discussion started by: rudoraj
3 Replies

6. UNIX Desktop Questions & Answers

Remove new line characters from a file

I tried using below command tr -cd "" < InputFile.xml > output.txt ============= This removes all the tabs/newline/extra spaces from a file it successfully removed all the extra spaces,tabs and new line characters but then the complete file become one record. I want to retain one new line... (1 Reply)
Discussion started by: saini
1 Replies

7. Shell Programming and Scripting

Remove characters from line

I have a the following line 22.152.25.36 - K##### "GET /DGGKE/GetMail.do;jwebsphere=FADFFFGSFGSFGSDGFSDFGSDFGSDF HTTP/1.1" 200 44948 Need a cut command which should give me the below output 22.152.25.36 - K##### "GET /DGGKE/GetMail.do HTTP/1.1" 200 44948 Note: The value of jwebsphere can... (6 Replies)
Discussion started by: suindar1982
6 Replies

8. Shell Programming and Scripting

I want to remove 1st and last two characters of each line of the file

I want to remove 1st and last two characters of each line of the file Ex: file1 zzfile1ee @xfile2:y qfile3>> @ file4yy and redirect to the file called new Basically file will have any charcter including space, spical character... Please help.... (7 Replies)
Discussion started by: shell1509
7 Replies

9. Shell Programming and Scripting

Ksh: Read line parse characters into variable and remove the line if the date is older than 50 days

I have a test file with the following format, It contains the username_date when the user was locked from the database. $ cat lockedusers.txt TEST1_21062016 TEST2_02122015 TEST3_01032016 TEST4_01042016 I'm writing a ksh script and faced with this difficult scenario for my... (11 Replies)
Discussion started by: humble_learner
11 Replies

10. Shell Programming and Scripting

Remove first 2 characters and last two characters of each line

here's what im trying to do. i have a file containing lines similar to this: data.txt: 1hsRmRsbHRiSFZNTTA1dlEyMWFkbU5wUW5CSlIyeDFTVU5SYjJOSFRuWmpia0ZuWXpKV2FHTnRU 1lKUnpWMldrZFZaMG95V25oYQpSelEyWTBka2QyRklhSHBrUjA1b1kwUkJkd3BOVXpWM1lVaG5k... (5 Replies)
Discussion started by: SkySmart
5 Replies

LEARN ABOUT OPENSOLARIS

iconv_646

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 04:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy