Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need help in converting the file format
Top Forums Shell Programming and Scripting Need help in converting the file format Post 302887143 by Chubler_XL on Thursday 6th of February 2014 01:33:58 AM
Old 02-06-2014
Try this awk solution:

Code:
awk -F, 'NR==1{
   OFS=","
   for(i=8;i<=NF;i++) {
      H[i]=$i
      $i=""
   }
   $8="Event Type"
   $9="Event Value"
   NF=9
   print
   next
}
{L[NR]=$0}
END{
  for(l=2;l<=NR;l++) {
       split(L[l],V,",")
       print V[1],V[2],V[3],V[4],V[5],V[6],V[7],-1,0
  }
  for(l=2;l<=NR;l++) {
     for(m=8;m<i;m++) {
       split(L[l],V,",")
       print V[1],V[2],V[3],V[4],V[5],0,0,H[m],V[m]
     }
  }
}' infile

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Converting the File Creation Date to a new format

I need to capture a file's creation/modification date and time and convert this to a different format, whilst I can easily get the existing format from a ls -l | awk ' { print $......}' or a cut command I do not know how to convert it to a desired format? I should add that at present the ls -l... (1 Reply)
Discussion started by: barney_clough
1 Replies

2. Shell Programming and Scripting

converting config file to csv format

Hello, For 2 days now i've been searching for a solution to this. I am now beginning to doubt this is even possible. It's even harder when you don't know how to search for it. (which keywords generate enough relevancy etc..) I need to parse a config file to generate a CSV file in return. It... (7 Replies)
Discussion started by: zer0dvide
7 Replies

3. Shell Programming and Scripting

Sybase Interface file and converting in text format.

Does anyone knows how to decode the address in interface file using shell , i have done it using perl but can it be done in shell. master tli tcp /dev/tcp \x00021004ac1414230000000000000000 query tli tcp /dev/tcp \x00021004ac1414230000000000000000 (0 Replies)
Discussion started by: dinjo_jo
0 Replies

4. Shell Programming and Scripting

Converting file format

My input file is Pipe delimited with 10 fields, I am trying to create a tab delimited output file with 6 fields from the provided input file. Below is sample data Input file abc||2|PIN|num||||www.123.com|abc@123.com| bcd||2|PIN|num|||||abc@123.com|... (3 Replies)
Discussion started by: pasupuleti81
3 Replies

5. Shell Programming and Scripting

Converting Unicode file to UTF8 format

Hi, I have a file in my desktop which is a unicode format. After this file is transferred to Unix using FTP, we are seeing some special character (like rectangle box type) at the first line. The same file is saved as UTF8 (using textpad tool, selecting encode to UTF-8 option) on my desktopand... (7 Replies)
Discussion started by: vfrg
7 Replies

6. UNIX for Dummies Questions & Answers

Converting binary file to readable format in Ksh

In Unix/Ksh, when I try to look inside a file it says that the file may be a binary file and if I want to see it anyway. When i say 'yes', it shows me the content filled with unreadable symbols (looks like binary). Is there a command that I can run from the Unix prompt to convert/translate that... (3 Replies)
Discussion started by: arthurs
3 Replies

7. Shell Programming and Scripting

Converting windows format file to unix format using script

Hi, I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix. My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies

8. UNIX for Advanced & Expert Users

Converting the date format in a flat file

Hi All, I am new to this forum, could any one help me out in resolving the below issue. Input of the flat file contains several lines of text for example find below: 5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2 5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1... (0 Replies)
Discussion started by: av_sagar
0 Replies

9. Shell Programming and Scripting

Format problem while converting text file to csv

Hi , I need a help in following scenario.I tried searching in google but couldn't able to find the exact answer. Sorry if i am re-posting already answered query. While i am trying to convert into log file into csv i couldn't able to get the format which i am looking for. I converted file... (4 Replies)
Discussion started by: varmas424
4 Replies

10. UNIX for Dummies Questions & Answers

help required in converting a file format

My file format: -------------------------------------------------- Complete Consistency Check Valid Area : VALID:VALID Started by : esanwad Started at : Thu Dec 11 16:04:46 2014 CNA version : R21H04_EC08 Check range : AREA VALID/VALID ... (4 Replies)
Discussion started by: Gautam Banerjee
4 Replies

LEARN ABOUT OSF1

llconvert

llconvert(8)						      System Manager's Manual						      llconvert(8)

NAME

       llconvert - Modify lastlog records from DIGITAL UNIX releases 4.0x and prior to new format

SYNOPSIS

       /usr/lbin/llconvert [-vnrp?h] input_file [output_file]

OPTIONS

       Restore new format to old format.  Verbose. Display lines while converting.  Do not preserve contents of input file.  Formatted print only.
       Do not convert. (May be used with the -r option).  Display usage message.

DESCRIPTION

       The llconvert command reads records from the lastlog file, such as /var/adm/lastlog, and converts the record format to the  updated  struct
       lastlog	format.  If  no  output file is specified or if the output file path is identical to the input file path, llconvert makes a backup
       copy of the original input file using the following algorithm: If filename.orig exists.	Where n is a unique number.

       The llconvert command attempts to detect an input file that is in the wrong format (for example, input file is already a new format  file).
       A warning message is issued in this case, but conversion continues.

RETURN VALUES

       Success.  An error occurred.

EXAMPLES

       To convert an old format accounting file to the new format: llconvert /var/adm/lastlog.prev

	      Upon  completion	of  this  command,  /var/adm/lastlog.prev  will have been converted to the new format. The original /var/adm/last-
	      log.prev is renamed to:

	      /var/adm/lastlog.prev.orig To convert a lastlog file in new format to the old format: llconvert -r  /var/adm/lastlog  /var/adm/last-
	      log.old

FILES

       Lastlog header file that defines the format for the lastlog file.  The active lastlog file.

SEE ALSO

       Commands: finger(1)

																      llconvert(8)
All times are GMT -4. The time now is 04:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy