Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filtering out data from one column into another

I got a column in my table called attributes_overview in which information is just unsorted. It looks something like this:   Title | Attributes_Overview | Price Laptop A | ADE34DG 123.123.123.123 ...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ,

According to your description, I can extract the address in the format you mentioned "???.???.???.???".

Create a calculated column.

Addresse =
VAR _Position =
    SEARCH ( "???.???.???.???", 'Table'[Attributes_Overview] )
RETURN
    MID ( 'Table'[Attributes_Overview], _Position, 15 )

Get the result.

If you also want to extract the ADE34DG and Active part, is there any logic to distinguish them from text before or after?

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.