Inserting string in between field in comma separated file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Inserting string in between field in comma separated file
# 1  
Old 01-06-2012
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

Code:
SE18 6RN,,,,5439070,1786840,,1000002148671600,123434

Out put should be:

Code:
SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434

Can some one help me to do?

Thanks

Last edited by zxmaus; 01-07-2012 at 07:01 AM.. Reason: added tags
# 2  
Old 01-06-2012
Code:
$ nawk -F, 'BEGIN{OFS=","}{$(NF-2)="FALSE";print}' input.txt
SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434

# 3  
Old 01-06-2012
Code:
perl -F, -ane '($F[-3] eq "")&&($F[-3]="FALSE");print join(",",@F)' inputfile

# 4  
Old 01-06-2012
Code:
printf ",s/[^,]*,/FALSE,/7\nw\nq\n" | ed -s yourfile

# 5  
Old 01-07-2012
Inserting string in between field in commo separated file

Thanks a lot all,

Hi itkamaraj , balajesuri,

As I am very expert I just want to know that can you please give brief how your soultion works i.e Exactly how this works:
Code:
1. nawk -F, 'BEGIN{OFS=","}{$(NF-2)="FALSE";print}'
2. perl -F, -ane '($F[-3] eq "")&&($F[-3]="FALSE");print join(",",@F)' inputfile

Note: I am using HP unix 11.1 not linux.

Many thanks
Krsnadasa

---------- Post updated at 02:20 AM ---------- Previous update was at 02:19 AM ----------

Sorry Mates I mean to say I am not very expert in Unix..

Smilie

Moderator's Comments:
Mod Comment Please use
code tags!


---------- Post updated at 05:19 AM ---------- Previous update was at 02:20 AM ----------

Thanks a lot all,

Hi itkamaraj , balajesuri,

As I am not very expert I just want to know that can you please give brief how your soultion works i.e Exactly how this works:


Code:
1. nawk -F, 'BEGIN{OFS=","}{$(NF-2)="FALSE";print}'2. perl -F, -ane '($F[-3] eq "")&&($F[-3]="FALSE");print join(",",@F)' inputfile

Note: I am using HP unix 11.1 not linux.

Last edited by vbe; 01-07-2012 at 06:07 AM.. Reason: code tags
# 6  
Old 01-07-2012
Code:
 nawk -F, '{$(NF-2)="FALSE"; print}' OFS=, input.txt

-F,     => Indicating the field separator is , (comma)
NF      => The total no of fields
NF-2    => Second last field
$(NF-2) => The value of second last field. $(NF-2)="FALSE" means assign "FALSE" to the second last field
OFS=,   => Assign output field separator ,(comma).
print   => Print

HTH
--ahamed
# 7  
Old 01-10-2012
Many thanks Ahamed,

Your soultion is wokring fine. Sorry for delay in reply.

Hi itkamaraj ,

Your perl is not doing anything atcually.

Thanks
Krsnadasa
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. Shell Programming and Scripting

parsing comma separated file

Hi, I have a file with th elist of patches separated by comma, like below: patch1, patch 2, patch 3................ t\The number of patches is not known as it changes every time. I need assistance in writing a routine such as it will take patch1 as first variable and performs the... (4 Replies)
Discussion started by: avikaljain
4 Replies

8. 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

9. 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

10. Shell Programming and Scripting

comma separated string manipulation

hi, i have a script where i am accepting a comma separated string from the user, i have to separated those strings on the basis of comma and store it in variables.. below is the script #!/bin/ksh clear echo "Enter the strings seperated by commas :- \c " read strn echo $strn... (2 Replies)
Discussion started by: saharookiedba
2 Replies
Login or Register to Ask a Question