You are working on a report that contains the Store and Address columns.
In the Address column, you want to display only the street names for each of the eFashion stores. The Address object from the universe returns both the building number and the street name. The number of spaces before the street name begins is inconsistent. Therefore, you must create a substring to return only the portion of the address that is needed.
Notice that in each address, there is a space after the building number. If you can, create a formula that recognizes the position of the space for each entry. Use that position as a starting point for the SubStr() function.
Create a variable Space that contains the syntax:
Create a variable Address that contains the syntax:
=SubStr([Address] ; [Space] + 1 ; Length([Address]))
Copy codeSyntax