Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Replacing valuses containig space and special characters Post 302936964 by 100bees on Monday 2nd of March 2015 09:12:11 AM
Old 03-02-2015
Replacing valuses containig space and special characters

**Extremely sorry for the typos in heading

Old:
Code:
CAST ('${DEFAULT_HIGH_DATE}' AS DATE FORMAT 'YYYY-MM-DD')

New :
Code:
CAST(CAST('${G_DEFAULT_HIGH_DATE}' AS DATE FORMAT 'MM-DD-YYYY') as DATE FORMAT 'YYYY-MM-DD')

Need to change old format as new format

cat file1
Code:
CAST ('${DEFAULT_HIGH_DATE}' AS DATE FORMAT 'YYYY-MM-DD')


Code:
 
awk {gsub(CAST \(\'\$\{EDW\_DEFAULT\_HIGH\_DATE\}\' AS DATE FORMAT \'YYYY\-MM\-DD\'\),
"CAST\\(CAST\\(\\'\\$\\{GLODB\\_\\TD\\_EDW\\_DEFAULT\\_HIGH_DATE\\}\\'" "AS" "DATE" "FORMAT \\'MM\\-\\DD\\-YYYY\\'\\)" "as" "DATE" "FORMAT" "\\'YYYY\\-MM\\-DD\\'\\)" ;print}' file1

Kindly help me.
Moderator's Comments:
Mod Comment Please use CODE tags for sample input and output as well as for code.

Last edited by Don Cragun; 03-02-2015 at 07:01 PM.. Reason: Add CODE tags.
 

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
WIKI-TOOLKIT-REVERT-TO-DATE(1p) 			User Contributed Perl Documentation			   WIKI-TOOLKIT-REVERT-TO-DATE(1p)

NAME
wiki-toolkit-revert-to-date - Revert the state of a Wiki::Toolkit instance to an earlier point in time. SYNOPSIS
# Removes any changes made to a Wiki::Toolkit instance since a given date # (and optionally time), restoring it to the state at that point. wiki-toolkit-revert-to-date --type postgres --name mywiki --user wiki --pass wiki --host 'db.example.com' --port 1234 --date 2007-01-05 --time 11:23:21 DESCRIPTION
Takes three mandatory arguments: type The database type. Should be one of 'postgres', 'mysql' and 'sqlite'. name The database name. date The date to revert the state back to, in the format YYYY-MM-DD five optional arguments: time The time (on the specified date) to revert the state back to, in the format hh:mm:ss. If not specified, will use midnight. user The user that connects to the database. It must have permission to create and drop tables in the database. pass The user's database password. host The hostname of the machine the database server is running on (omit for local databases). port The port number that the database server is expecting connections to. AUTHOR
Nick Burch COPYRIGHT
Copyright (C) 2006 Nick Burch. All Rights Reserved. This code is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO
Wiki::Toolkit perl v5.14.2 2011-09-25 WIKI-TOOLKIT-REVERT-TO-DATE(1p)
All times are GMT -4. The time now is 09:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy