Skip to Content
0
Oct 11, 2019 at 10:05 PM

Format String over Multiple Lines

77 Views

I have the problem that my Access database stores each row individually in a record. The problem is that I have to format hyperlinks. The structure of hyperlinks is as follows:

A row in the database

HYPERLINK "http://votetandem.org/" votetandem.org

Multiple rows in the database

HYPERLINK

"http://newsletter.ticketcorner.ch/go/3/3JMT4VKV-3J

M7Y4X4-3J F73AD7-1PNNZI.html?affiliate=TAN⟨uage=it&referer_info=SN

-TGS-andrea-pucci-TC-20190924-CH-it_62440 "Acquista ora i

biglietti!

Only the value after the second " should be displayed if the text begins with HYPERLINK.

For example: voteandem.org (Blue and underlined) or Acquista ora i biglietti! (Blue and underlined)

For one line this formula ist working

If InStr({NW_MC_table.StoryLines},"HYPERLINK " & chr(34)) > 0 Then Split({NW_MC_table.StoryLines},chr(34))[3]

else {NW_MC_table.StoryLines}

I unfortunately have no idea how to do that over multiple lines as I am a beginner in Crystal Reports.

Attachments

screenshot.png (53.1 kB)