April 16, 200124 yr 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
April 17, 200124 yr 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.
Create an account or sign in to comment