-2

I have 10,000 characters length of xml text and I have to parse out the variable name and value next to it.

 example of text:

 <? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-01-01T10:41:18- 
 05:00</xyzefg><**shAMount**>8000.00</afsfda;sfkj;alkfl;kaf>
 <? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-02-01T10:41:18- 
 05:00</xyzefg><**shAMount**>7000.00</afsfda;sfkj;alkfl;kaf>

In the above text I have the data for two variables ToDateTimestamp and shAmount

Want:

ToDateTimestamp 2019-01-01T10:41:18-05:00
ToDateTimestamp 2019-02-01T10:41:18-05:00
shAmount 8000.00
shAmount 7000.00

I tried to write a macro in notepad++ to find for a particular text and repeat for all the records, but "Run macro multiple times" is not working. Is there any Regex approach to clear everything and keep the values next to the variable name that I mentioned? I can repeat this step for each variable separately.

Thanks for your help

ckp
  • 579
  • 2
  • 10
  • 27
  • 1
    Don't parse HTML using regex. – Tim Biegeleisen Mar 10 '20 at 00:01
  • 1
    Obligatory link to point out [the futility of trying to parse X/HTML with a regex](https://stackoverflow.com/a/1732454/62576) – Ken White Mar 10 '20 at 00:05
  • 1
    Reference - [What does this regex mean?](https://stackoverflow.com/q/14048718/111697) [Parsing HTML with regex is a hard job](https://stackoverflow.com/a/4234491/372239) HTML and regex are not good friends. Use a parser, it is simpler, faster and much more maintainable. – Toto Mar 10 '20 at 10:38

2 Answers2

0

Try this, this is my best I could.

Find what: ^.*?\*\*(.*?)\*\*>|<.*
Replace with: $1 → A space after $1

Haji Rahmatullah
  • 390
  • 1
  • 2
  • 11
-1

While you should consider parsing HTML/XML I'm always dipping into Notepad++ to clean up data. You may need a few goes it this but to throw you something that may help...

https://regex101.com/r/uAPi97/1

Now the above is pretty much based on getting all the lines of...

<? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-01-01T10:41:18-05:00</xyzefg><**shAMount**>8000.00</afsfda;sfkj;alkfl;kaf>

...on to one line each. So switch off word wrap and check they are. You may need to find (in 'Extend mode') the...

<?

...bit and replace with...

\r<?

...as an example. Then you can (perhaps) use regex to find the entire line (you have to find the whole line), then capture the bits of interest (these are wrapped in () so they are captured). Then do a find and replace in Notepad++ but with regex mode selected.

The regex...

^.*?(\d+-\d+-\d+T\d+:\d+:\d+-\d+:\d+).*(shAMount).*?(\d+\.\d+).*$

...finds the whole line and if you replace with...

$1$2$3

...then the three bits in () from the regex are put back. So this...

<? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-01-01T10:41:18-05:00</xyzefg><**shAMount**>8000.00</afsfda;sfkj;alkfl;kaf>
<? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-02-01T10:41:18-05:00</xyzefg><**shAMount**>7000.00</afsfda;sfkj;alkfl;kaf>
<? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-02-01T10:41:18-05:00</xyzefg><**shAMount**>7000.00</afsfda;sfkj;alkfl;kaf>
<? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-02-01T10:41:18-05:00</xyzefg><**shAMount**>7000.00</afsfda;sfkj;alkfl;kaf>
<? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-02-01T10:41:18-05:00</xyzefg><**shAMount**>7000.00</afsfda;sfkj;alkfl;kaf>
<? xml version="1.0" of encoding="UTF-8"?><abcdefghij><**ToDateTimestamp**>2019-02-01T10:41:18-05:00</xyzefg><**shAMount**>7000.00</afsfda;sfkj;alkfl;kaf>

..sort of goes to this...

2019-01-01T10:41:18-05:00shAMount8000.00
2019-02-01T10:41:18-05:00shAMount7000.00
2019-02-01T10:41:18-05:00shAMount7000.00
2019-02-01T10:41:18-05:00shAMount7000.00
2019-02-01T10:41:18-05:00shAMount7000.00
2019-02-01T10:41:18-05:00shAMount7000.00

That may not be 100% what you want but from there you can clean it up a bit more and say, find (in Extend mode) 'shAMount' (without quotes) and replace with '\rshAMount' (without quotes). Few loops of find and replace and you may be closer to your goal.

But yes...if you do this a lot check out Python and HTML Parser - more to learn but quite powerful.

MDR
  • 2,610
  • 1
  • 8
  • 18
  • Note: The initial replace could separate out the captured strings and `$1$2$3` could be `$1-|-$2---$3` (or whatever) if that's more helpful – MDR Mar 10 '20 at 01:10