Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
Tips and Tricks
  • jgeddes's avatar
    jgeddes
    1 year ago
    = Table.TransformColumns(previousStep, {{"Column1", each if Text.PositionOfAny(_, {"A".."Z"}) = 0 then "prefix-"&_ else _, type text}})

     

     

jgeddes's avatar
jgeddes
Super User
1 year ago
= Table.TransformColumns(previousStep, {{"Column1", each if Text.PositionOfAny(_, {"A".."Z"}) = 0 then "prefix-"&_ else _, type text}})

 

 

jgeddes's avatar
jgeddes
Super User
1 year ago

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

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