Sponsored Content
Top Forums Shell Programming and Scripting Change 10th column formatting. Post 303017491 by RudiC on Wednesday 16th of May 2018 03:41:29 PM
Old 05-16-2018
Try also
Code:
awk -F, '
        {gsub (/;/, "\"&\"", $3)
         n = split ($3, T, ";")
         for (i=1; i<=n; i++)   {$3 = T[i]
                                 print
                                }
        }
' OFS=, file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace 10th column with a new column--- Terriblly hurry

Hi Can any one tell me how to replace the 10th column in a file(comma delimted) with a new file with a single column. Can any one Help me out of the please as soon as possible as i am in a terribley hurry!!!!!! Many THanks, (2 Replies)
Discussion started by: ahmedwaseem2000
2 Replies

2. UNIX for Dummies Questions & Answers

Change one column using sed??

Is there way to use sed to change only one occurence in a colon separated line? I would like to change a file from *:*:rex:rex *:*:simon:rex to *:*:rex:mabry *:*:simon:rex (2 Replies)
Discussion started by: rexmabry
2 Replies

3. Shell Programming and Scripting

Change names in a column based on the symbols in another column

If the 4th column has - sign then the names in 3rd column has to change to some user defined names (as shown in output). Thanx input1 1 a aaaaa + 2 b bbbbb + 3 c ccccc + 4 d ddddd + 5 e eeeee + 6 f xxxxx + 8 h hhhhh +... (8 Replies)
Discussion started by: repinementer
8 Replies

4. UNIX and Linux Applications

Replace string in unix from 10th column onwards

Hi All, I need to replace the last 19 bytes of the following string My_Org_Testing_20090102_231124.txt (Text_Date_Time.txt). I would like to derive the current time using "date +%Y%m%d_%H%M%S.txt" and replace the last 19 bytes of the above string I would appreciate if someone could... (3 Replies)
Discussion started by: rpk2008
3 Replies

5. Shell Programming and Scripting

(Formatting)new Column adding

Hi guys i have a variable called hostname which contains hostname of my machine. How would i add the hostname to output of other command . For eg. if a output of command is . command : xm list How would i add hostname column to it. My output should look like ... (1 Reply)
Discussion started by: pinga123
1 Replies

6. Shell Programming and Scripting

Change value in a column

Hello! Please could anyone help me in writing a code to modify the value in column two of a file with more than two tab-separated column (but the lines may have a different number of columns, i.e. more or less columns), according to the following conditions. When the value of column two is... (5 Replies)
Discussion started by: mjomba
5 Replies

7. Shell Programming and Scripting

Change file content 4 column to one Column using script

Hi Gurus, I have file content sample: ,5113955056,,TAgent-Suspend ,5119418233,,TAgent-Suspend ,5102119078,,TAgent-Suspend filenames 120229H5_suspend, 120229H6_unsuspend I receive those files one of directory /home/temp/ I need following: 1. Backup first /home/temp/ file to... (5 Replies)
Discussion started by: thepurple
5 Replies

8. Shell Programming and Scripting

awk or sed: change the color of a column w/o screwing up column spacing

Hey folks. I wrote a little awk script that summarizes /proc/net/dev info and then pipes it to the nix column command to set up column spacing appropriately. Here's some example output: Iface RxMBytes RxPackets RxErrs RxDrop TxMBytes TxPackets TxErrs TxDrop bond0 9 83830... (3 Replies)
Discussion started by: ryran
3 Replies

9. Shell Programming and Scripting

Change column to row base on column 2

Hi Guys, Input.txt L194 A -118.2 L194 B -115.1 L194 C -118.7 L196 A 0 L196 C 0 L197 A -111.2 L197 B -118.9 L197 C -119.9 L199 A -120.4 L199 B -119.9 ... (2 Replies)
Discussion started by: asavaliya
2 Replies

10. Shell Programming and Scripting

How to replace the 10th column?

how to replace the 10th colum? Each line begins similarly, but they all ends variously. Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15,Col16,Col17 2015/03/14 15:00:04,2015/03/14 15:00:04,0,Server05,Omega-God,Beta_G,101011247,1,1,24,7,0,,339083645,1,1,... (9 Replies)
Discussion started by: ooilinlove
9 Replies
cd(1)							      General Commands Manual							     cd(1)

NAME
cd - change working directory SYNOPSIS
[directory] DESCRIPTION
If directory is not specified, the value of shell parameter is used as the new working directory. If directory specifies a complete path starting with or directory becomes the new working directory. If neither case applies, tries to find the designated directory relative to one of the paths specified by the shell variable. has the same syntax as, and similar semantics to, the shell variable. must have execute (search) permission in directory. exists only as a shell built-in command because a new process is created whenever a command is executed, making useless if written and pro- cessed as a normal system command. Moreover, different shells provide different implementations of as a built-in utility. Features of as described here may not be supported by all the shells. Refer to individual shell manual entries for differences. If is called in a subshell or a separate utility execution environment such as: (which invokes on accessible directories) does not affect the current directory of the caller's environment. Another usage of as a stand- alone command is to obtain the exit status of the command. EXTERNAL INFLUENCES
International Code Set Support Single- and multi-byte character code sets are supported. Environment Variables The following environment variables affect the execution of The name of the home directory, used when no directory operand is specified. A colon-separated list of pathnames that refer to directories. If the directory operand does not begin with a slash character, and the first component is not dot or dot-dot, searches for directory relative to each directory named in the variable, in the order listed. The new working directory is set to the first matching directory found. An empty string in place of a directory pathname represents the current direc- tory. If is not set, it is treated as if it was an empty string. EXAMPLES
Change the current working directory to the directory from any location in the file system: Change to new current working directory residing in the current directory: or Change to directory residing in the current directory's parent directory: Change to the directory whose absolute pathname is Change to the directory relative to home directory: RETURN VALUE
Upon completion, exits with one of the following values: The directory was successfully changed. An error occurred. The working directory remains unchanged. SEE ALSO
csh(1), pwd(1), ksh(1), sh-posix(1), sh(1), chdir(2). STANDARDS CONFORMANCE
cd(1)
All times are GMT -4. The time now is 12:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy