Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Split 1 column into numerous columns based on patterns Post 302957575 by mmab on Tuesday 13th of October 2015 04:58:35 AM
Old 10-13-2015
Here is a cleaned up version of the input file showing how each field can have an undefined amount of data;

Code:
 
"NEW PRODUCT, VERSION 1.1"
PRODUCT_01
"PRODUCT FIELD"
FIELD_X
11.11
11.22
11.33
11.44
"PRODUCT FIELD"
FIELD_Y
22.22
22.33
"NEW PRODUCT, VERSION 1.1"
PRODUCT_02
"PRODUCT FIELD"
FIELD_X
33.33
"PRODUCT FIELD"
FIELD_Y
44.44
"PRODUCT FIELD"
FIELD_Z
55.55

Desired output like so;

Code:
 
"NEW PRODUCT, VERSION 1.1"
PRODUCT_01
FIELD_X  FIELD_Y
11.11      22.22
11.22      22.33
11.33      
11.44
       
"NEW PRODUCT, VERSION 1.1"
PRODUCT_02
FIELD_X  FIELD_Y  FIELD_Z
33.33      44.44     55.55

The version of awk I'm using is 3.1.5.

Thanks

Last edited by mmab; 10-13-2015 at 06:05 AM..
 

10 More Discussions You Might Find Interesting

1. Web Development

split the fields in a column into 3 columns

Have a column "address" which is combination of city, region and postal code like. Format is : city<comma><space>region<space>postal code abc, xyz 123456 All these three city, region and postal code are not mandatory. There can be any one of the above. In that case a nell... (2 Replies)
Discussion started by: rakshit
2 Replies

2. UNIX for Dummies Questions & Answers

split one column into multiple columns

hey guys... Im looking to do the following: 1 2 3 4 5 6 7 8 9 Change to: 1 4 7 2 5 8 3 6 9 Did use | perl -lpe'$\=$.%3?$":"\n"' , but it doesnt give me the matrix i want. (3 Replies)
Discussion started by: zaneded
3 Replies

3. Shell Programming and Scripting

split one column into multiple columns

hey, i have the following data: 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 (7 Replies)
Discussion started by: zaneded
7 Replies

4. Shell Programming and Scripting

Split into columns based on the parameter and use & as delimiter

Here is my source, i have million lines like this on a file. disp0201.php?poc=4060&roc=1&ps=R&ooc=13&mjv=6&mov=5&rel=5&bod=155&oxi=2&omj=5&ozn=1&dav=20&cd=&daz=& drc=&mo=&sid=&lang=EN&loc=JPN I want to split this into columns in order to load in database, anything starts with"&mjv=6" as first... (13 Replies)
Discussion started by: elamurugu
13 Replies

5. Shell Programming and Scripting

Split the file based on column

Hi, I have a file sample_1.txt (300k rows) which has data like below: * Also each record is around 64k bytes 11|1|abc|102553|125589|64k bytes of data 10|2|def|123452|123356|...... 13|2|geh|144351|121123|... 25|4|fgh|165250|118890|.. 14|1|abc|186149|116657|......... (6 Replies)
Discussion started by: sol_nov
6 Replies

6. UNIX for Dummies Questions & Answers

Split file based on column

i have file1.txt asdas|csada|130310|0423|A1|canberra sdasd|sfdsf|130426|2328|A1|sydney Expected output : on eaceh third and fourth colum, split into each two characters asdas|csada|13|03|10|04|23|A1|canberra sdasd|sfdsf|13|04|26|23|28|A1|sydney (10 Replies)
Discussion started by: radius
10 Replies

7. Shell Programming and Scripting

awk to sum a column based on duplicate strings in another column and show split totals

Hi, I have a similar input format- A_1 2 B_0 4 A_1 1 B_2 5 A_4 1 and looking to print in this output format with headers. can you suggest in awk?awk because i am doing some pattern matching from parent file to print column 1 of my input using awk already.Thanks! letter number_of_letters... (5 Replies)
Discussion started by: prashob123
5 Replies

8. UNIX for Dummies Questions & Answers

File merging based on column patterns

Hello :) I am in this situation: Input: two tab-delimited files, `File1` and `File2`. `File2` (`$2`) has to be parsed by patterns found in `File1` (`$1`). Expected output: tab-delimited file, `File3`. `File3` has to contain the same rows as `File2`, plus the corresponding value in... (5 Replies)
Discussion started by: dovah
5 Replies

9. UNIX for Beginners Questions & Answers

How to split a column based on |?

Hi all, Newbie here, so please bear over with my stupid question :) I have used far too long time today on figuring this out, so I hope that someone here can help me move on. I have some annotation data for a transcriptome where I want to split a column containing NCBI accession IDs into a... (7 Replies)
Discussion started by: BioBing
7 Replies

10. UNIX for Beginners Questions & Answers

Using awk to split a column into two columns

Hi, I am trying to split the following output into two columns, where each column has Source: Destination: OUTPUT TO FILTER $ tshark -r Capture_without_mtr.pcap -V | awk '/ (Source|Destination): /' | more Source: x.x.x.x Destination: x.x.x.x Source:... (2 Replies)
Discussion started by: sand1234
2 Replies
DFU-UTIL(1)						      General Commands Manual						       DFU-UTIL(1)

NAME
dfu-util - Device firmware update (DFU) USB programmer SYNOPSIS
dfu-util [-ldpciatUDRhvV] DESCRIPTION
dfu-util is a program that implements the host (computer) side of the USB DFU (Universal Serial Bus Device Firmware Upgrade) protocol. In the OpenMoko project (for example), this program is used to communicate with the specially enhanced u-boot boot loader, which implements the DFU device side. OPTIONS
-l, --list List the currently attached DFU capable USB devices. -d, --device VENDOR:PRODUCT Specify vendor/product ID of the DFU device. Both VENDOR and PRODUCT are hexadecimal numbers (no prefix needed). Example: $ dfu-util --device 1457:51ab If you only have one standards-compliant DFU device attached to your PC, this is optional. However, as soon as you have multiple DFU devices, dfu-util will detect this and abort, asking you to specify which device it shall use. -p, --path BUS-PORT. ... .PORT Specify the path to the DFU device. -c, --cfg CONFIG-NR Specify the configuration of the DFU device. -i, --intf INTF-NR Specify the DFU interface number. -a, --alt ALT Specify the altsetting of the DFU interface by name or by number. -t, --transfer-size Specify the number of bytes per USB transfer. If you don't supply this option, the maximum possible size for your combination of host OS and USB device is chosen (for optimal performance). -U, --upload FILE Read firmware from device into FILE. Note: Upload support is currently broken. -D, --download FILE Write firmware from FILE into device. -R, --reset Issue USB reset signalling once we are finished. -s, --dfuse-address Specify target address for raw binary download/upload on DfuSe devices. Do not use this for downloading DfuSe files. -h, --help Show a help text and exit. -v, --verbose Print more information about dfu-util's operation. A second -v will turn on verbose logging of USB requests. -V, --version Show version information and exit. EXAMPLES
Here are some examples for the usage of dfu-util in the OpenMoko project (working with the Neo1973 hardware): Flashing the rootfs: $ dfu-util -a rootfs -R -D /path/to/openmoko-devel-image.jffs2 Flashing the kernel: $ dfu-util -a kernel -R -D /path/to/uImage Flashing the bootloader: $ dfu-util -a u-boot -R -D /path/to/u-boot.bin Copying a kernel into RAM: $ dfu-util -a 0 -R -D /path/to/uImage Once this has finished, the kernel will be available at the default load address of 0x32000000 in Neo1973 RAM. Note: You cannot transfer more than 2MB of data into RAM using this method. BUGS
Please see http://wiki.openmoko.org/wiki/Dfu-util for some limitations and bugs in the current dfu-util code. Please report any further bugs at on the openmoko mailing list at openmoko@lists.openmoko.org. LICENCE
dfu-util is covered by the GNU General Public License (GPL), version 2 or later. AUTHORS
Weston Schmidt <weston_schmidt@yahoo.com> Harald Welte <hwelte@hmw-consulting.de> This manual page was written by Uwe Hermann <uwe@hermann-uwe.de>. It is licensed under the terms of the GNU GPL (version 2 or later). February 29, 2008 DFU-UTIL(1)
All times are GMT -4. The time now is 02:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy