Hi,
I tried to replace a string with spaces in external filter stage with sed command. Its not giving the expected result. Looks im missing some thing in the sed command?
Source:
THE STATE CA THE STATE NY
Output:
CA NY
So need to replace the THE STATE with the 9 spaces.
Tried sed -e 's/THE STATE/ /g' but its throwin the below error.
"On output connection 1 (for connection 1) at record 0: Field "one" lacks whitespace delimiter, at offset: 50 "
tried with giving quote to string (sed -e 's/"THE STATE"/ /g' ) but the job completing and output is coming same as source.
When I use one word (THE) for replacement its working. Below is working.
sed -e 's/THE/ /g'
Please suggest me where im giving wrong in sed command
Thanks,
Ureddy
External Filter stage command
Moderators: chulett, rschirm, roy
You should be aware by now that all of your examples need
Code: Select all
[/b] tags around them to preserve all that 'extra' whitespace you'd like us to be able to see.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
No, I mean the "code tags" that are available on any web board like this and which you have buttons for right above where you type when composing a text. I'm going to enable the "Disable BBCode in this post" option here so you can see what they look like when editing. Leave the option off and use "Preview" to see them in action.
[code]sed -e 's/THE STATE/ /g'[/code]
[code]sed -e 's/THE STATE/ /g'[/code]
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Now on:
Code: Select all
sed -e 's/THE STATE/ /g'
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers