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 

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Karlos,

 

Thanks for this solution, it worked like a charm. Only challenge I am facing here is the font variation, I observed that there are few descriptions which have 16Gb, 16 GB, 16Gb and 16gb as memory size. For now i have added all of these scenarios as condition in column but it would be halpful if i can do the same thing immaterialistic of font and space.

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

You can use find and replace for making all the GB's in Capital.

 

Once all are Capital GB

 

Then find 16 GB and replace it with 16GB.

 

Regards,

Harsh Nathani