|
|
Sponsored Content
Top Forums
Programming
Joining Columnar heading from 2 lines
Post 303041829 by ramkrix on Wednesday 4th of December 2019 08:05:49 PM
12-04-2019
Joining Columnar heading from 2 lines
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?
Thanks,
Ramkrix
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?
Thanks,
Ramkrix
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: m223464
3 Replies
2. Shell Programming and Scripting
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)
Discussion started by: chandra004
25 Replies
3. UNIX for Dummies Questions & Answers
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)
Discussion started by: ifermon
0 Replies
4. Shell Programming and Scripting
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)
Discussion started by: ali560045
3 Replies
5. Shell Programming and Scripting
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)
Discussion started by: ashrafonics
2 Replies
6. Shell Programming and Scripting
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)
Discussion started by: rene21976
16 Replies
7. Shell Programming and Scripting
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)
Discussion started by: eo29
6 Replies
8. Shell Programming and Scripting
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)
Discussion started by: ratheeshjulk
8 Replies
9. Shell Programming and Scripting
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)
Discussion started by: Jose Nirmal
6 Replies
10. Shell Programming and Scripting
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 DEBIAN
imgsize
IMGSIZE(1p) User Contributed Perl Documentation IMGSIZE(1p) NAME
imgsize - read the dimensions of an image in several popular formats USAGE
imgsize [ -r | -a | -f fmt ] file [ file ... ] DESCRIPTION
No-brainer to size an image supplied on the command-line. All the real work is done in Image::Size. REQUIRED ARGUMENTS
imgsize expects file names on the command-line. If more than one file is provided, the file name will be included in the output: % imgsize dot.gif width="16" height="16" % imgsize dot.gif dash.gif dot.gif: width="16" height="16" dash.gif: width="32" height="8" OPTIONS
By default, the width and height are returned as attributes for an IMG tag in HTML, essentially "width="40" height="30"" or similar. The following options may be used to return alternate formats (all report width first, then height): "-r" Return "raw" format data. Just the numbers separated by a single space. "-a" Return a Perl-style list of attributes suitable for passing to the "img()" method of the CGI module (see CGI). "-f" fmt Pass the string specified in fmt to "sprintf" and thus use it to format the results to your taste. "sprintf" will be passed two numbers, so any other formatting directives will be lost. The numbers are passed as width first, then height. EXIT STATUS
imgsize always exits BUGS
Please report any bugs or feature requests to "bug-image-size at rt.cpan.org", or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Image-Size <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Image-Size>. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes. SUPPORT
o RT: CPAN's request tracker http://rt.cpan.org/NoAuth/Bugs.html?Dist=Image-Size <http://rt.cpan.org/NoAuth/Bugs.html?Dist=Image-Size> o AnnoCPAN: Annotated CPAN documentation http://annocpan.org/dist/Image-Size <http://annocpan.org/dist/Image-Size> o CPAN Ratings http://cpanratings.perl.org/d/Image-Size <http://cpanratings.perl.org/d/Image-Size> o Search CPAN http://search.cpan.org/dist/Image-Size <http://search.cpan.org/dist/Image-Size> o Project page on GitHub http://github.com/rjray/image-size <http://github.com/rjray/image-size> LICENSE AND COPYRIGHT
Copying and distribution are permitted under the terms of the Artistic License 2.0 (http://www.opensource.org/licenses/artistic-license-2.0.php <http://www.opensource.org/licenses/artistic-license-2.0.php>) or the GNU LGPL 2.1 (http://www.opensource.org/licenses/lgpl-2.1.php <http://www.opensource.org/licenses/lgpl-2.1.php>). SEE ALSO
Image::Size AUTHOR
Randy J. Ray "<rjray@blackperl.com>". perl v5.14.2 2012-06-08 IMGSIZE(1p)