Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Replace Delimiters with Space Post 302850049 by mora on Tuesday 3rd of September 2013 10:05:36 PM
Old 09-03-2013
Hi ,

Sorry for the confusion. Below is my sample source data and expected output.

Source Data
HTML Code:
Data| 12345|U|76834|123
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |0
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |1
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |2
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |3
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |4
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |5

Expected Output

HTML Code:
Data| 12345U|76834123
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |0
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |1
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |2
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |3
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |4
Xyz|123| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |5
Regards,
Mora.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replace space by _

Hi I need to know how I change the spaces by _ in folders and filder founded by find ex. find . -name "* *" -exec echo {} \; ./test space ./test space/new file.txt ./test space/new file ./test space/untitled folder ./test space/untitled folder/new fileruben ./Backup/backup/Image... (6 Replies)
Discussion started by: ruben.rodrigues
6 Replies

2. Shell Programming and Scripting

Replace space

Hai masters, If a file contains content of 2000 lines, from which i need to remove the first n characters or first n spaces from each line of the file. If suppose to remove n characters or first n spaces from a single line means, just use the command nx. But from the above scenario,... (9 Replies)
Discussion started by: ecearund
9 Replies

3. Shell Programming and Scripting

Replace long space to become one space?

Hi, i have the log attached. Actually i want the long space just become 1 space left like this : Rgds, (12 Replies)
Discussion started by: justbow
12 Replies

4. Shell Programming and Scripting

Replace every other space

I'd like a sed command to replace every other space in my file. File: 0 1 0 3 0 2 0 5 Want: 01 03 02 05 Does anyone have any ideas? (9 Replies)
Discussion started by: peanuts48
9 Replies

5. Shell Programming and Scripting

Processing data that contains space and quote delimiters

I need to write a Bash script to process a data file that is in this format: 1 A B C D E 2 F G "H H" I J As you can see, the data is delimited by a space, but there are also some fields that contain spaces and are surrounded by double-quotes. An example of that is "H H". I wrote... (7 Replies)
Discussion started by: RickS
7 Replies

6. UNIX for Dummies Questions & Answers

Remove two delimiters, space and double quotes

I would like to know how to replace a space delimiter with a ^_ (\037) delimiter and a double quote delimiter while maintaining the spaces inside the double quotes. The double quote delimiter is only used on text fields. I'd prefer a one-liner, but could handle a function or script that accepts... (4 Replies)
Discussion started by: SteveDWin
4 Replies

7. Shell Programming and Scripting

How to Replace string between delimiters?

Basically , i want to delete strings of a particular pattern from the flat file which is " | " pipe delimited. Below are the valid formats : 1) AAA (0) 111-111-111, AAA, BB 2) AAA (0) 111-111-1111;X, AAA, BB original flat file example : |ABC ABC XHAMK|AAA (0) 111-111-111, AAA,... (3 Replies)
Discussion started by: Ravi_007
3 Replies

8. Shell Programming and Scripting

Extract value between the delimiters and replace it with another value

Hi All, i have file name like below ABC_065224_123456_123456_your_130413_163005.txt ABC_065224_123456_MAIN_20130413_163005.txt ABC_065224_123456_123456_MAIN_130413_163005.txt ABC_065224_123456_123456_434567_MAIN_130413_163005.txt i need to find out the number of characters in the filed... (6 Replies)
Discussion started by: dssyadav
6 Replies

9. Shell Programming and Scripting

How to replace string between delimiters?

Hello, I would need to replace a delimiter in a flat file using.I would like to replace the semicolon (";") but only if it was contained in a string between quotes. For example: Original flat file example: abc;abc;"abc;abc";cd;"ef;ef";abc aa;bb;"aa";cc;"ddd;eee";ff Desired output:... (9 Replies)
Discussion started by: bartleby
9 Replies

10. Programming

find & Replace text using two non-unique delimiters.

I can find and replace text when the delimiters are unique. What I cannot do is replace text using two NON-unique delimiters: Ex., "This html code <text blah >contains <garbage blah blah >. All tags must go,<text > but some must be replaced with <garbage blah blah > without erasing other... (5 Replies)
Discussion started by: bedtime
5 Replies
All times are GMT -4. The time now is 01:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy