Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help in formatting a file.
Top Forums Shell Programming and Scripting Need help in formatting a file. Post 302672183 by jpkumar10 on Monday 16th of July 2012 04:47:18 AM
Old 07-16-2012
Need help in formatting a file.
Hi,

I have a file in the following format.
cat input

Code:
name: abcd_ef_1
  234:343:343
  343:234:343
 name : abcdef_2
  2343:2343:3434:
  w3243:wr43:2343
  2343:2343:23343:3432
  2343:34234:2343
 name: 3432_343_3
  23432:2343
  2343:23432:32432
  23432:23432:3432432

As you can see above I have name filed and below which there are some txt. It have either 2 or 3 text line. I use paste to do it. but as you can see that the no of fields seperating name are not constant. some of them have 3 inputs some of them have 4 and some have 2.

I need the o/p in the following format.

Code:
cat output_file

 name: abcd_ef_1  234:343:343  343:234:343 
 name: abcdef_2  2343:2343:3434:  w3243:wr43:2343  2343:2343:23343:3432  2343:34234:2343 
 name: 3432_343_3  23432:2343  2343:23432:32432  23432:23432:3432432


Thanks in advance.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Formatting a file

Hi All, I have been trying to format a file using sed. I can't seem to get the syntax right. I want to append the next line delemited by a comma or a comma and double quotes. Here is an example of the file I'm tring to format: Before formatting: 00324 03A0312 BRI-u24 0000324 01 H-12... (4 Replies)
Discussion started by: cstovall
4 Replies

2. Shell Programming and Scripting

Help with formatting of file.

I have a file with following file format - DMCRH|||83000171|||14022008||0430|||8956612.23|J|||3571235|1378452|23468|6894|9234| DMCRH|||83000215|||15092007||0480|||121.33|J|||LineID003|RefNumSP003|RefNumMem003|0004|0003| What i need done is - 1. Cut the firt four digits of the date (eg 1402... (3 Replies)
Discussion started by: divz
3 Replies

3. UNIX for Dummies Questions & Answers

Formatting a file.

I want to format a file to limit record length = 100, in each line. Any idea how i can do this? (1 Reply)
Discussion started by: abhilasha
1 Replies

4. Shell Programming and Scripting

File Formatting

Hi, Need to delete all the records prior to pattern (INSERT/UPDATE/DELETE). If ' is available, then need to retain it. Input ====================== l_s := ' INSERT INTO TEST' l_P PD := ' UPDATE INTO TEST' l_D := ' DELETE INTO TEST' This is test Input ======================... (1 Reply)
Discussion started by: saurabhbaisakhi
1 Replies

5. Shell Programming and Scripting

File Formatting

Hi, Need to delete all the records prior to pattern (INSERT/UPDATE/DELETE). If ' is available, then need to retain it. Input ====================== l_s := ' INSERT INTO TEST' l_P PD := ' UPDATE INTO TEST' l_D := ' DELETE INTO TEST' This is test Output ======================... (1 Reply)
Discussion started by: saurabhbaisakhi
1 Replies

6. Shell Programming and Scripting

File formatting

I need to count the number of lines between two sets of pattern in a file and delete those lines from that file e.g From jyotiv@yahoo.com test test2 test3 test4 test5 test6 From Jyotiv@yahoo.com So count lines from test to test6 and delete it from the start of file till next From... (1 Reply)
Discussion started by: jyotiv
1 Replies

7. Shell Programming and Scripting

File formatting

Hi, I have a file which contains data in this format # User@Host: abc @ Id: 0000000 # Query_time: 0.000070 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=00000000; SELECT @@version, @@version_comment; # User@Host: abcd @ Id: 00000000 # Query_time: 0.000228 ... (6 Replies)
Discussion started by: arijitsaha
6 Replies

8. Shell Programming and Scripting

File Formatting

Hi, I have requirement to format the file.My input file tab(\t) saperated. File format is:- 93 WARNING Sat Mar 17 20:31:59 2012 Sequential_File_0,0: Missing record delimiter "\r\n", saw EOF instead 94 WARNING Sat Mar 17 20:31:59 2012 Sequential_File_0,0: Import... (4 Replies)
Discussion started by: prasson_ibm
4 Replies

9. Shell Programming and Scripting

Formatting file data to another file (control character related)

I have to write a program to read data from files and then format into another file. However, I face a strange problem related to control character that I can't understand and solve. The source file is compose of many lines with such format: T_NAME|P_NAME|P_CODE|DOCUMENT_PATH|REG_DATE ... (3 Replies)
Discussion started by: hk6279
3 Replies

10. UNIX for Dummies Questions & Answers

Formatting data in a raw file by using another mapping file

Hi All, i have a requirement where i need to format the input RAW file ( which is CSV) by using another mapping file(also CSV file). basically i am getting feed file with dynamic headers by using mapping file (in that target field is mapped with source filed) i have to convert the raw file into... (6 Replies)
Discussion started by: ravi4informatic
6 Replies

LEARN ABOUT SUNOS

iconv_pc_cyr

iconv_pc_cyr(5) 					Standards, Environments, and Macros					   iconv_pc_cyr(5)

NAME

       iconv_pc_cyr - code set conversion tables for Alternative PC Cyrillic

DESCRIPTION

       The following code set conversions are supported:

       +---------------------------------------------------------------------+
       |		   Code Set Conversions Supported		     |
       +--------------+--------+--------------+--------+---------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |    Target Output    |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |KOI8-R	      |koi8    | KOI8-R 	     |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |MS 1251       |win5    | Windows Cyrillic    |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |Mac Cyrillic  |mac     | Macintosh Cyrillic  |
       +--------------+--------+--------------+--------+---------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   PC Cyrillic to ISO 8859-5
       For the conversion of PC Cyrillic to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | PC Cyrillic   |  ISO 8859-5	| PC Cyrillic	 |  ISO 8859-5	 |
       |24	       | 4		|231		 |311		 |
       |200	       | 260		|232		 |312		 |
       |201	       | 261		|233		 |313		 |
       |202	       | 262		|234		 |314		 |
       |203	       | 263		|235		 |315		 |
       |204	       | 264		|236		 |316		 |
       |205	       | 265		|237		 |317		 |
       |206	       | 266		|240		 |320		 |
       |207	       | 267		|241		 |321		 |
       |210	       | 270		|242		 |322		 |
       |211	       | 271		|243		 |323		 |
       |212	       | 272		|244		 |324		 |
       |213	       | 273		|245		 |325		 |
       |214	       | 274		|246		 |326		 |
       |215	       | 275		|247		 |327		 |
       |216	       | 276		|250		 |330		 |
       |217	       | 277		|251		 |331		 |
       |220	       | 300		|252		 |332		 |
       |221	       | 301		|253		 |333		 |
       |222	       | 302		|254		 |334		 |
       |223	       | 303		|255		 |335		 |
       |224	       | 304		|256		 |336		 |
       |225	       | 305		|257		 |337		 |
       |226	       | 306		|260-337	 |255		 |
       |227	       | 307		|360		 |241		 |
       |230	       | 310		|362-376	 |255		 |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to KOI8-R
       For the conversion of PC Cyrillic to KOI8-R, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | PC Cyrillic   |    KOI8-R	| PC Cyrillic	 |    KOI8-R	 |
       |24	       | 4		|242		 |327		 |
       |200	       | 341		|243		 |307		 |
       |201	       | 342		|244		 |304		 |
       |202	       | 367		|245		 |305		 |
       |203	       | 347		|246		 |326		 |
       |204	       | 344		|247		 |332		 |
       |205	       | 345		|250		 |311		 |
       |206	       | 366		|251		 |312		 |
       |207	       | 372		|252		 |313		 |
       |210	       | 351		|253		 |314		 |
       |211	       | 352		|254		 |315		 |
       |212	       | 353		|255		 |316		 |
       |213	       | 354		|256		 |317		 |
       |214	       | 355		|257		 |320		 |
       |215	       | 356		|260-337	 |255		 |
       |216	       | 357		|340		 |322		 |
       |217	       | 360		|341		 |323		 |
       |220	       | 362		|342		 |324		 |
       |221	       | 363		|343		 |325		 |
       |222	       | 364		|344		 |306		 |
       |223	       | 365		|345		 |310		 |
       |224	       | 346		|346		 |303		 |
       |225	       | 350		|347		 |336		 |
       |226	       | 343		|350		 |333		 |
       |227	       | 376		|351		 |335		 |
       |230	       | 373		|352		 |337		 |
       |231	       | 375		|353		 |331		 |
       |232	       | 377		|354		 |330		 |
       |233	       | 371		|355		 |334		 |
       |234	       | 370		|356		 |300		 |
       |235	       | 374		|357		 |321		 |
       |236	       | 340		|360		 |263		 |
       |237	       | 361		|361		 |243		 |
       |240	       | 301		|362-376	 |255		 |
       |241	       | 302		|		 |		 |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to MS 1251
       For the conversion of PC Cyrillic to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | PC Cyrillic   |    MS 1251	| PC Cyrillic	 |   MS 1251	 |
       |24	       | 4		|242		 |342		 |
       |200	       | 300		|243		 |343		 |
       |201	       | 301		|244		 |344		 |
       |202	       | 302		|245		 |345		 |
       |203	       | 303		|246		 |346		 |
       |204	       | 304		|247		 |347		 |
       |205	       | 305		|250		 |350		 |
       |206	       | 306		|251		 |351		 |
       |207	       | 307		|252		 |352		 |
       |210	       | 310		|253		 |353		 |
       |211	       | 311		|254		 |354		 |
       |212	       | 312		|255		 |355		 |
       |213	       | 313		|256		 |356		 |
       |214	       | 314		|257		 |357		 |
       |215	       | 315		|260-337	 |210		 |
       |216	       | 316		|340		 |360		 |
       |217	       | 317		|341		 |361		 |
       |220	       | 320		|342		 |362		 |
       |221	       | 321		|343		 |363		 |
       |222	       | 322		|344		 |364		 |
       |223	       | 323		|345		 |365		 |
       |224	       | 324		|346		 |366		 |
       |225	       | 325		|347		 |367		 |
       |226	       | 326		|350		 |370		 |
       |227	       | 327		|351		 |371		 |
       |230	       | 330		|352		 |372		 |
       |231	       | 331		|353		 |373		 |
       |232	       | 332		|354		 |374		 |
       |233	       | 333		|355		 |375		 |
       |234	       | 334		|356		 |376		 |
       |235	       | 335		|357		 |377		 |
       |236	       | 336		|360		 |250		 |
       |237	       | 337		|361		 |270		 |
       |240	       | 340		|362-376	 |210		 |
       |241	       | 341		|		 |		 |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to Mac Cyrillic
       For the conversion of PC Cyrillic to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       | PC Cyrillic   | Mac Cyrillic	| PC Cyrillic	 | Mac Cyrillic  |
       |24	       | 4		|341		 |361		 |
       |240	       | 340		|342		 |362		 |
       |241	       | 341		|343		 |363		 |
       |242	       | 342		|344		 |364		 |
       |243	       | 343		|345		 |365		 |
       |244	       | 344		|346		 |366		 |
       |245	       | 345		|347		 |367		 |
       |246	       | 346		|350		 |370		 |
       |247	       | 347		|351		 |371		 |
       |250	       | 350		|352		 |372		 |
       |251	       | 351		|353		 |373		 |
       |252	       | 352		|354		 |374		 |
       |253	       | 353		|355		 |375		 |
       |254	       | 354		|356		 |376		 |
       |255	       | 355		|357		 |337		 |
       |256	       | 356		|360		 |335		 |
       |257	       | 357		|361		 |336		 |
       |260-337        | 40		|362-376	 |40		 |
       |340	       | 360		|		 |		 |
       +---------------+----------------+----------------+---------------+

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							    18 Apr 1997 						   iconv_pc_cyr(5)
All times are GMT -4. The time now is 02:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy