Use regex expression to FIND then REPLACE character.

Question

0.00/5 (No votes)

See more:

Here's my search text:

<time>2017-11-24T18:47:26Z</time>

Here's my regex expression for a FIND:

[0-9]T[0-9]

Here's my REPLACE expression:

[0-9]</date><time>[0-9]

And finally here's the result:

<time>2017-11-2[0-9]</date><time>[0-9]8:47:26Z</time>

What am I doing wrong here?

What I have tried:

That. That up there. What I really want is this:

<time>2017-11-24</date><time>18:47:26Z</time>

solution:

[EDIT]
FIND => "(\d+)T(\d+)"
REPLACE => "$1</date><time>$2"
[END EDIT]

Posted 28-Nov-17 11:57am

RedDk

Updated 28-Nov-17 18:31pm

v2

Add a Solution

Comments

RedDk 28-Nov-17 20:50pm

Thanks PC.

Just figured it another way as well:

(\d+)T(\d+)

with

$1"leftarrow""slash"date"rightarrow""leftarrow"time"slash""rightarrow"$2

(Boy is this stuff tricky)

Bryian Tan 28-Nov-17 21:43pm

I don't get it, why make it so complicated? Assuming there only a "T" in the string then the code would look like

var s = "<time>2017-11-24T18:47:26Z</time>".Replace("T","</date><time>");

Output:

<time>2017-11-24</date><time>18:47:26Z</time>

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PIEBALDconsult · Answer 1 · 2017-11-28T14:24:00

Solution 1

Try it this way instead.

Here's my regex expression for a FIND:

(?<=\d)T(?=\d)

Here's my REPLACE expression:

</date><time>

(Just a quick guess.)

And you'll still have mal-formed XML.

Posted 28-Nov-17 14:24pm

PIEBALDconsult

Updated 28-Nov-17 14:26pm

v2

Patrice T · Answer 2 · 2017-11-28T18:31:00

With a little stydy of xml date/time format, you would know that the 'T' is unique, so

FIND => "T"
REPLACE => "</date><time>"

is enough.

Just a few interesting links to help building and debugging RegEx.
Here is a link to RegEx documentation:
perlre - perldoc.perl.org[^]
Here is links to tools to help build RegEx and debug them:
.NET Regex Tester - Regex Storm[^]
Expresso Regular Expression Tool[^]
RegExr: Learn, Build, & Test RegEx[^]
This one show you the RegEx as a nice graph which is really helpful to understand what is doing a RegEx:
Debuggex: Online visual regex tester. JavaScript, Python, and PCRE.[^]

Use regex expression to FIND then REPLACE character.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Use regex expression to FIND then REPLACE character.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us