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}})

 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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