Prefix for Capital Letters only

[Anonymous]

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! 🙂

[jgeddes · Accepted solution]

= Table.TransformColumns(previousStep, {{"Column1", each if Text.PositionOfAny(_, {"A".."Z"}) = 0 then "prefix-"&_ else _, type text}})

[Anonymous]

Thanks for this, the additional solution you provided was really useful but your original post gave me the desired outcome I was after!

[jgeddes]

Text.Proper() may be a better solution for you.

= Table.TransformColumns(previousStep, {{"Column1", each Text.Proper(_), type text}})