Exam 70-778 topic 1 question 128 discussion

Actual exam question from Microsoft's 70-778

Question #: 128
Topic #: 1

DRAG DROP -
You have a column named phone_number. The values in the columns are in one of the following formats:
✑ 999-999-9999x123
✑ 1-999-999-9999x232
✑ +1-999-999-9999x667
The values after x in the phone_number column indicate the phone extension.
You need to create a custom column in Query Editor that contains only the phone extensions.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

References:
https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter

by PowerUser2020 at May 24, 2020, 5:18 p.m.

Comments

Submit Cancel

CDL

4 years, 9 months ago

correct, example: Get the portion of "111-222-333" after the second hyphen from the end. Text.AfterDelimiter("111-222-333", "-", {1, RelativePosition.FromEnd}) result: "222-333" https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter

upvoted 1 times

CDL

4 years, 8 months ago

https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter https://docs.microsoft.com/en-us/powerquery-m/relativeposition-fromend

upvoted 1 times

...

Mar_tin

5 years, 1 month ago

@rainbowstuf, you are right, Text.AfterDelimiter([phone_number],"x") you get the result as well. Why they add the additional formula parts?

upvoted 2 times

ioioyou

5 years, 1 month ago

the additional part is optional for Text.AfterDelimiter. It means to find the first x from the end of text. I think it is a guarantee in case any phone_number has more than one x in the text.

upvoted 9 times

...

rainbowstuf

5 years, 2 months ago

as per the answer, you will get only phone numbers not the extension, to split the extension just the after delimiter is enough

upvoted 2 times

...

PowerUser2020

5 years, 2 months ago

https://docs.microsoft.com/en-us/powerquery-m/text-afterdelimiter

upvoted 1 times

...