Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extracting Specific Text from a String Type Column

I have a text string column in my dataset that contains random strings. However, some of the records contain location information within the strings. An example of this is: EU-Romania- Server and the...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous I don't why wouldn't post these rules in your original post, how someone will get to know what to do. Read this post to get your answer quickly.

    https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

     

    Anyhow, add new column with following expression.

     

    MyRegion = 
SWITCH ( TRUE(),
    SEARCH ( "EU", Table[Data], , -1 ) >= 0, "EU",
    SEARCH ( "Name", Table[Data], , -1) = -1 && SEARCH ( "NA", Table[Data], , -1 ) >= 0, "NA",
    SEARCH ( "APAC", Table[Data], , -1 ) >= 0, "APAC",
    ""
)

     

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous can you paste sample data here in a table?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'll paste some sample values from this column:

 

Default-First-Site-Name

Azure-EU- North Europe ( I need EU from this value)

none

FR-Telecity

FIT

DE_MUC

TX95C

AWS-NA-East (I need just NA from this value)

 

 

 

 

 

 

 

 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous is this the only value from which you don't want "NA" to extract? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      There are around 70,0000 rows of data in this dataset so there maybe other values that contain "na" in the value.

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous that raised the question what would be the logic to ignore not to extract "NA" , you have to have some logic, isn't it?