Sponsored Content
Top Forums Shell Programming and Scripting To transpose columns + edit in a txt file Post 302903012 by Aia on Friday 23rd of May 2014 12:22:16 PM
Old 05-23-2014
Quote:
Originally Posted by RudiC
You don't need the NF>1, because if $2 is empty, n will = 0 and nothing will be printed.
Perhaps it appears to not need it. But what would you say it requires more computation:
A simple logical operation or a call to split and then loop on it {n=split($2, a, ","); for (i=1; i<=n; i++)

It is a choice to skip the second more expensive computation for lines that do not need it.
 

10 More Discussions You Might Find Interesting

1. AIX

How to edit txt file by shell script?

What I want to do is just delete some lines from a text file, I know it's easy using copy and redirect function, but what I have to do is edit this file (delete the lines) directly, as new lines may be added to the text file during this period. Can AIX do this ? # cat text 1:line1 2:line2... (3 Replies)
Discussion started by: dupeng
3 Replies

2. Shell Programming and Scripting

Edit txt file using vi editor

Dear All I have a file called sample.txt which contains as follows HR Files records Loaded RecordDate Unloaded -- ---- -------- --------- ------------ ------ 00 567 77777 67896 0 0 01 345 345567 45678 0 ... (1 Reply)
Discussion started by: tkbharani
1 Replies

3. Shell Programming and Scripting

How to edit a txt file ?

Hi, I need to edit a text file which is like this.. -- D3341000600 AGEC901164 XYZ SE0109 1RNVX AH 2009-01-19 2009-01-11 2009-01-21 -- D3341000600 AGEC901164 XYZ SE0109 1RNVX AH 2009-01-19 2009-01-11 2009-01-21 -- D3341006000 AGEC921472 ... (4 Replies)
Discussion started by: RRVARMA
4 Replies

4. Shell Programming and Scripting

Rows to Columns - File Transpose

Hi I have an input file and I want to transpose it but I need to take care that if any field is missing for a record it should be popoulated with space for that field - using a shell script INFILE ---------- emp=1 sal=2 loc=abc emp=2 sal=21 sal=22 loc=xyz emp=5 loc=abc OUTFILE... (10 Replies)
Discussion started by: 46019
10 Replies

5. Shell Programming and Scripting

Transpose few columns alone in a Text file

Hi Friends, I am Stuck up with a problem on transposing Rows to Coloumns.. Though there are many threads on this my problem is little difficult.. I have a tab separated file like Below, computer selling_loc currency_type manufacturer_name salesweek-wk1 sales-wk2 ...wk-3 ..wk4 till... (7 Replies)
Discussion started by: heinz_holan
7 Replies

6. Shell Programming and Scripting

Transpose whole file and specific columns

Hi, I have a file like this a b c d e f g h i j k l Case1: I want to transpose the whole file Output1 a d g j b e h k c f i l Case2 Transpose a specific column - Say 3rd (6 Replies)
Discussion started by: jacobs.smith
6 Replies

7. Shell Programming and Scripting

Command to extract all columns except the last few from a txt file

hello, i have publicly available txt file with little less than 300000 rows. i want to extract from column 1 to column 218 and save it in another text file. i use the cut command but the file is saved with multiple rows from the source file onto a single row in the destination. basically it is... (6 Replies)
Discussion started by: madrazzii
6 Replies

8. UNIX for Dummies Questions & Answers

Transpose matrix, and rearrange columns common with another file

This is my first post, I apologize if I have broken rules. Some assistance with the following will be very helpful. I have a couple of files, both should ultimately have common columns only, arranged in the same order. This file needs to be transposed, to bring the rows to columns ... (2 Replies)
Discussion started by: abh.kumar
2 Replies

9. Shell Programming and Scripting

Transpose a txt file

Hello, I have a text file with 148 rows and 2532691 columns. I need to transpose the data. The command that I am using is awk ' { for (i=1; i<=NF; i++) { a = $i } } NF>p { p = NF } END { for(j=1; j<=p; j++) { str=a for(i=2; i<=NR; i++){ ... (6 Replies)
Discussion started by: nans
6 Replies

10. Solaris

I can't edit a txt file shared from Window server to Solaris

Hello, I'm working with Solaris and I need to share files between Windows Server 2012 and Solaris through an authentication with an Active Directory user, where Windows Server is the "main server". All was going good, until after see the WS files and I tried to open one and modify it, but I cannot... (1 Reply)
Discussion started by: QeratD0
1 Replies
lvsplit(1M)															       lvsplit(1M)

NAME
lvsplit - split mirrored LVM logical volume into two logical volumes SYNOPSIS
autobackup] suffix] PhysicalVolumeGroup] lv_path ... Remarks If the logical volume input arguments belong to a combination of volume groups version 1.0 and 2.0 or higher, the arguments might not be processed in the order they are listed on the command line. This command requires the installation of the optional HP MirrorDisk/UX software (not included in the standard HP-UX operating system) before it can be used. DESCRIPTION
The command splits a mirrored logical volume, lv_path, into two logical volumes. A second logical volume is created containing one copy of the data. The original logical volume is appropriately reset to have one fewer mirror copies. If the option is specified, the new logical volume name has the form lv_pathsuffix. If is not specified, suffix defaults to as in If more than one lv_path is specified on the command line, ensures that all logical volumes are brought offline together in one system call, ensuring predictable results among the logical volumes. All logical volumes must belong to the same volume group. The current num- ber of logical volumes in the volume group added to the number of logical volumes specified on the command line must not exceed the maximum number of logical volumes allowed in the volume group. If PhysicalVolumeGroup is specified, the offline logical volumes are created using the mirror copies on the physical volumes contained in the specified physical volume group. When a mirrored logical volume of a non-shared volume group is split into two logical volumes, a bit map is stored that keeps track of all writes to either logical volume in the split pair. If the volume group is shared, this bit map is not created. When the two logical vol- umes are subsequently merged using the bit map, if present, is used to decide which areas of the logical volumes need to be resynchronized (see lvmerge(1M)). This bit map remains in existence until one of the following conditions occurs: o The merge is completed. o One of the logical volumes is extended, reduced, or split again. o The volume group is cross-activated to shared mode (see vgchange(1M)). o The system is rebooted. The new logical volume must be checked with the command before it is mounted (see fsck(1M)). flushes the file system to a consistent state except for pipes and unlinked but open files. To rejoin two split copies of a logical volume, use the command (see lvmerge(1M)). Options and Arguments recognizes the following options and arguments: lv_path The block device path name of a logical volume. Multiple logical volumes in the same volume group can be speci- fied. The current number of logical volumes in the volume group added to the number of logical volumes speci- fied on the command line must not exceed the maximum number of logical volumes allowed in the volume group. Set automatic backup for invocation of this command. autobackup can have one of the following values: Automatically back up configuration changes made to the logical volume. This is the default. After this command executes, the command (see vgcfgbackup(1M)) is executed for the volume group to which the logical volume belongs. Do not back up configuration changes this time. The offline logical volumes will be created using the mirror copies on the physical volumes in the specified PhysicalVolumeGroup. Specify the suffix to use to identify the new logical volume. The new logical volume name has the form lv_pathsuffix. If is omitted, suffix defaults to as in Shared Volume Group Considerations For volume group version 1.0 and 2.0, cannot be used if the volume group is activated in shared mode. For volume groups version 2.1 (or higher), can be performed when activated in either shared, exclusive, or standalone mode. Note that the daemon must be running on all the nodes sharing a volume group activated in shared mode. See lvmpud(1M). When is issued, it creates the new logical volume device special files on all the nodes sharing the volume group. The device special files are created with the same name on the nodes sharing the volume group. When a node wants to share the volume group, the user must first execute a if logical volumes were split at the time the volume group was not activated on that node. The logical volumes device special files should have the same name on all the nodes sharing the volume group. LVM shared mode is currently only available in Serviceguard clusters. EXTERNAL INFLUENCES
Environment Variables determines the language in which messages are displayed. If is not specified or is null, it defaults to "C" (see lang(5)). If any internationalization variable contains an invalid setting, all internationalization variables default to "C" (see environ(5)). EXAMPLES
Split the mirrored logical volume into two copies. Call the new logical volume Split the mirrored logical volume into two copies. The offline logical volume will be created using the mirror copy on the physical vol- umes contained in the physical volume group Split an online logical volume which is currently mounted on so that a backup can take place: Perform a backup operation, then: Split two logical volumes at the same time: Perform a backup operation on the split logical volumes, then rejoin them: SEE ALSO
lvcreate(1M), lvextend(1M), lvmerge(1M), lvmpud(1M). Requires Optional HP MirrorDisk/UX Software lvsplit(1M)
All times are GMT -4. The time now is 03:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy