Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to format or create a matrix report from file
Top Forums Shell Programming and Scripting How to format or create a matrix report from file Post 302271206 by manas_ranjan on Wednesday 24th of December 2008 08:38:06 AM
Old 12-24-2008
thank u so much for your idea and suggestion......i did the below method and able to extract the file in some manner ,
grep -E "VSTR_KEY$GEN_VSTR_INDEX|MESSAGE_ID" a.txt | awk -F" " '{print $4}'
"EQUENS0001C081222081222081222"
"20081219/00000006"
"EQUENS0002C081222081222081222"
"20081219/00000007"
"EQUENS1100C081222081222081222"
"20081219/00000005"
so now my query is can i format this o/p to below
"EQUENS0001C081222081222081222"-"20081219/00000006"
"EQUENS0002C081222081222081222"-"20081219/00000007"
"EQUENS1100C081222081222081222"-"20081219/00000005"
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to create concatenate a file in tab format

Hi, Do you know given a file which is SED at the same time, how to read it and AWK it in tabs format. Means:- I have an input file which is (at the same time perform sed):- 1 2 3 4 5 6 7 I would like to print out in tab format which is:- 1 2 3 4 5 6 7 .... (12 Replies)
Discussion started by: ahjiefreak
12 Replies

2. UNIX for Dummies Questions & Answers

create data file from report file

Dear Ones, kindly help me to create a data file from the report file as shown here under( i am new one to unix KNOW BASIC COMMANDS) file:rama.prt (ist record)(3 to 4 lines of text with different filed names) Name :M.LALITHA DOB:12/11/45 DESG :JA(P) STANO:300175 ... (3 Replies)
Discussion started by: cvvsnm
3 Replies

3. Shell Programming and Scripting

Help to Create this file format structure

This data comes form the table and exported into the file in this format File1 Format weboffercode1,sourcecode1,1,1,1,1,1,1 weboffercode1,sourcecode2,1,1,1,1,1,1 weboffercode1,sourcecode1,1,1,1,1,1,1 weboffercode1,sourcecode3,1,1,1,1,1,1 weboffercode1,sourcecode3,1,1,1,1,1,1 ... (4 Replies)
Discussion started by: enigma_83
4 Replies

4. UNIX for Advanced & Expert Users

to create format file for bcp in

I want to create the format file for bcp in a file to the table. My Versions are: Unix: Sun OS, DB: Sybase. How can i create the format file. Is there any way to create the format by bcp command or some system sp. Please help. (3 Replies)
Discussion started by: Arunprasad
3 Replies

5. Shell Programming and Scripting

awk? create similarity matrix by calculating overlaps between sets comprising of individual parts

Hi everyone I am very new at awk and to me the task I need to get done is very very challenging... Nevertheless, after admiring how fast and elegant issues are being solved here I am sure this is my best chance. I have a 2D data file (input file is a plain tab-delimited text file). The first... (1 Reply)
Discussion started by: stonemonkey
1 Replies

6. Shell Programming and Scripting

Create a report for client with a text data file

Hi, I am an amateur bash scriptwriter and I need to write a script which creates a report in a formatted, easy to read table-like that is displayed to standard output. The script has to export the followings: Process ID,User Name, Command Name,Priority..... Now I have a file that I can see all... (3 Replies)
Discussion started by: bashily
3 Replies

7. Programming

Transforming 3 columns to matrix format

Dear All I have a huge data for 3 columns similar to this D2cls0 D2cls0 1 D2cls0 D2cls1 0.308 D2cls0 D2cls2 0.554 D2cls0 D2cls3 0.287 D2cls0 D2cls4 0.633 D2cls0 D2cls5 0.341 D2cls0 D2cls6 0.665 D2cls0 D2cls7 0.698 D2cls0 D2cls8 0.625 D2cls0 D2cls9 0.429 I... (9 Replies)
Discussion started by: bala06
9 Replies

8. Shell Programming and Scripting

Needed touch command to create a file in the following format

needed touch command to create a file in the following format touch a_yyyymmdd_hhmmss (1 Reply)
Discussion started by: hemanthsaikumar
1 Replies

9. Shell Programming and Scripting

How to create a file from output of vertica table query in UTF-8 format?

Hello, In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data. file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies

10. UNIX for Beginners Questions & Answers

Create movie from jpg (or other picture format) file

hi linux expert is there any program for create movie file from pictures file (like jpg)? Many Thanks samad (1 Reply)
Discussion started by: abdossamad2003
1 Replies

LEARN ABOUT DEBIAN

locale::recodedata::inis

Locale::RecodeData::INIS(3pm)				User Contributed Perl Documentation			     Locale::RecodeData::INIS(3pm)

NAME

       Locale::RecodeData::INIS - Conversion routines for INIS

SYNOPSIS

       This module is internal to libintl.  Do not use directly!

DESCRIPTION

       This module is generated and contains the conversion tables and routines for INIS.

COMMENTS

       The following comments have been extracted from the original charmap:

	version: 1.0
	 source: ECMA registry
	alias ISO-IR-49

       Please note that aliases listed above are not necessarily valid!

CHARACTER TABLE

       The following table is sorted in the same order as the original charmap.  All character codes are in hexadecimal.  Please read 'ISO-10646'
       as 'ISO-10646-UCS4'.

	Local | ISO-10646 | Description
       -------+-----------+-------------------------------------------------
	   00 |  00000000 | NULL (NUL)
	   01 |  00000001 | START OF HEADING (SOH)
	   02 |  00000002 | START OF TEXT (STX)
	   03 |  00000003 | END OF TEXT (ETX)
	   04 |  00000004 | END OF TRANSMISSION (EOT)
	   05 |  00000005 | ENQUIRY (ENQ)
	   06 |  00000006 | ACKNOWLEDGE (ACK)
	   07 |  00000007 | BELL (BEL)
	   08 |  00000008 | BACKSPACE (BS)
	   09 |  00000009 | CHARACTER TABULATION (HT)
	   0A |  0000000A | LINE FEED (LF)
	   0B |  0000000B | LINE TABULATION (VT)
	   0C |  0000000C | FORM FEED (FF)
	   0D |  0000000D | CARRIAGE RETURN (CR)
	   0E |  0000000E | SHIFT OUT (SO)
	   0F |  0000000F | SHIFT IN (SI)
	   10 |  00000010 | DATALINK ESCAPE (DLE)
	   11 |  00000011 | DEVICE CONTROL ONE (DC1)
	   12 |  00000012 | DEVICE CONTROL TWO (DC2)
	   13 |  00000013 | DEVICE CONTROL THREE (DC3)
	   14 |  00000014 | DEVICE CONTROL FOUR (DC4)
	   15 |  00000015 | NEGATIVE ACKNOWLEDGE (NAK)
	   16 |  00000016 | SYNCHRONOUS IDLE (SYN)
	   17 |  00000017 | END OF TRANSMISSION BLOCK (ETB)
	   18 |  00000018 | CANCEL (CAN)
	   19 |  00000019 | END OF MEDIUM (EM)
	   1A |  0000001A | SUBSTITUTE (SUB)
	   1B |  0000001B | ESCAPE (ESC)
	   1C |  0000001C | FILE SEPARATOR (IS4)
	   1D |  0000001D | GROUP SEPARATOR (IS3)
	   1E |  0000001E | RECORD SEPARATOR (IS2)
	   1F |  0000001F | UNIT SEPARATOR (IS1)
	   20 |  00000020 | SPACE
	   24 |  00000024 | DOLLAR SIGN
	   25 |  00000025 | PERCENT SIGN
	   27 |  00000027 | APOSTROPHE
	   28 |  00000028 | LEFT PARENTHESIS
	   29 |  00000029 | RIGHT PARENTHESIS
	   2A |  0000002A | ASTERISK
	   2B |  0000002B | PLUS SIGN
	   2C |  0000002C | COMMA
	   2D |  0000002D | HYPHEN-MINUS
	   2E |  0000002E | FULL STOP
	   2F |  0000002F | SOLIDUS
	   30 |  00000030 | DIGIT ZERO
	   31 |  00000031 | DIGIT ONE
	   32 |  00000032 | DIGIT TWO
	   33 |  00000033 | DIGIT THREE
	   34 |  00000034 | DIGIT FOUR
	   35 |  00000035 | DIGIT FIVE
	   36 |  00000036 | DIGIT SIX
	   37 |  00000037 | DIGIT SEVEN
	   38 |  00000038 | DIGIT EIGHT
	   39 |  00000039 | DIGIT NINE
	   3A |  0000003A | COLON
	   3B |  0000003B | SEMICOLON
	   3C |  0000003C | LESS-THAN SIGN
	   3D |  0000003D | EQUALS SIGN
	   3E |  0000003E | GREATER-THAN SIGN
	   41 |  00000041 | LATIN CAPITAL LETTER A
	   42 |  00000042 | LATIN CAPITAL LETTER B
	   43 |  00000043 | LATIN CAPITAL LETTER C
	   44 |  00000044 | LATIN CAPITAL LETTER D
	   45 |  00000045 | LATIN CAPITAL LETTER E
	   46 |  00000046 | LATIN CAPITAL LETTER F
	   47 |  00000047 | LATIN CAPITAL LETTER G
	   48 |  00000048 | LATIN CAPITAL LETTER H
	   49 |  00000049 | LATIN CAPITAL LETTER I
	   4A |  0000004A | LATIN CAPITAL LETTER J
	   4B |  0000004B | LATIN CAPITAL LETTER K
	   4C |  0000004C | LATIN CAPITAL LETTER L
	   4D |  0000004D | LATIN CAPITAL LETTER M
	   4E |  0000004E | LATIN CAPITAL LETTER N
	   4F |  0000004F | LATIN CAPITAL LETTER O
	   50 |  00000050 | LATIN CAPITAL LETTER P
	   51 |  00000051 | LATIN CAPITAL LETTER Q
	   52 |  00000052 | LATIN CAPITAL LETTER R
	   53 |  00000053 | LATIN CAPITAL LETTER S
	   54 |  00000054 | LATIN CAPITAL LETTER T
	   55 |  00000055 | LATIN CAPITAL LETTER U
	   56 |  00000056 | LATIN CAPITAL LETTER V
	   57 |  00000057 | LATIN CAPITAL LETTER W
	   58 |  00000058 | LATIN CAPITAL LETTER X
	   59 |  00000059 | LATIN CAPITAL LETTER Y
	   5A |  0000005A | LATIN CAPITAL LETTER Z
	   5B |  0000005B | LEFT SQUARE BRACKET
	   5D |  0000005D | RIGHT SQUARE BRACKET
	   61 |  00000061 | LATIN SMALL LETTER A
	   62 |  00000062 | LATIN SMALL LETTER B
	   63 |  00000063 | LATIN SMALL LETTER C
	   64 |  00000064 | LATIN SMALL LETTER D
	   65 |  00000065 | LATIN SMALL LETTER E
	   66 |  00000066 | LATIN SMALL LETTER F
	   67 |  00000067 | LATIN SMALL LETTER G
	   68 |  00000068 | LATIN SMALL LETTER H
	   69 |  00000069 | LATIN SMALL LETTER I
	   6A |  0000006A | LATIN SMALL LETTER J
	   6B |  0000006B | LATIN SMALL LETTER K
	   6C |  0000006C | LATIN SMALL LETTER L
	   6D |  0000006D | LATIN SMALL LETTER M
	   6E |  0000006E | LATIN SMALL LETTER N
	   6F |  0000006F | LATIN SMALL LETTER O
	   70 |  00000070 | LATIN SMALL LETTER P
	   71 |  00000071 | LATIN SMALL LETTER Q
	   72 |  00000072 | LATIN SMALL LETTER R
	   73 |  00000073 | LATIN SMALL LETTER S
	   74 |  00000074 | LATIN SMALL LETTER T
	   75 |  00000075 | LATIN SMALL LETTER U
	   76 |  00000076 | LATIN SMALL LETTER V
	   77 |  00000077 | LATIN SMALL LETTER W
	   78 |  00000078 | LATIN SMALL LETTER X
	   79 |  00000079 | LATIN SMALL LETTER Y
	   7A |  0000007A | LATIN SMALL LETTER Z
	   7C |  0000007C | VERTICAL LINE
	   7F |  0000007F | DELETE (DEL)

AUTHOR

       Copyright (C) 2002-2009, Guido Flohr <guido@imperia.net>, all rights reserved.  See the source code for details.

       This software is contributed to the Perl community by Imperia (<http://www.imperia.net/>).

SEE ALSO

       Locale::RecodeData(3), Locale::Recode(3), perl(1)

POD ERRORS

       Hey! The above document had some coding errors, which are explained below:

       Around line 864:
	   =cut found outside a pod block.  Skipping to next block.

perl v5.10.1							    2009-06-23					     Locale::RecodeData::INIS(3pm)
All times are GMT -4. The time now is 10:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy