Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shuffle Columns in Pipe delimited data
Top Forums Shell Programming and Scripting Shuffle Columns in Pipe delimited data Post 302934644 by BrahmaNaiduA on Monday 9th of February 2015 03:33:12 PM
Old 02-09-2015
Shuffle Columns in Pipe delimited data
My sample data contains escape characters followed by delimiter. I'm stuck in writing awk comand to swap the columns. please help me out.

Code:
Sample Data: 12345678|ABN\|XYZ MED CHEM PTY. LTD.|C||100.00|22|AB"C\|Corp|"XYZ|CDEF"|

Expected Output Data: 12345678|C|ABN\|XYZ MED CHEM PTY. LTD.|22|AB"C\|Corp||100.00|"XYZ|CDEF"|

Thanks,
Brahma
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Search for & edit rows & columns in data file and pipe

Dear unix gurus, I have a data file with header information about a subject and also 3 columns of n rows of data on various items he owns. The data file looks something like this: adam peter blah blah blah blah blah blah car 01 30 200 02 31 400 03 57 121 .. .. .. .. .. .. n y... (8 Replies)
Discussion started by: tintin72
8 Replies

2. Shell Programming and Scripting

Help with converting Pipe delimited file to Tab Delimited

I have a file which was pipe delimited, I need to make it tab delimited. I tried with sed but no use cat file | sed 's/|//t/g' The above command substituted "/t" not tab in the place of pipe. Sample file: abc|123|2012-01-30|2012-04-28|xyz have to convert to: abc 123... (6 Replies)
Discussion started by: karumudi7
6 Replies

3. Shell Programming and Scripting

Remove few columns from pipe delimited file

I have file as below column1|column2|column3|column4|column5| fill1|fill2|fill3|fill4|fill5| abc1|abc2|abc3|abc4|abc5| . . . . i need to remove column2,3, from that file column1|column4|column5| fill1|fill4|fill5| abc1|abc4|abc5| . . . (3 Replies)
Discussion started by: greenworld123
3 Replies

4. Shell Programming and Scripting

How to ignore Pipe in Pipe delimited file?

Hi guys, I need to know how i can ignore Pipe '|' if Pipe is coming as a column in Pipe delimited file for eg: file 1: xx|yy|"xyz|zzz"|zzz|12... using below awk command awk 'BEGIN {FS=OFS="|" } print $3 i would get xyz But i want as : xyz|zzz to consider as whole column... (13 Replies)
Discussion started by: rohit_shinez
13 Replies

5. Shell Programming and Scripting

Oracle table extract: all columns are not converting into pipe delimited in flat file

Hi All, I am writing a shell script to extract oracle table into a pipe dilemited flat file. Below is my code and I have attached two files that I have abled to generate so far. 1. Table.txt ==> database extract file 2. flat.txt ==> pipe delimited after some manipulation of the original db... (5 Replies)
Discussion started by: express14
5 Replies

6. Shell Programming and Scripting

Insert empty columns inside a pipe delimited file

Hi All , I have pipe delimiter file with 11 columns . I need to insert 4 empty columns after column 10 . and After 11 column I need to insert a column which is having the same value for all the rows . My file 1|2|3|4|5|6|7|8|9|10|11 New file ... (11 Replies)
Discussion started by: Hypesslearner
11 Replies

7. UNIX for Dummies Questions & Answers

Need to convert a pipe delimited text file to tab delimited

Hi, I have a rquirement in unix as below . I have a text file with me seperated by | symbol and i need to generate a excel file through unix commands/script so that each value will go to each column. ex: Input Text file: 1|A|apple 2|B|bottle excel file to be generated as output as... (9 Replies)
Discussion started by: raja kakitapall
9 Replies

8. Shell Programming and Scripting

Transpose comma delimited data in rows to columns

Hello, I have a bilingual database with the following structure a,b,c=d,e,f The right half is in a Left to right script and the second is in a Right to left script as the examples below show What I need is to separate out the database such that the first word on the left hand matches the first... (4 Replies)
Discussion started by: gimley
4 Replies

9. Shell Programming and Scripting

How to shuffle odd and even columns?

Is there any way to place each even column name infront of its odd column using awk or others? input Ab name MGH26 B04 MGH26 B05 output name_Ab B04_MGH26 B05_MGH26 (4 Replies)
Discussion started by: quincyjones
4 Replies

10. Shell Programming and Scripting

How to remove new line characters from data rows in a Pipe delimited file?

I have a file as below Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber 1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000 2345|FirstName2|MiddleName3|LastName4| Add1 || ADD2| 234|000000000 OUTPUT : ... (1 Reply)
Discussion started by: styris
1 Replies

LEARN ABOUT DEBIAN

lldptool-med

lldptool(8)							       Linux							       lldptool(8)

NAME

       LLDP-MED - Show / manipulate MED TLV configurations

SYNOPSIS

       lldptool -t -i ethx -V [ TLV_TYPE ] enableTx

       lldptool -T -i ethx -V [ TLV_TYPE ] enableTx = { yes | no }

       lldptool -T -i ethx -V LLDP-MED devtype = { class1 | class2 | class3 }

       lldptool -t -i ethx -V LLDP-MED devtype

TLV_TYPE : = {LLDP-MED | medCap | medPolicy | medLoc | medPower | medHwRev | medFwRev | medSwRev | medSerNum | medManuf | medModel | medAssetID }

DESCRIPTION

       The  LLDP-MED  extensions  support the Link Layer Discovery Protocol for Media Endpoint Devices defined in the ANSI/TIA-1057-2006 document.
       Each TLV can be configured as a class1 , class2 or class3 device. Class I devices are the most basic class of  Endpoint	Device,  Class	II
       devices support media stream capabilities and Class III devices directly support end users of the IP communication system. See ANS-TIA-1057
       for clarification of class types.

ARGUMENTS

       enableTx
	      Enables the TLV to be transmitted

       devtype
	      Set or query the class type of the device.

TLV_TYPE
       List of supported TLV specifiers applicable to Media Endpoint Devices.

       LLDP-MED
	      apply arguments to all supported MED TLVs.

       medCAP LLDP-MED Capabilities TLV

       medPolicy
	      LLDP-MED Network Policy TLV

       medLoc LLDP-MED Location TLV

       medPower
	      LLDP-MED Extended Power-via-MDI TLV

       medHwRev
	      LLDP-MED Hardware Revision TLV

       medFwRev
	      LLDP-MED Firmware Revision TLV

       medSwRev
	      LLDP-MED Software Revision TLV

       medSerNum
	      LLDP-MED Serial Number TLV

       medManuf
	      LLDP-MED Manufacturer Name TL

       medModel
	      LLDP-MED Model Name TLV

       medAssetID
	      LLDP-MED Asset ID TLV

EXAMPLE &; USAGE
       Enable class1 MED device on eth2
	      lldptool -T -i eth2 -V LLDP-MED enableTx=yes devtype=class1

       Query class type of MED on eth2
	      lldptool -t -i eth2 -V LLDP-MED -c devtype

       Query transmit state of medPolicy on device eth2
	      lldptool -t -i eth2 -V medPolicy -c enableTx

       SOURCE

       o      Link  Layer  Discovery  Protocol	for  Media  Endpoint  Devices  (http://www.tiaonline.org/standards/technology/voip/documents/ANSI-
	      TIA-1057_final_for_publication.pdf)

NOTES

SEE ALSO

       lldptool(8), lldpad(8)

AUTHOR

       John Fastabend

open-lldp							     June 2011							       lldptool(8)
All times are GMT -4. The time now is 04:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy