Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extract Text

Hi, I have few Product descriptions with me eg: HP 16GB (1X16GB) 2RX4 PC3L-12800R HP 16GB(1X16GB) 2RX4 PC3L-12800R HPE 16GB 1RX4 PC4-2400T-R DIMM 16GB PC4-2933 DUAL-RANK X8 DDR4 8GB PC4-2933 SIN...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    power Query, add Conditional column 

     

andre's avatar
andre
Memorable Member
6 years ago

not sure if you are trying to implement a column of a measure, but this is the pseudocode to extract memory from your strings:

 

Memory =
-- replace the string "HP 16GB (1X16GB) 2RX4 PC3L-12800R" with your column name or selectedvalue of that column
var GBStart = SEARCH("GB", "HP 16GB (1X16GB) 2RX4 PC3L-12800R", , 0)

return IF(GBStart = 0, BLANK(), MID("HP 16GB (1X16GB) 2RX4 PC3L-12800R", GBStart-2, 4))