Hi,
Below is the format of a report generated by a custom reporting solution. I opened the report in Notepad++ and junked data and values as in the image below.
I want to convert the values to a PIPE delimited format as below
But there are challenges in getting this as the column heading itself is spread across two lines. There are lot of reports like this covering different subjects. I tried writing a program in Python to get this done. But not able to. Is there any way to handle this?
Hi guys,
I've got a log file which has entries that look like this:
-------------------------------------------------------------------------------
06/08/04 07:57:57
AMQ9002: Channel program started.
EXPLANATION:
Channel program 'INSCCPQ1.HSMTSPQ1' started.
ACTION:
None. ... (3 Replies)
Hello,
I have 2 files say
File 1 has
ABC
DEF
GHI
File 2 has
123
456
789
I need output as
ABC 123
DEF 456
GHI 789
I tried awk and sed but not able to get it in the right way. :confused:
Please help. Thanks (25 Replies)
I've done this before but I can't remember how. Too long away from vi.
I want to do a search are replace, but I want the replace to be a join.
Example
see spot run
see spot walk
see spot run fast
see spot hop
%s/run$/<somehow perform a join with the next line>/g
so the results... (0 Replies)
i have a script that joins 2 lines of a file into one line and again next 2 line into one line.
if number of line is 4 then after joining it should be 2 lines in a file
my file a1.txt has some of the below lines
1-GH32X, CC, AMR,
Number of Intervals Not Inserted: 1 / 95
1-150KP1, CC,... (3 Replies)
Hi ,
I want to join two lines in a file, where the second line contain query string. if it doesn't contain that string i don't want to join
e.g.
Input file is as following:
name fame game
none none none
name fame game
cat eat mice
I need output file as
name fame game
none none... (2 Replies)
Hi All,
I need the command to join 2 lines into one. I found lots of threads but none give me the sollution. Probably because unix scripting is one of my best features ;)
I got a logfile where line 2 needs to be joined with line 1, lines 4 needs to be joined with line 3 etc
If you need... (16 Replies)
Hi Guys,
Was trying to attempt the below using awk and sed, have no luck so far, so any help would be appreciated.
Current Text File: The first line has got an "\n", and the second line has got spaces/tabs then the word and "\n"
TIME SERVER/CLIENT TEXT... (6 Replies)
I have a plain test file with a delimeter ''. In this file some lines are broken into two. The first part of these broken line will have 6 columns and the second part will have 4. These broken lines will be consicutive.
I want to join the two consicutive lines which are having 6 fields and 4... (8 Replies)
Hi all,
I'm excited to the part of unix.com forum, and noob to it.
I have an query, where I have an file and it contains data like this
use
thread
when
posting
do
no
I was expecting the result as
use thread
thread when
when posting
posting do
do no
use thread when
thread when... (6 Replies)
Hi - I have req to join broken lines and remove empty lines but should NOT be in one line. It has to be as is line by line. The challenge here is there is no end of line/start of line char.
thanks in advance
Source:-
2003-04-34024|04-10-2003|Claims|Claim|01-13-2003|Air Bag:Driver;... (7 Replies)
Discussion started by: Jackceasar123
7 Replies
LEARN ABOUT MOJAVE
system_profiler
SYSTEM_PROFILER(8) BSD System Manager's Manual SYSTEM_PROFILER(8)NAME
system_profiler -- reports system hardware and software configuration.
SYNOPSIS
system_profiler [-usage]
system_profiler [-listDataTypes]
system_profiler [-xml] dataType1 ... dataTypeN
system_profiler [-xml] [-detailLevel level]
DESCRIPTION
system_profiler reports on the hardware and software configuration of the system. It can generate plain text reports or XML reports which
can be opened with System Information.app
Progress and error messages are printed to stderr while actual report data is printed to stdout. Redirect stderr to /dev/null to suppress
progress and error messages.
The following options are available:
-xml Generates a report in XML format. If the XML report is redirected to a file with a ".spx" suffix that file can be opened
with System Information.app.
-listDataTypes Lists the available datatypes.
-detailLevel level Specifies the level of detail for the report:
mini report with no personal information
basic basic hardware and network information
full all available information
-timeout Specifies the maximum time to wait in seconds for results. If some information is not available within the specified
time limit then an incomplete or partial report will be generated. The default timeout is 180 seconds. Specifying a time-
out of 0 means no timeout.
-usage Prints usage info and examples.
EXAMPLES
system_profiler
Generates a text report with the standard detail level.
system_profiler -detailLevel mini
Generates a short report containing no personal information.
system_profiler -listDataTypes
Shows a list of the available data types.
system_profiler SPSoftwareDataType SPNetworkDataType
Generates a text report containing only software and network data.
system_profiler -xml > MyReport.spx
Creates a XML file which can be opened by System Profiler.app
AUTHORS
Apple Computer, Inc.
Darwin June 30, 2003 Darwin