Jump to content

Parsing a List


This topic is 7782 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Good Day All

I need to parse some text that came from an HTML page (see example below). Each parsed text needs to be in a seperate record. I can get it to grab the first line but beyond that I am having difficulty. I am still learning to use the Loop function properly.

Thank You

Rob

Example:

<p>Some text</p>

<p>More Text</p>

<p>Crazy Text</p>

etc

Link to comment
Share on other sites

You may want to explore importing it into Excel, that may pick up the invisible carriage returns between lines of the HTML doc and put each one into it's own column or row. Then you can export as tab sep and import into FMP, each in it's own record. Then it is a simple matter of using text calcs to remove the tags.

I haven't tried this but I think it will work. Often times, it is easier to take "ugly data" into Excel to do initial cleaning and then dump it into FMP once it is in a slightly friendlier format.

Good Luck!

Cael.

Link to comment
Share on other sites

This topic is 7782 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.