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
Old 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.

Joining Columnar heading from 2 lines-source_reportpng

I want to convert the values to a PIPE delimited format as below

Joining Columnar heading from 2 lines-targetpng

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
Joining Columnar heading from 2 lines-source_reportpng
Joining Columnar heading from 2 lines-targetpng
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Joining 2 lines in a file together

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

Joining lines from two files - please help

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

Conditionally joining lines in vi

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

joining 2 lines into single one

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

joining two lines

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

Need help joining lines

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

pattern matching lines using the date, and then joining the lines

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

Joining broken lines

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

Joining lines in different way

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

Joining broken lines and removing empty lines

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
GETIMAGESIZE(3) 							 1							   GETIMAGESIZE(3)

getimagesize - Get the size of an image

SYNOPSIS
array getimagesize (string $filename, [array &$imageinfo]) DESCRIPTION
The getimagesize(3) function will determine the size of any given image file and return the dimensions along with the file type and a height/width text string to be used inside a normal HTML<IMG> tag and the correspondant HTTP content type. getimagesize(3) can also return some more information in $imageinfo parameter. Note Note that JPC and JP2 are capable of having components with different bit depths. In this case, the value for "bits" is the highest bit depth encountered. Also, JP2 files may contain multiple JPEG 2000 codestreams. In this case, getimagesize(3) returns the values for the first codestream it encounters in the root of the file. Note The information about icons are retrieved from the icon with the highest bitrate. PARAMETERS
o $filename - This parameter specifies the file you wish to retrieve information about. It can reference a local file or (configuration per- mitting) a remote file using one of the supported streams. o $imageinfo - This optional parameter allows you to extract some extended information from the image file. Currently, this will return the different JPG APP markers as an associative array. Some programs use these APP markers to embed text information in images. A very common one is to embed IPTC information in the APP13 marker. You can use the iptcparse(3) function to parse the binary APP13 marker into something readable. RETURN VALUES
Returns an array with up to 7 elements. Not all image types will include the channels and bits elements. Index 0 and 1 contains respectively the width and the height of the image. Note Some formats may contain no image or may contain multiple images. In these cases, getimagesize(3) might not be able to properly determine the image size. getimagesize(3) will return zero for width and height in these cases. Index 2 is one of the IMAGETYPE_XXX constants indicating the type of the image. Index 3 is a text string with the correct height="yyy" width="xxx" string that can be used directly in an IMG tag. mime is the correspondant MIME type of the image. This information can be used to deliver images with the correct HTTP Content-type header: Example #1 getimagesize(3) and MIME types <?php $size = getimagesize($filename); $fp = fopen($filename, "rb"); if ($size && $fp) { header("Content-type: {$size['mime']}"); fpassthru($fp); exit; } else { // error } ?> channels will be 3 for RGB pictures and 4 for CMYK pictures. bits is the number of bits for each color. For some image types, the presence of channels and bits values can be a bit confusing. As an example, GIF always uses 3 channels per pixel, but the number of bits per pixel cannot be calculated for an animated GIF with a global color table. On failure, FALSE is returned. ERRORS
/EXCEPTIONS If accessing the $filename image is impossible getimagesize(3) will generate an error of level E_WARNING. On read error, getimagesize(3) will generate an error of level E_NOTICE. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.3.0 | | | | | | | Added icon support. | | | | | 5.2.3 | | | | | | | Read errors generated by this function down- | | | graded to E_NOTICE from E_WARNING. | | | | | 4.3.2 | | | | | | | Support for JPC, JP2, JPX, JB2, XBM, and WBMP | | | became available. | | | | | 4.3.2 | | | | | | | JPEG 2000 support was added for the $imageinfo | | | parameter. | | | | | 4.3.0 | | | | | | | | | | bits and channels are present for other image | | | types, too. | | | | | 4.3.0 | | | | | | | | | | mime was added. | | | | | 4.3.0 | | | | | | | Support for SWC and IFF was added. | | | | | 4.2.0 | | | | | | | Support for TIFF was added. | | | | | 4.0.6 | | | | | | | Support for BMP and PSD was added. | | | | | 4.0.5 | | | | | | | URL support was added. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #2 getimagesize(3) example <?php list($width, $height, $type, $attr) = getimagesize("img/flag.jpg"); echo "<img src="img/flag.jpg" $attr alt="getimagesize() example" />"; ?> Example #3 getimagesize (URL) <?php $size = getimagesize("http://www.example.com/gifs/logo.gif"); // if the file name has space in it, encode it properly $size = getimagesize("http://www.example.com/gifs/lo%20go.gif"); ?> Example #4 getimagesize() returning IPTC <?php $size = getimagesize("testimg.jpg", $info); if (isset($info["APP13"])) { $iptc = iptcparse($info["APP13"]); var_dump($iptc); } ?> NOTES
Note This function does not require the GD image library. SEE ALSO
image_type_to_mime_type(3), exif_imagetype(3), exif_read_data(3), exif_thumbnail(3). PHP Documentation Group GETIMAGESIZE(3)
All times are GMT -4. The time now is 04:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy