Extracting the first comma separated value to a new column

[kenzzzo82]

This seems like it should be easy but I am having a bit of trouble. I have a list of clients each client has multiple servers. Each server for that client has the same specs and I have a separate spreadsheet with Specs on it. 

So to join the two together I just need one common server. 

The Webserver column lists the servers as "Server1,Server2,Server3"

I want to extract Server1 only for each client and populate a column called FirstServer. I can then join on that value to add in the specs for each client. Hope that makes sense 🙂 

[Gui_Costa]

Hey Buddy.

You can use the "Extract" function, under the Transform tab in the query editor. This function allows you to choose the separator, in your case, the comma. 

Hope it helps

Regards

[kenzzzo82]

I am new to using PowerBI Desktop and I only see Home and Modeling tabs. Do I need to add tabs in options some where?

[MarcelBeug]

No, you can choose "Edit Queries" on the Home tab.

Then you will see the tabs and options we mentioned previously.

[kenzzzo82]

Worked perfectly. Thanks guys!

[MarcelBeug · Accepted solution]

In addition: if you want the result in a new column: choose Extract in the "Add Column" tab.

In the Extract submenu, "Text Before Ddelimiter" should suit your needs,