Community

Hi All,

i have been informed previously that there are a few things that can be done in WildEdit to XML files. I have a large amount of XML files, about 400 where I need to swap the contents of the <FormalStatement> Tag with the contents of the <Paragraph> Tag that comes directly after it. Is this ...

Hi there,

Thanks again for the assistance and my apolgise for not getting back to you sooner. I have tried what you suggested and my new data layout is the same as my old one.

I might be doing something wrong but these are the steps that I carried out

I put a tick in the '.' does not match a ...

Hi,

Thanks for the reply with regards to my posting, the actual data is XML. I am afriad that I cant post the exact file due to security reasons but it is in the same format as my example :

There is Data above the TransformedXml Tag

<TransformedXml>
<Paragrap>This is going to be a large piece of ...

Hi,

I am wondering whether TextPad/RegEx can do the following, I have a large number of files that I want to get certain pieces of information out of, the files that looks like this, this being only a small sample of the total contents,

<Paragrap>This is going to be a large piece of text ...

Thanks for that, it worked brilliantly, can you recomend and good sites for learning about reg. exp. as I like to try and learn as much as I can.

Thanks Phil

Hi All,

Wondering if someone can help me with some code for a reg. expression, I have a file that is not very pretty and I am trying to get each new vehicle onto a new line, I have managed to do this to a point but there are a couple that are escpaing, the line looks like this

Line1 - AU A3 5DR ...

Hi all,

I'm wondering if someone can help me with a bit of a problem, I have a text file that I need to seperate out into individual lines between the HTML tags but I cant work out how to do it, I am thinking that I will need to use a macro but not sure how to go about it, the file text looks ...

Just one quick question, it completed half of the document but is now saying the first exspression cant be found \n\([^|]+\)$ there is nothing different to the rest of the file........

Thanks Phil

Thanks for the reply, it works great, once I had it sorted once it was something I could autmate, your help was much appreciated.

Thanks Phil

Hi there, thanks for the reply, below is a example of a bad record

19|'Northern'|'The Hollies'|'01347 833154'|'01347833154'|'Station Road,,
Tollerton,,
Yorkshire,,
YO61 1TS'|'All properties on this site are now sold subject to contract. Please contact the site for further details.',,




I would ...

Hi all, bit new to this, having read through the forums I am none the wiser :-) I have a text file where the columns are broken up using the group by pp.vendorid, vg.vendorgroupid, vg.nameipe key (|) but there have been unwanted carriage returns inserted, like half way through a description, how can ...