Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
2019-03-01-PID 004-327-659 - 12851 Bathgate Way, Richmond.pdf
I have a column of unstructured data as mentioned above, and i was wondering if there is a way to create a new column and only display the data in red. All the rows have the words "PID" in them.
thanks,
Solved! Go to Solution.
The error happens if Name2 does not contain "PID"
So we can modify the formula to return blank if the search value is not found
pidcolumn =
The format of required part is PID nnn-nnn-nnn
If this is always the case, then you can add a calculated column with the following formula
newColumn =
Correction..
newColumn =
it didn't work.
@yelsherif wrote:Correction..
newColumn =
var leftPosition = FIND("PID",[sourceColumn])returnmid([sourceColumn],leftPosition,15)
@yelsherif wrote:Correction..
newColumn =
var leftPosition = FIND("PID",[sourceColumn])returnmid([sourceColumn],leftPosition,15)
@yelsherif wrote:Correction..
newColumn =
var leftPosition = FIND("PID",[sourceColumn])returnmid([sourceColumn],leftPosition,15)
The error happens if Name2 does not contain "PID"
So we can modify the formula to return blank if the search value is not found
pidcolumn =
thank you so much. it worked
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
59 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |