Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Special character replacement

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Special character replacement
# 1  
Old 08-14-2019
Special character replacement
Hi Guys,
I have a file which needs to be replaced with tab delimited

Code:
AA§Orgin Name§Mapping based on prod_usa§§§§
BB§Date§2019-08-11 23:30:01§§§§

I am trying below code

Code:
sed 's/[ -~ ^]/ /g' test.txt

Expected
Code:
AA|Orgin Name|Mapping based on prod_usa|||
BB|Date|2019-08-11 23:30:01||||

# 2  
Old 08-14-2019
Could you just do this?:-
Code:
tr "§" "|" < inputfile > outputfile




I hope that this helps,
Robin
This User Gave Thanks to rbatte1 For This Post:
rohit_shinez
# 3  
Old 08-14-2019
you can get the required output through sed, try following command
Code:
sed -i 's/§/|/g' filename.txt

Last edited by rbatte1; 08-14-2019 at 01:32 PM..
# 4  
Old 08-14-2019
Hi rohit_shinez...
Your expected output shows 3 pipes at the end of the first line but the original has 4, is this correct?
# 5  
Old 08-14-2019
Quote:
Originally Posted by rohit_shinez
Hi Guys,
I have a file which needs to be replaced with tab delimited

Code:
AA§Orgin Name§Mapping based on prod_usa§§§§
BB§Date§2019-08-11 23:30:01§§§§

I am trying below code

Code:
sed 's/[ -~ ^]/ /g' test.txt

Expected
Code:
AA|Orgin Name|Mapping based on prod_usa|||
BB|Date|2019-08-11 23:30:01||||


Yes you are correct it should be |||| , and is there a generic way to replace the special characters apart from §, I mean if I get any other special character
Last edited by rbatte1; 08-14-2019 at 01:33 PM..
# 6  
Old 08-14-2019
Hi,

Yes, you can provide ranges of special characters in both sed and tr or you can work with one character at a time. All the information that you require should be in the man pages on your system, you can try man tr this would be a good place to start.

Regards

Gull04
# 7  
Old 08-14-2019
Quote:
Originally Posted by rohit_shinez
Yes you are correct it should be |||| , and is there a generic way to replace the special characters apart from §, I mean if i get any other special character
rohit_shinez,

You can't really expect to post a single small line of code and the expect people here to write every thing else for you.

Why don't you try again? Put your own work into the task and not change your original requirements and expect others to code it for you.

Please do some of your own work. TRY!
This User Gave Thanks to Neo For This Post:
jim mcnamara
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Trigger email from script if the Special Character replacement is successfull

Hello Gurus, I have a script developed... #!/bin/bash #--------------------------------------------------------------------- # This pScript will remove/replace the special characters fromfiles #--------------------------------------------------------------------- trxdate="`date... (1 Reply)
Discussion started by: nanduedi
1 Replies

2. Shell Programming and Scripting

sed - replacement file path with variable - Escaping / character

Hi,, I have the line below in a file: $!VarSet |LFDSFN1| = '"E:\APC\Trials\20140705_427_Prototype Trial\Data\T4_20140705_Trial_Cycle_Data_13_T_Norm.txt" "VERSION=100 FILEEXT=\"*.txt\" FILEDESC=\"General Text\" "+""+"TITLE{SEARCH=NONE NAME=\"New Dataset\" LINE=1I want to write a script to change... (2 Replies)
Discussion started by: carlr
2 Replies

3. Shell Programming and Scripting

Deleteing one character after an special character

I have below line in a unix file, I want to delete one character after "Â". 20091020.Non-Agency CMO Daily Trade Recap Â~V Hybrids The result should be : 20091020.Non-Agency CMO Daily Trade Recap  Hybrids i dont want to use "~V" anywhere in the sed command or any other command, just remove... (1 Reply)
Discussion started by: mohsin.quazi
1 Replies

4. UNIX for Dummies Questions & Answers

global search and replacement of a non-ascii character

Hi, I need to do a global search and replacement of a non-ascii character. Let me first give the background of my problem. Very frequently, I need to copy set of references from different sources. Typically, a reference would like this: Banumathy et al., 2002 G. Banumathy, V. Singh and U.... (1 Reply)
Discussion started by: effjay
1 Replies

5. Programming

python, character replacement

Hello, I need to do this in python but I'm just learning py and it's quite urgent. I have a script I created and need an interactive python script to modify part of a line. MY SCRIPT #ligand prep. Uses 'ind' prefix. The initial ligand must be ind.pdb. This #generates ind.pdbqt.... (0 Replies)
Discussion started by: gav2251
0 Replies

6. UNIX for Dummies Questions & Answers

banner character replacement

Can we able to replace the character # in banner command with some other characters. Can we able to blink the character in Kornshell (1 Reply)
Discussion started by: sivakumar.rj
1 Replies

7. Shell Programming and Scripting

Sed-Special character replacement

Hi I want to replace ./testsed.ksh with testsed.ksh ./ is to be removed scriptnm=`sed -e 's/\.///' $0 does not work Please help (3 Replies)
Discussion started by: usshell
3 Replies

8. Shell Programming and Scripting

KSH - Character Replacement

Hey all. Easy question. I have a (ksh) varaible x. It contains the following (for example): N557788 I want to replace the "N" with a "-". I've done this before but for the life of me I cannot remember how I did it. Thanks. mtw (2 Replies)
Discussion started by: mixxamike
2 Replies

9. Shell Programming and Scripting

Character replacement

Hi, I am working on a command that replaces some occurrences of quotation marks in file. The quotation mark cannot be the first or the last character in line and cannot be preceded or followed by a comma. I am not an expert in regular expressions, but I managed to create the following... (2 Replies)
Discussion started by: piooooter
2 Replies

10. Shell Programming and Scripting

Help needed in character replacement in Korn Shell

How do I replace a space " " character at a particular position in a line? e.g. I have a file below $ cat i2 111 002 A a 33 0011 B c 2222 003 C a I want all the 1st spaces to be replaced with forward slash "/" and the 3rd spaces to have 5 spaces to get the output below: 111/002... (8 Replies)
Discussion started by: stevefox
8 Replies
Login or Register to Ask a Question