Jump to content

Sky Slate Blueberry Blackcurrant Watermelon Strawberry Orange Banana Apple Emerald Chocolate
Photo

Wizards


  • Please log in to reply
3 replies to this topic
Tom Townsend
  • Members
  • 10 posts
  • Last active: Nov 10 2014 02:38 PM
  • Joined: 06 Sep 2006

The data below is text pasted in a notepad document.

 

<?xp Request=4?>

<ProductQuote>

  <ProductID>3517857</ProductID>

  <BrandID>MAN</BrandID>

  <CategoryID>A6000</CategoryID>

  <MakeID>00027</MakeID>

  <ProductDesc>Oil Filter - OEM</ProductDesc>

  <ProductDesc2></ProductDesc2>

  <OrderByTime>2014/02/13+06:00:00+-0800</OrderByTime>

  <DispatchTime>2014/02/13+06:15:00+-0800</DispatchTime>

  <QuantityAvail>49</QuantityAvail>

  <QuantityReq>1</QuantityReq>

  <Price>4.40</Price>

  <ListPrice>5.35</ListPrice>

  <CorePrice>0.00</CorePrice>

  <Weight>1.05</Weight>

  <Quality>OEM</Quality>

</ProductQuote>

<?xp /?>

 

What I would like to extract from this is:

 

<ProductID>3517857</ProductID>

<ProductDesc>Oil Filter - OEM</ProductDesc>

<Price>4.40</Price>

<ListPrice>5.35</ListPrice>

and saved to a text file as tab seperated text with the xml tags stripped from the data.

The saved text file could be the original file edited to yeild the desired resuls and no saved

How much?

Tom

336 292 4170


Tom Townsend
SaabTech
http://www.townsendimports.com.

Jackie Sztuk _Blackholyman
  • Spam Officer
  • 3757 posts
  • Last active: Apr 03 2016 08:47 PM
  • Joined: 28 Feb 2012
More ways than one...

If the data come's from an xml file you Can get the data without posting it to a notepad file

But if it is in a notepad file ~ open notepad window or just in a text file it Can also be parsed out
Helping%20you%20learn%20autohotkey.jpg?d

[AHK] Version. 1.1+ [CLOUD] DropBox ; Copy [WEBSITE] Blog ; About

Tom Townsend
  • Members
  • 10 posts
  • Last active: Nov 10 2014 02:38 PM
  • Joined: 06 Sep 2006

I have searced the forums and web for simple examples to learn from and found very little.

notepad would work excellent for my needs.

I use FMP5 as the engine to my application and it likes to import data that is tab seperated.

With FMP and AHK I should be able to concore the world! lol


Tom Townsend
SaabTech
http://www.townsendimports.com.

Jackie Sztuk _Blackholyman
  • Spam Officer
  • 3757 posts
  • Last active: Apr 03 2016 08:47 PM
  • Joined: 28 Feb 2012
okay i also sent you a PM
Helping%20you%20learn%20autohotkey.jpg?d

[AHK] Version. 1.1+ [CLOUD] DropBox ; Copy [WEBSITE] Blog ; About