Forum Discussion

IvanS's avatar
IvanS
Icon for Helper V rankHelper V
4 years ago
Solved

Remove text string based on given text string from the list

Hi guys, I am approching you as I am stuck with replacing given set of characters from the text string. Let's say I have following table:   Detailed Location Consolidated Location New Yor...
Need Help
Tips and Tricks
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Use this

    Consolidated location = 
    TRIM(
        SUBSTITUTE(
            MID([Detailed Location],1,
                FIND("(",[Detailed Location]&"("
                )-1
            ),
            "General",""
        )
    )
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Use this

Consolidated location = 
    TRIM(
        SUBSTITUTE(
            MID([Detailed Location],1,
                FIND("(",[Detailed Location]&"("
                )-1
            ),
            "General",""
        )
    )