how to convert & into AND

pavankatra · Post by **pavankatra** » Tue May 04, 2010 6:37 am

Hi,
how to convert & into AND.

Can anyone please suggest me how to achieve this.

Thanks iun advance

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue May 04, 2010 6:45 am

sed -e 's/\&/AND/g' yourFileName

pavankatra · Post by **pavankatra** » Tue May 04, 2010 6:47 am

Sainath.Srinivasan wrote:
Code: Select all
sed -e 's/\&/AND/g' yourFileName
...

THanks for your reply.

but here i am working on windows.So please suggest me.

priyadarshikunal · Post by **priyadarshikunal** » Tue May 04, 2010 6:55 am

It should work on windows as well because of MKS Toolkit installed with Datastage.

pavankatra · Post by **pavankatra** » Tue May 04, 2010 7:33 am

priyadarshikunal wrote:It should work on windows as well because of MKS Toolkit installed with Datastage.

Thanks for your reply

where can i use that suugest me please.

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue May 04, 2010 4:52 pm

Presumably this is an isolated ampersand, one with space either side of it. Or will you have strings like Abbott&Costello - and, in that case, what is your rule for dealing with it?

Check out the parallel version of Ereplace() (search DSXchange for it). It does exactly what you require. But note that you may need to replace " & " with " AND ".