Exam 70-778 topic 1 question 130 discussion

Actual exam question from Microsoft's 70-778

Question #: 130
Topic #: 1

HOTSPOT -
You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

.
How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

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

by Ley at Jan. 20, 2020, 9:10 p.m.

Comments

Submit Cancel

Dirk

Highly Voted 5 years, 3 months ago

It works like this: "Replace" will retrieve a "-" instead of " ". "Text.End" will take the last 12 characters of the string. This will keep all numbers like they are except the one in line 5. Line 5 will end up with: 500-555-0122. It would have been helpful to know before how the result should look like.

upvoted 26 times

...

CDL

Most Recent 4 years, 7 months ago

if not in M code, we do in PQ editor thru ribbon tab 1. Extract - > Last characters -> 12 (keep 12 digits started from the end) 2. Replace Value -> Replace " " with "-" 3. Load to..

upvoted 3 times

...

Vivekrs

5 years, 4 months ago

Why do we need to use text.end when replace alone will work ?

upvoted 1 times

calibear

5 years, 4 months ago

How can you do this using just the Replace command? just curious :)

upvoted 3 times

CYRUSD

5 years, 1 month ago

Then you need to remove 1 (11) from the line 5. the answer is correct

upvoted 1 times

...