Forum Discussion
Prefix for Capital Letters only
Hi,
Couldn't find anything to suggest a solution to my conundrum!
I have 2 tables containing website keywords and phrases, some being duplicates with the only difference being capitalisations on the first word.
When I'm trying to build my relationships in PBI, as it's not case sensitive, I keep only getting the option for many-many relations when the desired outcome is to have a 1-1 relationship.
Is there any way to add a prefix to the first word if the first letter is capitalised?
Thanks in advance! 🙂
= Table.TransformColumns(previousStep, {{"Column1", each if Text.PositionOfAny(_, {"A".."Z"}) = 0 then "prefix-"&_ else _, type text}})
3 Replies
= Table.TransformColumns(previousStep, {{"Column1", each if Text.PositionOfAny(_, {"A".."Z"}) = 0 then "prefix-"&_ else _, type text}})Text.Proper() may be a better solution for you.
= Table.TransformColumns(previousStep, {{"Column1", each Text.Proper(_), type text}})