Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: convert rows (with spaces) to columns
Top Forums Shell Programming and Scripting convert rows (with spaces) to columns Post 302454281 by Scott on Friday 17th of September 2010 01:40:18 PM
Old 09-17-2010
If your data is fixed exactly like that, then:

Code:
$ cut -c17- file1 | paste - - - - 
00:24:00:2C:00:76 [mode 1, clkoffset 0x27bc]	Nokia Test 0	Phone, Cellular (0x5a0204)	
00:24:00:FB:00:9C [mode 1, clkoffset 0x3a75]	Nokia Test 1	Phone, Cellular (0x5a0204)	
6C:00:02:00:97:00 [mode 1, clkoffset 0x324a]	Nokia Test	Phone, Cellular (0x520204)

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert Columns to Rows in a File

Hi I have a input file in the format ABC,111,2008Q2, 49K ABC,111,2008Q3, 0K ABC,111,2008Q4, 0K ABC,222,2008Q2, 49K ABC,222,2008Q3, 0K ABC,222,2008Q4, 0K XYZ,111,2008Q2, 49K XYZ,111,2008Q3, 0K XYZ,111,2008Q4, 0K XYZ,222,2008Q2, 49K XYZ,222,2008Q3, 0K XYZ,222,2008Q4, 0K The output file... (3 Replies)
Discussion started by: chrismt
3 Replies

2. Shell Programming and Scripting

how to convert columns to rows

Hi, I need a shell script for below requirement Input file P1 - 173310 P2 - 173476 P3 - 173230 P4 - 172737 P1 - 173546 P2 - 173765 P3 - 173876 P4 - 172989 Out put file P1 173310 173546 P2 173476 173765 P3 173230 173876 P4 172737 172989 Suresh (6 Replies)
Discussion started by: suresh3566
6 Replies

3. Shell Programming and Scripting

convert rows into columns

Hi guys Could anyone advise me how to convert my rows into columns from a file My file would be similar to this: A11 A12 A13 A14 A15 ... A1n A21 A22 A23 A31 A41 A51 ... Am1 Am2 Am3 Am4 Am5 ... Amn The number of rows is not the same to the number of columns Thanks in advance (2 Replies)
Discussion started by: loperam
2 Replies

4. Shell Programming and Scripting

convert columns into rows

hi, Apologies if this has been covered. I have requirement where i have to convert a single column into multiple column. My data will be like this - 2 3 4 5 6 Output required - 2 3 4 5 6 (1 Reply)
Discussion started by: Nishithinfy
1 Replies

5. Shell Programming and Scripting

convert rows to columns

hi, i have the file as below: abc def ghi jkl i want the output as abc,def,ghi,jki please reply, Thanks (4 Replies)
Discussion started by: namitai
4 Replies

6. Shell Programming and Scripting

Convert few columns to rows

Hi! Does anybody help me in converting following data: INPUT looks like this: 20. 100. 30 200. 40. 400. 50. 100. 60. 200. 70. 400. 80. 200. 150. 210. 30. 100. OUTPUT should look like this: 20. 100. 30 200. 40. 400. 50. 100. 60. 200. 70.... (5 Replies)
Discussion started by: lovelinux
5 Replies

7. Shell Programming and Scripting

How to Convert rows in to columns?

Hi Gurus, How to convert rows in to columns using linux shell scripting Input is like (sample.txt) ABC DEF GHI JKL MNO PQR STU VWX YZA BCD output should be (sampleoutput.csv) ABC,DEF,GHI,JKL,MNO PQR,STU,VWX,YZA,BCD (2 Replies)
Discussion started by: infasriniit
2 Replies

8. Shell Programming and Scripting

Convert Rows to Columns

Hi Everyone, Could someone shed some lights on how to convert the records in rows form into column basis. 172.29.59.12 IBM,8255-E8B 102691P 8 65536 MB 6100-04-11-1140 172.29.59.15 IBM,8255-E8B 102698P 4 45056 MB 6100-04-11-1140 IP SYS MODEL ... (6 Replies)
Discussion started by: ckwan
6 Replies

9. Shell Programming and Scripting

Convert rows to columns

I am looking to print the data in columns and after every 3 words it should be a new row. cat example.out | awk 'END { for (i = 0; ++i < m;) print _;print _ }{ _ = _ x ? _ OFS $1 : $1}' m=1| grep -i INNER I am looking to print in a new line after every 3 words. ... (2 Replies)
Discussion started by: lazydev
2 Replies

10. Shell Programming and Scripting

Convert rows to columns

hi folks, I have a sample data like what is shown below: 1,ID=1000 1,Org=CedarparkHospital 1,cn=john 1,sn=doe 1,uid=User001 2,uid=User002 2,ID=2000 2,cn=steve 2,sn=jobs 2,Org=Providence I would like to convert it into the below format: 1,1000,CedarparkHospital,john,doe,User001... (11 Replies)
Discussion started by: vskr72
11 Replies

LEARN ABOUT FREEBSD

uplcom

UPLCOM(4)						   BSD Kernel Interfaces Manual 						 UPLCOM(4)

NAME

     uplcom -- USB support for Prolific PL-2303/2303X/2303HX serial adapters driver

SYNOPSIS

     To compile this driver into the kernel, place the following lines in your kernel configuration file:

	   device usb
	   device ucom
	   device uplcom

     Alternatively, to load the driver as a module at boot time, place the following line in loader.conf(5):

	   uplcom_load="YES"

DESCRIPTION

     The uplcom driver provides support for various serial adapters based on the Prolific PL-2303, PL-2303X and PL-2303HX USB-to-RS232 Bridge
     chips.

     The device is accessed through the ucom(4) driver which makes it behave like a tty(4).

HARDWARE

     The uplcom driver supports the following devices and adapters:

     o	 ADLINK ND-6530 USB-Serial Adapter
     o	 Alcatel One Touch 535/735 Phone
     o	 Alcor AU9720 USB-RS232 Serial Adapter
     o	 AlDiga AL-11U Modem
     o	 Alltronix ACM003U00 Modem
     o	 Anchor Serial adapter
     o	 ATEN UC-232A
     o	 BAFO BF-800 and BF-810
     o	 Belkin F5U257
     o	 BenQ S81 Phone
     o	 Corega CG-USBRS232R Serial Adapter
     o	 Cressi Edy (Seiko) Diving Computer
     o	 ELECOM UC-SGT Serial Adapter
     o	 HAL Corporation Crossam2+USB IR commander
     o	 Hama USB RS-232 Serial Adapter
     o	 Hamlet exagerate XURS232
     o	 HP LD220 Point-Of-Sale (POS) Display
     o	 IOGEAR UC-232A
     o	 I/O DATA USB-RSAQ, USB-RSAQ2, USB-RSAQ3 and USB-RSAQ5
     o	 iTegno WM1080A GSM/GFPRS Modem
     o	 iTegno WM2080A CDMA Modem
     o	 Leadtek 9531 GPS
     o	 Micromax 610U Modem
     o	 Microsoft Palm 700WX
     o	 Mobile Action MA-620 Infrared Adapter
     o	 Motorola Cables
     o	 Nokia CA-42 Cable
     o	 OTI DKU-5 cable
     o	 Panasonic TY-TP50P6-S flat screen
     o	 PLX CA-42 Phone Cable
     o	 PLANEX USB-RS232 URS-03
     o	 Prolific Generic USB-Serial Adapters
     o	 Prolific Pharos USB-Serial Adapter
     o	 RATOC REX-USB60
     o	 Radio Shack USB Serial Cable
     o	 Sagem USB-Serial Adapter
     o	 Samsung I330 Phone Cradle
     o	 Sandberg USB to Serial Link (model number 133-08)
     o	 Sanwa KB-USB2 Multimeter cable
     o	 Siemens/BenQ EF81, SX1, X65 and X75 Mobile Phones
     o	 Sitecom USB-Serial Adapter
     o	 SMART Technologies USB-Serial Adapter
     o	 Sony QN3 Phone Cable
     o	 Sony Ericsson Datapilot
     o	 Sony Ericsson DCU-10 and DCU-11 (Susteen) USB Cables
     o	 SOURCENEXT KeikaiDenwa 8 (with and without charger)
     o	 Speed Dragon USB-Serial Cable
     o	 Syntech CPT-8001C Barcode Scanner
     o	 TDK UHA6400 and UPA9664 USB-PHS Adapters
     o	 TRENDnet USB to Serial Converter (TU-S9)
     o	 Tripp-Lite U209-000-R USB-Serial Adapter
     o	 UIC HCR331 Magnetic Stripe Card Reader
     o	 UIC MSR206 Magnetic Stripe Card Reader
     o	 Willcom W-SIM DD PHS terminal.(WS002IN)
     o	 YC-Cable USB-Serial Adapter
     o	 Zeagle N2iTion3 Diving Computer

SEE ALSO

     tty(4), ucom(4), usb(4)

HISTORY

     The uplcom driver appeared in NetBSD 1.6.	This manual page was adopted from NetBSD by Tom Rhodes <trhodes@FreeBSD.org> in April 2002.

BSD
								   July 25, 2012							       BSD
All times are GMT -4. The time now is 03:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy