Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replace a field in a comma separated file
Top Forums UNIX for Beginners Questions & Answers Replace a field in a comma separated file Post 303044860 by RudiC on Thursday 5th of March 2020 12:12:25 PM
Old 03-05-2020
How about
Code:
awk -F, -v"FLDS=5,8" '
BEGIN                   {FCNT = split(FLDS, FLD)
                        }

function CV(TMP)        {Y = int(TMP/1E4)
                         return sprintf ("%d-%02d-%02d", Y, int(TMP%Y/100), TMP%100)
                        }

                        {for (i=1; i<=FCNT; i++)        {IX = FLD[i]
                                                         if ($IX) $IX = CV((19+$(IX-1))*1E6 + $(IX))
                                                             else $IX = "0001-01-01"  
                                                        }
                        }
1
' OFS=, file
29,A Store,A Street,1,2011-12-13,aaaa,0,1989-12-13
30,B Store,B Street,0,1999-12-13,aaaa,1,2006-12-13
31,C Store,C Street,1,2005-12-13,aaaaa,1,2008-12-13
32,D Store,D Street,0,0001-01-01,aaaa,1,2015-03-23
33,E Store,E Street,1,2012-12-12,bbbb,0,0001-01-01
34,F Store,F Street,1,2010-12-12,cccc,0,1997-12-12

This User Gave Thanks to RudiC For This Post:
H squared
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Its PERL + Comma separated seventh field

Hi Friends, I'm working on a perl script, which seems to be simpler. But I'm very new to PERL scripting. I have a comma separated data file, from which I need to extract only the seventh field data out of available twenty fields to an array using perl. Any help would be much appreciated. ... (17 Replies)
Discussion started by: ganapati
17 Replies

2. Shell Programming and Scripting

Replace comma by space for specified field in record

Hi, i want to replace comma by space for specified field in record, i mean i want to replace the commas in the 4th field by space. and rest all is same throught the record. the record is 16458,99,001,"RIMOUSKI, QC",418,"N",7,EST,EDT,902 16458,99,002,"CHANDLER,... (5 Replies)
Discussion started by: raghavendra.cse
5 Replies

3. Shell Programming and Scripting

How to format file into comma separated field

Guys, Need you help, i have a a file content that look like this. Nokia 3330 <spaces><spaces><more spaces>+76451883874 Nokia 3610 +87467361615 so on and so forth, - there are so many spaces in between. - e.g.... (5 Replies)
Discussion started by: shtobias
5 Replies

4. Shell Programming and Scripting

Inserting string in between field in comma separated file

Hello Mates, I have one txt file having commo seperated values. I have to insert string "FALSE" in 2nd field from the end. E.G SE18 6RN,,,,5439070,1786840,,1000002148671600,123434 Out put should be: SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434 Can some one help me to... (8 Replies)
Discussion started by: krsnadasa
8 Replies

5. Shell Programming and Scripting

Comma separated file

Hi all, I have the following files types: FileA: 100, 23, 33, FileB: 22, 45, 78, and i want to make File C: 100,22 23,45 33,78 any nice suggestions for making it easy. (3 Replies)
Discussion started by: hen1610
3 Replies

6. Shell Programming and Scripting

Need Help - comma inside double quote in comma separated csv,

Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies

7. Shell Programming and Scripting

How to split the comma separated file?

Hi, I have a filein unix like ABC,CDE BCD,KHL and the output i need is like column1 column2 ABC,CDE ABC ABC,CDE CDE BCD,KHL BCD BCD,KHL KHL. Can some body help me out? Hi, The code is working fine. But in my file each row does not have always 1 comma. It may... (6 Replies)
Discussion started by: jagdishrout
6 Replies

8. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the... (0 Replies)
Discussion started by: lost.identity
0 Replies

9. Shell Programming and Scripting

Comma separated to rows based on field

Hi to all, I have a file like: chr1 a1 a2 a3 a4 a5 a6,a7,a8,a9 chr1 b1 b2 b3 b4 b5 b6,b7 chr2 c1 c2 c3 c4 c5 c6,c7,c8,c9,c10 ... I would like an output like this: chr1 a6 chr1 a7 chr1 a8 chr1 a9 chr1 b6 chr1 b7 chr2 c6 chr2 c7 chr2 c8 (6 Replies)
Discussion started by: aec
6 Replies

10. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ... (3 Replies)
Discussion started by: as7951
3 Replies

LEARN ABOUT DEBIAN

normalize-mp3

NORMALIZE-MP3(1)					      General Commands Manual						  NORMALIZE-MP3(1)

NAME

       normalize-mp3 - adjust levels of mp3 or ogg files by running normalize-audio(1), then re-encoding

SYNOPSIS

	normalize-mp3 [OPTION]... [FILE]...
	normalize-ogg [OPTION]... [FILE]...

DESCRIPTION

       Normalize  volume  of  mp3  or  ogg  files  by decoding, running normalize, and re-encoding.  This requires as much extra disk space as the
       largest mp3 or ogg file, decoded.  Note that for batch and mix mode, all files must be decoded, so there must be enough disk space for  the
       decoded copies of all specified mp3 and ogg files.

       --ogg  Convert files to OGG, regardless of original format

       --mp3  Convert files to MP3, regardless of original format

       --bitrate BR
	      Set bitrate of re-encoded file (default 128)

       --tmpdir TMP
	      Put temporary WAV files in temp directory TMP

       --notags
	      Do not copy ID3 or OGG tags to the output file

       The  following  four options may be used to set the encoder and decoder commands for mp3 and ogg vorbis.  %m is expanded to the name of the
       mp3 or vorbis file, %w expands to the name of the temporary WAV file, and %b expands to the bitrate, as specified by the --bitrate  option.
       Run normalize-mp3 with no arguments to see the default values.

       --mp3encode=X
	      mp3 encoder

       --mp3decode=X
	      mp3 decoder

       --oggencode=X
	      ogg vorbis encoder

       --oggdecode=X
	      ogg vorbis decoder

       -h     Display this help and exit.

       -V     Display version information and exit.

       These arguments are passed as arguments to normalize-audio.
	      Run "normalize-audio --help" for more info.

       -a AMP

       -g ADJ

       -n

       -T THR

       -b

       -m

       -v

       -q

       REPORTING BUGS
	      Report bugs to <chrisvaill@gmail.com>.

SEE ALSO

       The normalize-audio(1) Man page

NOTES

       This page was provided by Eduardo Macan <macan@debian.org>

								  September 2001						  NORMALIZE-MP3(1)
All times are GMT -4. The time now is 12:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy