Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Use the join command of linux to connect two files

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/02 Report--

This article mainly introduces the use of linux join command to connect two files, has a certain reference value, friends in need can refer to. Let's take a look at it with me.

In short, the join operation of join is to pick out two records with the same fields and put all the fields of those records on one line.

Note: when join connects two files, both files must be sorted by connection domain, and sorting by other domain is invalid.

Syntax format: join [parameters] [File 1] [File 2]

Common parameters:

-A1 or-a2 in addition to showing the record of the common domain,-A1 shows that the first file has no record of the common domain,-a2 shows that there is no record of the common domain in the second file,-I ignores case-o sets the format displayed by the result-t changes the delimiter of the domain-v1 or-v2 does not show the record of the common domain,-v1 shows that the first file has no record of the common domain -v2 shows the record of no common domain in the second file-1 or-2-1 is used to set the domain to which file 1 is connected, and-2 is used to set the domain to which file 2 is connected.

Reference example

Connect the records of two files with a common domain:

[root@linuxcool ~] # cat file.db

A li:20:men:anhui

B wang:21:women:jiangsu

C zhang:22:men:anhui

D liu:23:women:Shanghai

E chen:23:women:Hefei

[root@linuxcool ~] # cat file_hobby.db

A li:Song

B wang:shopping

C zhang:pingpong

D liu:chess

E Wang:reading

[root@linuxcool ~] # join-t: file.db file_hobby.db

A li:20:men:anhui:Song

B wang:21:women:jiangsu:shopping

C zhang:22:men:anhui:pingpong

D liu:23:women:Shanghai:chess

-A1 also shows that there is no record of a common domain in the first file, and-a2 shows the second:

[root@linuxcool] # join-t:-A1 file.db file_hobby.db

A li:20:men:anhui:Song

B wang:21:women:jiangsu:shopping

C zhang:22:men:anhui:pingpong

D liu:23:women:Shanghai:chess

E chen:23:women:Hefei

[root@linuxcool] # join-t:-a2 file.db file_hobby.db

A li:20:men:anhui:Song

B wang:21:women:jiangsu:shopping

C zhang:22:men:anhui:pingpong

D liu:23:women:Shanghai:chess

E Wang:reading

Set the fields of the specified format to display (display the fields with common records in the format of name + gender + preference):

[root@linuxcool] # join-t:-o 1.1 1.3 2.2 file.db file_hobby.db

A li:men:Song

B wang:women:shopping

C zhang:men:pingpong

D liu:women:chess above is the use of linux's join command to connect the details of the two files, after reading it, do you have anything to gain? If you want to know more about it, welcome to the industry information!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 278

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report