Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Swapping of fields in file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Swapping of fields in file
# 1  
Old 09-22-2012
Swapping of fields in file
Hi Friends ,

I have file1.txt

Code:
1|b|46|123|47673|348738
2|c|63|124|7346|4783
3|y|45|125|5555|78789

output should swap the 4th field to the first field.

output

Code:
123|1|b|46|47673|348738
124|2|c|63|7346|4783
125|3|y|45|5555|78789

I am newbie to shell . plz help

Moderator's Comments:
Mod Comment Please use code tags instead of quote tags
Last edited by Scrutinizer; 09-22-2012 at 07:28 AM.. Reason: Please use code tags instead of quote tags
# 2  
Old 09-22-2012
Try..

Code:
awk -F\| '{print $4,$1,$2,$3,$5,$6}' OFS=\| file

# 3  
Old 09-22-2012
@Clx : Thanks for the reply. it works fine. but every line appended with "^M" Smilie .

i have used

Code:
sed 's/^M//g' filename

but it havemt changed any thing .Could you please help on the above issue.
# 4  
Old 09-22-2012
Quote:
Originally Posted by i150371485
Code:
sed 's/^M//g' filename

clx's solution should work for you..

and in above command you are trying to remove M which present at the start.
^ indicates start with. ^M will search for lines started with M.
You should add \ to use ^ as a normal character. This might be because of carriage return...

try this..
Code:
sed 's/\^M//g' filename

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

Swapping

Hi Guys I am using SPARC-T4 (chipid 0, clock 2998 MHz), SunOS 5.10 Generic_150400-38 sun4v. How do I see if the server was doing some swapping like yesterday? I had a java application error with java.lang.OutOfMemoryError, now I want to check if the server was not doing some swapping at... (4 Replies)
Discussion started by: Phuti
4 Replies

2. Shell Programming and Scripting

Swapping/replacing fields

Hallo Team, I would like to replace filed 4 and 7 with filed 39 how can i achieve this ? -bash-3.2$ cat dip1.csv| cut -f4,7,24,36,39 -d","|sort -u +27113996891,+27113996891,196.35.130.52,828854047,+27873500077 +27116452690,+27825702918,10.0.109.13:5060,+27116452690,+27116452690... (2 Replies)
Discussion started by: kekanap
2 Replies

3. Shell Programming and Scripting

Swapping fields

Hallo Team, This is the command that i am running : grep ",Call Forward Not Reachable" *2013* this is the output that i am getting (i did a head -10 but the files can be more than 1000) ... (8 Replies)
Discussion started by: kekanap
8 Replies

4. UNIX for Dummies Questions & Answers

Swapping the columns of a text file for a subset of rows

Hi, I'd like to swap the columns 1 and 2 of a space-delimited text file but only for the first 1000 rows. How do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

5. Shell Programming and Scripting

AWK swapping fields on different lines

Hi All, Sorry if this question has been posted elsewhere, but I'm hoping someone can help me! Bit of an AWK newbie here, but I'm learning (slowly!) I'm trying to cobble a script together that will save me time (is there any other kind?), to swap two fields (one containing whitespace), with... (5 Replies)
Discussion started by: Bravestarr
5 Replies

6. Shell Programming and Scripting

Swapping IP Addresses In A File With Those From Another File

Hello, I'm looking for a way to change the IP addresses in a large host file with those of matching hostnames in another file. For example, I have a file with file1 contains lines like: 192.168.0.55 hostname hostname.network.lan 192.168.0.52 junkhost junkhost.network.dev... (2 Replies)
Discussion started by: PointyWombat
2 Replies

7. Homework & Coursework Questions

Swapping Fields with Sed

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: The assignment is to convert a text table to csv format. I've got the cleaning up done, but I need to swap two... (0 Replies)
Discussion started by: VoiceInADesert
0 Replies

8. Shell Programming and Scripting

Swapping strings in a file

Hi, How to swap two strings in a file ? Ex: "ABC" to be swapped with "XYZ" "ABC" and "XYZ" donot occur in a same line . String has "" Regards Tej (8 Replies)
Discussion started by: tej_89
8 Replies

9. Shell Programming and Scripting

Swapping of fields in a file

Hi I have afile with 15fields,say f1,f2....f15 delimited on comma. How can i swap the f1,f15 fields using unix shell commands or any script? Thanks (3 Replies)
Discussion started by: ksailesh
3 Replies

10. SuSE

Swapping

Hello! Why does my SuSE GNU/Linux machine swap? I have a Gig of ram, currently 14MBs of free RAM, 724MB - buffers and caches... That is 685MB of cached RAM, then kernel really should'nt have to swap, It should release cached memory in my thinkin... It has only swaped 3MB's but still,... (3 Replies)
Discussion started by: Esaia
3 Replies
Login or Register to Ask a Question