Reverse the words in english only (there are two languages in the column)

[545]

I'm trying to reverse the words in english because they came out reversed for example koobecaf should be facebook, here's the catch, there are words in a different language which came out fine so i dont want to reverse those.

My idea is to reverse the cells with english letters only while leaving the other language(a-z, A-Z).

note: the other language does not use latin letters so that should make things easier.

[545]

let
    Source = Sql.Database(ServerAddress, DbName),
    dbo_DVDR_LEADSOURCES = Source{[Schema="dbo",Item="LEADSOURCES"]}[Data],
    #"Filtered Rows" = Table.SelectRows(dbo_DVDR_LEADSOURCES, each ([LEADSOURCE] <> 0))
in
    #"Filtered Rows"

this is the code i have, when i tried to add yours it showed an Eof error @dufoq3  @Vijay_A_Verma 

[dufoq3 · Accepted solution]

let
    Source = Sql.Database(ServerAddress, DbName),
    dbo_DVDR_LEADSOURCES = Source{[Schema="dbo",Item="LEADSOURCES"]}[Data],
    #"Filtered Rows" = Table.SelectRows(dbo_DVDR_LEADSOURCES, each ([LEADSOURCE] <> 0)),
    Ad_Corrected = Table.AddColumn(#"Filtered Rows", "Corrected", each
      if List.ContainsAll({"a".."z", "A".."Z"} & Text.ToList(" .,/*-+=-!~';\/|"), Text.ToList([LEADSOURCENAME]))
      then Text.Combine(List.Reverse(Text.ToList([LEADSOURCENAME])))
      else [LEADSOURCENAME],
  type text)
in
    Ad_Corrected

[dufoq3]

Hi @545, you can try something like this

If you want to ass more characters to include in correction, you can add them into pink box

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WKqlILVHIKM7MSc9zVYrViVbKzs9PSk1OdANzchOL0hNLivM8wbz0tJTiI71HFx5dCiLBQkf2HV0IFAWiwwuPLjy8FohXKsXGAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    Ad_Corrected = Table.AddColumn(Source, "Corrected", each
      if List.ContainsAll({"a".."z", "A".."Z"} & Text.ToList(" .,/*-+=-!~';\/|"), Text.ToList([Column1]))
      then Text.Combine(List.Reverse(Text.ToList([Column1])))
      else [Column1],
  type text)
in
    Ad_Corrected

[Vijay_A_Verma]

Need examples of some sample data.