Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Missing information in output file
Top Forums Shell Programming and Scripting Missing information in output file Post 303008079 by jiam912 on Monday 27th of November 2017 05:47:10 AM
Old 11-27-2017
Missing information in output file
Gents,

Using the following code i am able to output the information i need, but some of the strings are not complete due to the separator : used..

Kindly can u help me to get all string after the first :

Example in the output file column 16 i should get
Code:
17/11/25 03:43:51:732000 [13431732000 microsec]

but i got
Code:
732000[13431732000microsec]

And also i don't understand why i dont get information for last records

Here the code
Code:
awk 'BEGIN {
      qq="\""
      tab=sprintf("\t")

      FS=":"
      OFS=","

fldL="SL,SN,SI,StackNb,FleetNb,DsdNb,SweepCounter,SweepType,SweepStatus,Drive,GpsStatus,GNGSA,GNGST,GPZDA,PTNL,TB,QCtype,TimeInhibit,timeendofprevsweeptoup,padup,paddown,timeuptodown,timedowntopressureswitchON,timedowntoready,timedowntosweep,sweeplength"

     fldN=split(fldL, fldT, OFS)
      for(i=1; i in fldT; i++)
        fldA[fldT[i]]=i

      print fldL
}

function normStr(str)
{
   gsub("[" OFS qq tab " ]", "", str)
   return str
}

function arrayFull(a,   i)
{
  for(i=1; i<= fldN; i++)
     if (!(i in a))
        return 0
 return 1
}

arrayFull(outputA) {
  for(i=1; i in outputA; i++)
      printf("%s%s", outputA[i], (i==fldN)?ORS:OFS)
  split("", outputA)
}
normStr($1) in fldA {
   fld1=normStr($1)
   fld2=normStr($NF)
   if (normStr($2) == "[") {
       getline fld2
       fld2=normStr(fld2)
   }
   outputA[fldA[fld1]]=fld2
}' file1.txt > test.csv


Attached the input file and output file i got


Appreciate your help
test.zip (1.8 KB) 
Last edited by jiam912; 11-27-2017 at 06:52 AM.. Reason: forget to attach the files
 

9 More Discussions You Might Find Interesting

1. AIX

#emgr -l command output missing

Hi, I have recently started to patch all my AIX boxes. I have applied almost 28 interim fixes on those. i have the snaps of emgr -l out put showing all tha patch details and date on which those we applied. but after reboot, emgr -l comannd says "There is no efix data on this... (0 Replies)
Discussion started by: sandeepbodkhe
0 Replies

2. Shell Programming and Scripting

ksh/awk help - output missing numbers

Here is what I am trying to do: I have a list of numbers that I pulled from an awk command in a column like so: 1 3 4 7 8 I want to find which numbers in the list are missing out of a range. So let's say I want to find out from the list above which numbers are missing from the... (6 Replies)
Discussion started by: afavis
6 Replies

3. Shell Programming and Scripting

Using txr to extract information from output

am using txr command (txr 1097) on a process that generates the following output. Im trying to extract the 13th field from the highlighted string. it is delimited by '?'. The 13th field corresponds to the '0' (in bold). can you let me know how I can extract the 13 th field please? ... (1 Reply)
Discussion started by: pazman
1 Replies

4. UNIX and Linux Applications

missing delimiters when mysql output is redirected to log file

Hi, Pls check that '|' and '+' present in Step-1 are not copied to log file in Step-3. Pls suggest how to get the exact output from Step-1 (i.e. with out losing '|' and '+') in to a log file ~Thanks Step-1: Execute command > mysql -utest -ptest -htesthost testdb -e "select * from... (3 Replies)
Discussion started by: newbielgn
3 Replies

5. Shell Programming and Scripting

Script to output a line missing a number

Ok, Lets see if I can explain this We have a script that pulls information from multiple files and outputs it, however I only need 2 Columns (of 11) from it right now I run the script like this: tkxtrn | awk '{print $5" "" "$9}' This gives me column 5 and 9, the only two I care for ... (5 Replies)
Discussion started by: shadowkraze
5 Replies

6. Shell Programming and Scripting

get specific information from text file or command output

Hello, I would need some help, :wall: on a linux script, I am not sure how can I separate some text file, Text file contains something similar to this: share "userhome_e" "/fs1_100g/FILE58/userhome" umask=022 maxusr=4294967295 netbios=FILE58 share "bu share"... (3 Replies)
Discussion started by: nakaedu
3 Replies

7. Shell Programming and Scripting

Pipe output missing date?

I'd like to have the output from this script piped to a text file that has the date at the beginning of it. For example, my ideal would be something like this $./run_script.sh $ls *.out 2013-Feb-26-output_filename.out Here's the code I'm using. #! /bin/ksh DAT=`date '+%Y-%b-%d'` for... (2 Replies)
Discussion started by: DustinT
2 Replies

8. Shell Programming and Scripting

Fix script to get missing information

Gents, Can you please help me to fix the following script in order to get complete data as desired. I am missing some data in output. the complete input file is attached. The script I am using is awk '{\ status=substr($0,91,2)\ ind=substr($0,26,1);\ ... (10 Replies)
Discussion started by: jiam912
10 Replies

9. Shell Programming and Scripting

Get specific information from output

Hello community, I'm going crazy to analize an output via shell script and then get some information from it, here is the output: Slot 2 - MMU2 H, RAU2 X 15/A01 XPIC Enabled Autorestore Unknown Slot 3 - MMU2 H, RAU2 X 15/A01 XPIC ... (7 Replies)
Discussion started by: Lord Spectre
7 Replies

LEARN ABOUT REDHAT

dircolors

DIRCOLORS(1)								FSF							      DIRCOLORS(1)

NAME

       dircolors - color setup for ls

SYNOPSIS

       dircolors [OPTION]... [FILE]

DESCRIPTION

       Output commands to set the LS_COLORS environment variable.

   Determine format of output:
       -b, --sh, --bourne-shell
	      output Bourne shell code to set LS_COLORS

       -c, --csh, --c-shell
	      output C shell code to set LS_COLORS

       -p, --print-database
	      output defaults

       --help display this help and exit

       --version
	      output version information and exit

       If  FILE  is specified, read it to determine which colors to use for which file types and extensions.  Otherwise, a precompiled database is
       used.  For details on the format of these files, run `dircolors --print-database'.

AUTHOR

       Written by H. Peter Anvin.

REPORTING BUGS

       Report bugs to <bug-coreutils@gnu.org>.

COPYRIGHT

       Copyright (C) 2002 Free Software Foundation, Inc.
       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

SEE ALSO

       The  full documentation for dircolors is maintained as a Texinfo manual.  If the info and dircolors programs are properly installed at your
       site, the command

	      info dircolors

       should give you access to the complete manual.

dircolors (coreutils) 4.5.3					   February 2003						      DIRCOLORS(1)
All times are GMT -4. The time now is 04:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy