Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Replace specific column delimiter

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Replace specific column delimiter
# 1  
Old 12-17-2015
Replace specific column delimiter
Hi All,

I have a file with a pipe delimiter. I need to replace the delimiter with html tags.

I managed to get all the delimiters replaced along with first and last but the requirement is that I need to change 7th delimiter with slight change.

File1:
Code:
20150731|05|0000000132|000001182401644.77|0000000100|000001000000000.00|32.00|182,401,644.77

Code:
Code:
cat File1 | sed -e 's/|/<\/td><td class="metric">/g' -e 's/^/<tr><td class="metric">/' -e 's/$/<\/td><\/tr>/'

Output:
Code:
<tr><td class="metric">20150731</td><td class="metric">05</td><td class="metric">0000000132</td><td class="metric">000001182401644.77</td><td class="metric">0000000100</td><td class="metric">000001000000000.00</td><td class="metric">32.00</td><td class="metric">182,401,644.77</td></tr>

Desired Output:
Code:
<tr><td class="metric">20150731</td><td class="metric">05</td><td class="metric">0000000132</td><td class="metric">000001182401644.77</td><td class="metric">0000000100</td><td class="metric">000001000000000.00</td><td class="metric" align="right">32.00</td><td class="metric">182,401,644.77</td></tr>

Thanks
Shash
# 2  
Old 12-17-2015
Would this work:
Code:
sed 's/|/<\/td><td class="metric" align="right">/6;  s/|/<\/td><td class="metric">/g;  s/^/<tr><td class="metric">/;  s/$/<\/td><\/tr>/' file
<tr><td class="metric">20150731</td><td class="metric">05</td><td class="metric">0000000132</td><td class="metric">000001182401644.77</td><td class="metric">0000000100</td><td class="metric">000001000000000.00</td><td class="metric" align="right">32.00</td><td class="metric">182,401,644.77</td></tr>

---------- Post updated at 13:07 ---------- Previous update was at 13:03 ----------

Or
Code:
sed 's/|/<\/td><td class="metric">/g;  s/\("metric"\)>/\1 align="right">/6;  s/^/<tr><td class="metric">/;  s/$/<\/td><\/tr>/' file

This User Gave Thanks to RudiC For This Post:
shash
# 3  
Old 12-17-2015
Brilliant! Many thanks it worked!

---------- Post updated at 07:33 AM ---------- Previous update was at 07:23 AM ----------

Any idea if the same needs to be done for different columns?

Thanks
Shash

---------- Post updated at 07:34 AM ---------- Previous update was at 07:33 AM ----------

Managed to get it work for more than one column.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace delimiter for a particular column in a pipe delimited file

I have an input file as below Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber 1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000 Output : 1234|FirstName1|MiddleName2|LastName3| Add1 ,, ADD2|123|000000000 OR 1234,FirstName1,MiddleName2,LastName3, Add1 ||... (2 Replies)
Discussion started by: styris
2 Replies

2. Shell Programming and Scripting

Search Replace Specific Column using RegEx

Have Pipe Delimited File: > BRYAN BAKER|4/4/2015|518 VIRGINIA AVE|TEST > JOE BAXTER|3/30/2015|2233 MockingBird RD|ROW2On 3rd column where the address is located, I want to add a space after every numeric value - basically doing a "s//&\ / ": > BRYAN BAKER|4/4/2015|5 1 8 VIRGINIA AVE|TEST > JOE... (5 Replies)
Discussion started by: svn
5 Replies

3. 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... (5 Replies)
Discussion started by: Litu1988
5 Replies

4. Shell Programming and Scripting

How to replace a character in a specific column in a file?

This is a file that I have test line 1 (55) ) test line 2 (45) ) I would like to change all the parens in position 1 of this file to a ); i only want to check position 1 in every line of the file. I have tried different varations of sed, but cannot seem to be able to limit it to... (1 Reply)
Discussion started by: JoeG
1 Replies

5. Shell Programming and Scripting

Help with replace specific column command

Input file: ASD_QAW 12 A_@ AE_AQ 21 PA_123 ASDA_@ 23 ADA_AS . . Output file: ASD_QAW 12 A @ AE_AQ 21 PA 123 ASDA_@ 23 ADA AS . . Do anybody know how to just specific and replace "_" in column 3 with tab delimiter (\t)? Thanks for advice. (2 Replies)
Discussion started by: perl_beginner
2 Replies

6. Shell Programming and Scripting

Bash Replace value in specific column

Hi all, I have two files with the following format: file1 BBB;33 AAA;2 CCC;5 file2 5;.;.;. 33;.;.;. The first file contain a list of code and numbers. The second file only the number. I would like to replace the corresponding code in the first column of the file1 with the... (3 Replies)
Discussion started by: g256
3 Replies

7. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies

8. Shell Programming and Scripting

Help with replace column data with specific word

Input file: Populus_trichocarpa 30 0 50 0 0 US Vitis_vinifera 1 18 2 8 6 US Populus_trichocarpa 1 5 100 0 0 US Arabidopsis_lyrata_subsp._lyrata 0 90 0 0 0 US Glycine_max 0 2 3 0 70 UK Desired output file: Populus_trichocarpa YES NO YES NO NO US Vitis_vinifera YES YES YES YES YES US... (4 Replies)
Discussion started by: perl_beginner
4 Replies

9. Shell Programming and Scripting

How to remove delimiter from specific column?

I have 5 column in sample txt file where in i have to create report based upon 1,3 and 5 th column.. I have : in first and third coulmn. But I want to retain the colon of fifth coulmn and remove the colon of first column.. 5th column contains String message (for example,... (7 Replies)
Discussion started by: Shirisha
7 Replies

10. 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 -- --... (6 Replies)
Discussion started by: ./hari.sh
6 Replies
Login or Register to Ask a Question