Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i need to split this column by the left most delimiter "/", how can i do this.
I have the follwing code but it didn,t work for me
ABC/DDD/AAA/CCC | ABC | DDD/AAA/CCC |
Solved! Go to Solution.
Hi @Yqy,
The formula you provided seems to be correct, but you may need to adjust it if the data in your column does not always have the same number of delimiter characters ("/").
Here's the modified formula that you can try:
= LEFT('Data'[Column 1], FIND("/", 'Data'[Column 1] & "/")-1)
The difference is that we added a "/" character at the end of the column data in the FIND function. This is to ensure that the formula always finds a delimiter character, even if the original data does not end with one.
Alternatively, you can use the Text.Split function to split the column data by the delimiter and extract the first element of the resulting list. Here's the formula for that:
= Text.Split('Data'[Column 1], "/"){0}
This formula splits the column data into a list using the delimiter "/", and then extracts the first element of the list (which corresponds to the text before the first delimiter).
Best regards,
Isaac Chavarria
If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly
Hi @Yqy,
The formula you provided seems to be correct, but you may need to adjust it if the data in your column does not always have the same number of delimiter characters ("/").
Here's the modified formula that you can try:
= LEFT('Data'[Column 1], FIND("/", 'Data'[Column 1] & "/")-1)
The difference is that we added a "/" character at the end of the column data in the FIND function. This is to ensure that the formula always finds a delimiter character, even if the original data does not end with one.
Alternatively, you can use the Text.Split function to split the column data by the delimiter and extract the first element of the resulting list. Here's the formula for that:
= Text.Split('Data'[Column 1], "/"){0}
This formula splits the column data into a list using the delimiter "/", and then extracts the first element of the list (which corresponds to the text before the first delimiter).
Best regards,
Isaac Chavarria
If this post helps, then please consider Accepting it as the solution and give Kudos to help the other members find it more quickly
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |