Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Replacing valuses containig space and special characters Post 302936996 by blackrageous on Monday 2nd of March 2015 01:55:11 PM
Old 03-02-2015
This seems to be just a replace issue easily handled by sed without the need for the power of awk.

The $ is the only character that needs to be quoted to prevent the system thinking a variable is in use, this works...

Code:
sed -e "s/CAST ('\${DEFAULT_HIGH_DATE}' AS DATE FORMAT 'YYYY-MM-DD')/CAST(CAST('\${G_DEFAULT_HIGH_DATE}' AS DATE FORMAT 'MM-DD-YYYY') as DATE FORMAT 'YYYY-MM-DD')/g" x.x

where x.x is file containing
Code:
CAST ('${DEFAULT_HIGH_DATE}' AS DATE FORMAT 'YYYY-MM-DD')

This User Gave Thanks to blackrageous For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

replacing string with special character ???

the problem is while replacing the old string with new one with the help of SED i am unable to replace the special characters with new strings. how can i do that? i dont want the user to be given the trouble to write '\' before every special characters like * , . , \ , $ , &. sed... (4 Replies)
Discussion started by: imppayel
4 Replies

2. Shell Programming and Scripting

Replacing French special characters

Hi, I have tonnes of .txt files that are written in French. I need to replace the French special characters, however, with English equivalents (e.g. é -> e and ç -> c). I have tried this --- #!/bin/bash # Convert French characters to normal characters # Treat each of the files exec... (4 Replies)
Discussion started by: BlueberryPickle
4 Replies

3. Shell Programming and Scripting

help on sed replacing special characters

Hello, I have a file with many lines with below format: \abc\\1234 jkl\\567 def\\345 \pqr\\567 \xyz\\234 Here, i need to do 2 things. 1. replace \\ with \ 2. remove starting \ so output to be as below: (11 Replies)
Discussion started by: prvnrk
11 Replies

4. Shell Programming and Scripting

Replacing string with special characters in shell

Hi, I am trying to replace a string in shell but it is not working correctly. @xcom.file@ needs to be replaced with tb137 Plz help.Thx. Please use and tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks. (4 Replies)
Discussion started by: manish72
4 Replies

5. Shell Programming and Scripting

Replace special characters with Escape characters?

i need to replace the any special characters with escape characters like below. test!=123-> test\!\=123 !@#$%^&*()-= to be replaced by \!\@\#\$\%\^\&\*\(\)\-\= (8 Replies)
Discussion started by: laknar
8 Replies

6. Shell Programming and Scripting

Need help in replacing special characters

I am writing a ksh script. I need to replace a set of characters in an xml file. FROM="ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖØÙÛÚÜÝßàáâãäåçèéêëìíîïðñòóôõö¿¶ø®"; TO="AAAAAAACEEEEIIIIDNOOOOOOUUUUYSaaaaaaceeeeiiiionooooo N R" I have used the code- sed 's/$FROM/$TO/g'<abc.xml But its not working. Can anyone tell me the code to do this? (3 Replies)
Discussion started by: saga20
3 Replies

7. Shell Programming and Scripting

sed replacing specific characters and control characters by escaping

sed -e "s// /g" old.txt > new.txt While I do know some control characters need to be escaped, can normal characters also be escaped and still work the same way? Basically I do not know all control characters that have a special meaning, for example, ?, ., % have a meaning and have to be escaped... (11 Replies)
Discussion started by: ijustneeda
11 Replies

8. Shell Programming and Scripting

How to remove alphabets/special characters/space in the 5th field of a tab delimited file?

Thank you for 4 looking this post. We have a tab delimited file where we are facing problem in a lot of funny character. I have tried using awk but failed that is not working. In the 5th field ID which is supposed to be a integer only of that file, we are getting corrupted data as below. I... (12 Replies)
Discussion started by: Srithar
12 Replies

9. UNIX for Beginners Questions & Answers

Replacing string/special characters using a 'conversion' table

Hi, Does anyone know if there is a script or program available out there that uses a conversion table to replace special characters from a file? I am trying to remove some special characters from a file but there are several unprintable/control characters that some I need to remove but some I... (2 Replies)
Discussion started by: newbie_01
2 Replies

10. UNIX for Beginners Questions & Answers

Any tip to replacing the special characters in a file

Hi, Please find attached a file that has special characters on it. It is a copy and paste from a Micro$oft file. I don't want to use strings as it remove all the 'indentations' / 'formatting' so I am replacing them with space instead. I am using the sed command below sed "s/$(printf... (1 Reply)
Discussion started by: newbie_01
1 Replies
NANOBLOGGER(1)							   User Commands						    NANOBLOGGER(1)

NAME
NanoBlogger - small weblog engine for the UNIX command line SYPNOSIS
nb [-b blog_dir] [options] DESCRIPTION
NanoBlogger User's manual. NanoBlogger is a small weblog engine written in Bash for the command line. It uses common unix tools, such as cat, grep and sed. It's free to use and modify under the GNU General Public License. OPTIONS
-a, --add create new entry, category, or weblog (directory). -b, --blogdir <directory> specify weblog directory. -B, --body <text> deprecated, please use '-T' or '--text' instead. -c, --category <ID,cat> specify category (for '--add', '--delete', '--edit', '--list', '--update', and '--update-cache'). --cfgfile <file> specify an alternate configuration file. --configure configure weblog (for '--update'). --datadir <directory> specify weblog's data directory. -d, --delete <ID,cat> delete an entry or category. -D, --desc <text> set text of description (for '--add', '--draft', '--makefile' and '--makepage'). -e, --edit <ID,cat> edit an entry or category. -E, --draft <file> edit or create metafile. -f, --file <file> specify metafile to import as entry (for '--add'). -h, --help show this help message. -i, --interactive <1=on/0=off> toggle interactive mode (for '--add', '--delete', '--preview', '--publish', and '--update'). -l, --list <all,cat,DATE,max> list entries or categories (defaults to max). --manual view the manual. -m, --move <ID> move an entry to a specified category (for '--category'). -M, --makepage <file1> <file2> create new weblog page (file2) from metafile (file1). --makefile <file> create new metafile. -n, --author <text> set text of author (for '--add', '--draft', '--makefile' and '--makepage'). --plugindir <directory> specify weblog's plugin directory. -p, --preview run command to preview weblog. -P, --publish run command to publish weblog. --template <file> specify file to load as template (for '--draft', '--makepage' and '--makefile'). --template-dir <directory> specify weblog's template directory. -t, --title <text> set text of title (for '--add', '--category', '--draft', '--makefile' and '--makepage'). --tag <TAG> specify tag (for '--add', '--draft', '--edit', '--makefile' and '--makepage'). --tag-text <text> set text of tag (for '--tag'). -T, --text <text> set text of body (for '--add', '--draft', '--makefile' and '--makepage'). -U, --update-cache <all,DATE,max,expired> force update of weblog's cache removing specified cached data (defaults to 'expired'). -u, --update <all,DATE,main,max> force update of weblog's files updating specified weblog data (defaults to 'max'). -v, --verbose <1=on/0=off> toggle level of verbosity. -V, --version display version information. -c,-d,-e,-m accepts multiple ID numbers separated by commas (e.g. 1,2,3). --list and --update can match entries by date (irrelevant of entry id(s)). date = YYYY-MM-DD, YYYY-MM, YYYY EXAMPLES
--blogdir [myblog_dir] --add Where myblog_dir is a nonexistent directory. This will create a new directory, copy the default files over, and then let you edit the weblog's configuration. Multiple weblogs can be created this way. Running the same command again on an existing weblog direc- tory will add a new entry. --blogdir [myblog_dir] --configure -u all This opens blog.conf from the weblog directory for editing and updates the entire weblog. [-b blog_dir] -a Add a new entry [-b blog_dir] -c 1 -a Add a new entry to a category [-b blog_dir] -t "New Entry" -n [entry_author] -a Set title and author for new entry [-b blog_dir] -t "New Entry" -n [entry_author] -M "My message." -a Set title, author, and body for new entry [-b blog_dir] -l List current entries [-b blog_dir] -l all List all entries [-b blog_dir] -c 1 -l List entries for a category [-b blog_dir] -e 1 Edit the last entry created [-b blog_dir] -c 1 -e 1 Edit an entry from a category [-b blog_dir] -e 1,2,3 Edit multiple entries [-b blog_dir] -c 1 -m 1 Move an entry to a category [-b blog_dir] -c 1,2,3 -m 1 Move an entry to multiple categories [-b blog_dir] -c 1 -m 1,2,3 Move multiple entries to a category [-b blog_dir] -d 1 Permanently delete an entry [-b blog_dir] -d 1,2,3 Permanently delete multiple entries [-b blog_dir] -c 1 -d 1 Delete an entry from a category [-b blog_dir] -c new -a Create a new category [-b blog_dir] -t "New Category" -c new -a Set the title for a new category [-b blog_dir] -l cat List available categories [-b blog_dir] -c 1 -t "News" -e cat Edit a category's title [-b blog_dir] -c 1 -d cat Delete a category [-b blog_dir] -u all Update the Weblog's Data Directory NOTES
The articles plugin provides a simple way for NanoBlogger to automatically generate and update articles for your weblog. Creating a new article is easy, create a new file in the articles directory and save it with the suffix, "txt". To remove an article simply rename it's suffix to something other than "txt" or remove it from the articles directory. Edit templates/main_links.htm to add new links. FILES
/etc/nanoblogger/nb.conf AUTHOR
NanoBlogger written by Kevin Wood (n1xt3r) <un1xt3r@fastmail.fm> This manual page was originally written by William Vera <billy@billy.com.mx> and then updated by Michal Cihar <michal@cihar.com> for the Debian system (but may be used by others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation SEE ALSO
/usr/share/doc/nanoblogger/nanoblogger.html http://nanoblogger.sourceforge.net/ NanoBlogger 3.3 September 2006 NANOBLOGGER(1)
All times are GMT -4. The time now is 05:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy