Sponsored Content
Top Forums UNIX for Dummies Questions & Answers [Solved] How to swap PIPE seperator delimiter? Post 302796597 by hanson44 on Friday 19th of April 2013 10:48:08 PM
Old 04-19-2013
Yes, you have to specify the field separator to be the pipe:
Code:
$ awk 'BEGIN { FS=OFS="|" } { t=$3; $3=$4; $4=t; print }' input
1|4|OLAP|OR|INT|INT||CONSTANT|2012/08/07|9999/12/31|0|0|0|0|PRL|-358.1684563||||||||||36522|55791|LNR|
2|4|OLAP|OR|CLR|CLR||CONSTANT|2012/09/07|9999/12/31|0|0|0|0|PRL|-358.1684563||||||||||36522|57891|REGS|
11|5|MRD|S1|RMPLT|RMPLT||CONSTANT|2012/09/07|9999/12/31|0|0|0|0|PRL|-358.1684563||||||||||36524|57921|PDR|
411|5|MRD|S1|PRDLP|PRDLP||CONSTANT|2012/08/07|9999/12/31|0|0|0|0|PRL|-358.1684563||||||||||36542|57391|PDR|

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Cutting a portion of a line seperated by pipe delimiter

Hi, In the below line a|b|10065353|tefe|rhraqs|135364|5347575 dgd|rg|4333|fhra|grhrt|46423|urdsgd Here i want to cut the characters in between the second and third pipe delimiter and then between fifth and sixth delimiter and retain the rest of the line. My output should be ... (3 Replies)
Discussion started by: ragavhere
3 Replies

2. UNIX for Dummies Questions & Answers

replacing space with pipe(delimiter)

Hello All, I have a file with thousands of records: eg: |000222|123456987|||||||AARONSON| JOHN P|||PRIMARY |P |000111|567894521|||||||ATHENS| WILLIAM k|||AAAA|L Expected: |000222|123456987|||||||AARONSON| JOHN |P|||PRIMARY |P |000111|567894521|||||||ATHENS| WILLIAM |k|||AAAA|L I... (6 Replies)
Discussion started by: OSD
6 Replies

3. Hardware

[Solved] Boot Lockup After Drive Swap

Hey All, Im using Fedora 2.6 (which is cannot be changed for compatibility reasons). I cloned a drive from a different server and when i added this drive to a new box, during startup it hangs on "Configuring Kernel Parameters:" Is there any way to bypass this process and still boot... (0 Replies)
Discussion started by: robfwauk
0 Replies

4. Shell Programming and Scripting

[Solved] How to use delimiter

Hi, I am using below script to get the below given output. But i am wondering how to pick the names from below output. Script: echo "dis ql(*) cluster(CT.CL.RIBRSBT3)"| runmqsc CT.QM.701t8|egrep QUEUE|sed -e 's/QUEUE(/ /'|sed -e 's/)/ /' Output: ... (10 Replies)
Discussion started by: darling
10 Replies

5. Shell Programming and Scripting

[Solved] Insert tabs as delimiter

Hello all, I have an unstructured file with space as delimiter , which I want to structure. The output file should actually have only 5 columns with tab as delimiter. The 4th column can have only 3 values ( biological_process , cellular_component , molecular_function ) Here is how the... (12 Replies)
Discussion started by: ritakadm
12 Replies

6. Red Hat

Converting fixed width file to pipe delimiter in Linux(red-hat)

Hi, I am facing a typical scenario for AWK command . In HP- UNIX is behave as expected but in red hat linux same awk code is not give the same result. The below code is for convert the fixed width file to pipe delimiter file in HP-unix server. awk code: #!/bin/awk -f NR!=1... (11 Replies)
Discussion started by: brij_abhi
11 Replies

7. Shell Programming and Scripting

Removing duplicate lines on first column based with pipe delimiter

Hi, I have tried to remove dublicate lines based on first column with pipe delimiter . but i ma not able to get some uniqu lines Command : sort -t'|' -nuk1 file.txt Input : 38376KZ|09/25/15|1.057 38376KZ|09/25/15|1.057 02006YB|09/25/15|0.859 12593PS|09/25/15|2.803... (2 Replies)
Discussion started by: parithi06
2 Replies

8. Shell Programming and Scripting

Problem in using cut command with pipe as a delimiter while using in a script

There is a text file in my project named as "mom.txt" in which i want to have contents like.................. LSCRM(Application Name): 1: This is my first application. 2: Today we did shell scripting automation for this app. 3: It was really a good fun in doing so. 4: Really good.| (Here i... (7 Replies)
Discussion started by: Abhijeet Anand
7 Replies

9. Shell Programming and Scripting

Replace CRLF between pipe (|) delimiter with LF

Hi Folks! Need a solution for the following :- Source data ------------- 123|123|<CRLF><CRLF><CRLF>|321<CRLF> Required output ------------------ 123|123|<LF><LF><LF>|321<CRLF> <CRLF> represents carriage return <LF> represents line feed Being hunting high and low for a... (10 Replies)
Discussion started by: hishamzz
10 Replies

10. Shell Programming and Scripting

Replace delimiter for a particular column in a pipe delimited file

I have an input file as below Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber 1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000 Output : 1234|FirstName1|MiddleName2|LastName3| Add1 ,, ADD2|123|000000000 OR 1234,FirstName1,MiddleName2,LastName3, Add1 ||... (2 Replies)
Discussion started by: styris
2 Replies
apache_mod_perl-108~358::mod_perl-2.0.7::docs::api::APR:UserDContributed Perl Docuapache_mod_perl-108~358::mod_perl-2.0.7::docs::api::APR::UUID(3)

NAME
APR::UUID - Perl API for manipulating APR UUIDs Synopsis use APR::UUID (); # get a random UUID and format it as a string my $uuid = APR::UUID->new->format; # $uuid = e.g. 'd48889bb-d11d-b211-8567-ec81968c93c6'; # same as the object returned by APR::UUID->new my $uuid_parsed = APR::UUID->parse($uuid); Description "APR::UUID" is used to get and manipulate random UUIDs. It allows you to "create" random UUIDs, which when "formatted" returns a string like: 'd48889bb-d11d-b211-8567-ec81968c93c6'; which can be parsed back into the "APR::UUID" object with "parse()". API
"APR::UUID" provides the following functions and/or methods: "format" Convert an "APR::UUID object" object into a string presentation: my $uuid_str = $uuid->format; obj: $uuid ( "APR::UUID object" ) ret: $uuid_str returns a string representation of the object (.e.g 'd48889bb-d11d-b211-8567-ec81968c93c6'). since: 2.0.00 "new" Create a "APR::UUID object" using the random engine: my $uuid = APR::UUID->new; class: "APR::UUID" ( "APR::UUID class" ) ret: $uuid ( "APR::UUID object" ) since: 2.0.00 "DESTROY" $uuid->DESTROY; obj: "APR::UUID" ( "APR::UUID object" ) ret: no return value since: 2.0.00 Do not call this method, it's designed to be only called by Perl when the variable goes out of scope. If you call it yourself you will get a segfault when perl will call DESTROY on its own. "parse" Convert a UUID string into an "APR::UUID object" object: $uuid = APR::UUID->parse($uuid_str) arg1: $uuid_str (string) UUID string (.e.g 'd48889bb-d11d-b211-8567-ec81968c93c6') ret: $uuid ( "APR::UUID object" ) The new object. since: 2.0.00 See Also mod_perl 2.0 documentation. Copyright mod_perl 2.0 and its core modules are copyrighted under The Apache Software License, Version 2.0. Authors The mod_perl development team and numerous contributors. perl v5.16.2 2011-02-07 apache_mod_perl-108~358::mod_perl-2.0.7::docs::api::APR::UUID(3)
All times are GMT -4. The time now is 01:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy