String value to replace using regex in Notepad++

Question

I have Notepad++ text editor and have the SQL script file that has many INSERT statements, exported from a table. There is a column TIMESTAMP in every row with value like this to_timestamp('08-NOV-13 11.51.51.480570000 AM','DD-MON-RR HH.MI.SS.FF AM').

I need to create a script and replace the above value with current_timestamp so all to_timestamp('08-NOV-13 11.51.51.480570000 AM','DD-MON-RR HH.MI.SS.FF AM') like values will be replaced with current_timestamp.

Also, let me know if there is any online site available to do do this conversion.

vahid abdi · Accepted Answer · 2014-01-29 09:38:16Z

1

I think Sublime Text is very ideal for your needs.

Open Sublime Text, copy your input onto the text area, press Ctrl+H, press Alt+R, and input the following pattern:

to_timestamp\([^)]+\)

in the "Find What" text box. Now enter "current_timestamp" (without quotes) in the "Replace with" text box, then press "Replace" or "Replace All" and it's done.

edited Jan 29, 2014 at 9:38

vahid abdi

10.4k4 gold badges31 silver badges37 bronze badges

answered Jan 29, 2014 at 7:00

Johnny

4914 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MarcinJuraszek · Accepted Answer · 2014-01-29 06:55:13Z

0

Following regex should match your to_timestamp() calls, try using it as find/replace pattern.

to_timestamp\('[0-9]{2}-[A-Z]{3}-[0-9]{2} (?:[0-9]{2}.){3}[0-9]{9} [AMP]{2}','DD-MON-RR HH.MI.SS.FF AM'\)

answered Jan 29, 2014 at 6:55

MarcinJuraszek

126k15 gold badges199 silver badges267 bronze badges

Collectives™ on Stack Overflow

String value to replace using regex in Notepad++

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related