Replace in the specific coloumn of a csv Post: 303006806

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to replace a specific word in specific column?

Hi My orginal file is like (100s of lines) id host ip location remarks 1 host1 ip1 - xxx 2 host2 ip2 - xxx 3 host3 ip3 - xxx -- -- 9 host9 ip9 - xxx I have a ref file like host1 location1 host2 location2 host3 location3 -- --...

2. Shell Programming and Scripting

replace value with double quotes of specific coulmn value in csv file

Hi, I am trying to replace a specific column values in a csv file with double quotes. Example: SNO,NAME,ZIPCODE,RANK 1,Robert,74538,12 2,Sam,07564,13 3,Kim, Ed,12345,14 Desired Output: SNO,NAME,ZIPCODE,RANK 1,Robert Ken,74538,12 2,Sam Mik,"07564",13 3,"Kim, Ed",12345,14 I...

3. Shell Programming and Scripting

using sed to replace a specific string on a specific line number using variables

using sed to replace a specific string on a specific line number using variables this is where i am at grep -v WARNING output | grep -v spawn | grep -v Passphrase | grep -v Authentication | grep -v '/sbin/tfadmin netguard -C'| grep -v 'NETWORK>' >> output.clean grep -n Destination...

4. Shell Programming and Scripting

Using sed to replace specific character and specific position

I am trying to use sed to replace specific characters at a specific position in the file with a different value... can this be done? Example: File: A0199999123 A0199999124 A0199999125 Need to replace 99999 in positions 3-7 with 88888. Any help is appreciated.

5. Shell Programming and Scripting

Find and replace a string a specific value in specific location in AIX

Hi, I have following samp.txt file in unix. samp.txt 01Roy2D3M000000 02Rad2D3M222222 . . . . 10Mik0A2M343443 Desired Output 01Roy2A3M000000 02Rad2A3M222222 . .

6. Shell Programming and Scripting

XML to CSV specific

Hi , Please any one to help on ,extract this xml code into csv columns list. <SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="1" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19" LEVEL ="0" NAME ="BUSINESS_DATE"...

7. Shell Programming and Scripting

Replace specific field on specific line sed or awk

I'm trying to update a text file via sed/awk, after a lot of searching I still can't find a code snippet that I can get to work. Brief overview: I have user input a line to a variable, I then find a specific value in this line 10th field in this case. After asking for new input and doing some...

8. Shell Programming and Scripting

Replace a specific column with a specific value

Hi, I am looking to replacing value of a specific column of /etc/pam.d/system-auth file. My file looks like this password sufficient pam_unix.so md5 shadow nullok try_first_pass use_authtok expected result password sufficient pam_unix.so md5 shadow nullok try_first_pass use_authtok...

9. Shell Programming and Scripting

Search and replace specific positions of specific lines

Hi, I have a file with hundreds of lines. I want to search for particular lines starting with 4000, search and replace the 137-139 position characters; which will be '000', with '036'. Can all of this be done without opening a temp file and then moving that temp file to the original file name. ...

10. UNIX for Beginners Questions & Answers

Merge the three csv files as one according to first coloumn.

I have three files with similar pattern i need to merge all the coloumns side by side from all three files according to the first coloumn example as shown below I mentioned 5 coloumns only in example but i have around 15 coloumns in each file. file1: Name,Samples,Error,95RT,90RT...

LEARN ABOUT FREEBSD

color.4th

COLOR.4TH(8)						    BSD System Manager's Manual 					      COLOR.4TH(8)

NAME

     color.4th -- FreeBSD color-detection boot module

DESCRIPTION

     The file that goes by the name of color.4th is a set of commands designed to simplify color logic.  The commands of color.4th by themselves
     are not enough for most uses.  Please refer to the examples below for the most common situations, and to loader(8) for additional commands.

     Before using any of the commands provided in color.4th, it must be included through the command:

	   include color.4th

     This line is present in /boot/loader.4th file, so it is not needed (and should not be re-issued) in a normal setup.

     The commands provided by it are:

	   loader_color?	  Returns FALSE if the loader_color environment variable is set to ``NO'' (case-insensitive) or ``0''.	Otherwise
				  returns TRUE (unless booting serial).

     The environment variables that effect its behavior are:

	   loader_color
		     If set to ``NO'' (case-insensitive) or ``0'', causes loader_color? to return FALSE, indicating to many modules that color
		     should not be used.

FILES

     /boot/loader      The loader(8).
     /boot/color.4th   color.4th itself.
     /boot/loader.rc   loader(8) bootstrapping script.

EXAMPLES

     Standard i386 /boot/loader.rc:

     Use color where applicable:

	   loader_color="YES"

SEE ALSO

     loader.conf(5), loader(8), loader.4th(8)

HISTORY

     The color.4th set of commands first appeared in FreeBSD 9.0.

AUTHORS

     The color.4th set of commands was written by Devin Teske <dteske@FreeBSD.org>.

BSD
								  August 6, 2013							       BSD