Skip to main content The new Salesforce certifications experience is live! Visit Trailhead Academy to explore your new certifications homepage.
Topics#Data ManagementAnna Duncanson's Question
Anna Duncanson (Velocity Global) asked in #Data Management
Jun 5, 2021, 8:19 PM

Report CSV Export of HYPERLINK Formula

We have Experience Cloud users able to export reports, including a hyperlink formula.

When exporting as CSV, the format of the field is the full href text.

Is there a way to have it export with just the Text Return type?

 

Current result example: <a href="/s/invoices/invoice/a0V6F00001mUe7BUAS/geoinvoiceJohn-Doe20210408-28264" target="_blank">20210408-28264</a>

 

Desired result example: 20210408-28264
7 answers
  2. Anna Duncanson (Velocity Global)
    Jun 5, 2021, 9:15 PM
    I don't think you are reading the requirements.

     

    We do not want 2 fields in the export. We already have this field as a number and it's user in the hyperlink formula.
  4. Anna Duncanson (Velocity Global)
    Jun 5, 2021, 8:40 PM
    That number is already a custom field that is being returned in the original HYPERLINK formula. We do not wish to have 2 fields in the report showing the same information if possible, given this is Experience Cloud for our client users.
  6. Anna Duncanson (Velocity Global)
    Jun 5, 2021, 8:35 PM
    Hi Keiji

     

    We still need the Hyperlink field to be in the report. It seems this solution is for an additional field? Please correct me if I have misunderstood.
  7. Keiji Otsubo (Fukada Electric Co.,Ltd.)
    Jun 5, 2021, 8:29 PM
    Hi Anna,

     

    Try this

     

     

    SUBSTITUTE(left(SUBSTITUTE( hyperlink__c, left(hyperlink__c ,FIND('>', hyperlink__c )) , ""),FIND('>', SUBSTITUTE( hyperlink__c, left(hyperlink__c ,FIND('>', hyperlink__c )) , "") )-1),"</a","")

     

     
Write an answer...
0/9000