Skip to main content
A
ayushim
May 20, 2021
Question

How to compare string elements

  • May 20, 2021
  • 7 replies
  • 1 view

How to compare letters of a single word in Appian:

Suppose,

We have to compare letters of word "Apple". The output should be:

1. Number of unique characters in word. In case of "Apple", it should be 4

2. Could of similar characters. Ex: In case of "Apple", A=1,p=2,l=1,e=1

Please provide code for this.

    7 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    May 20, 2021

    Is this some test? Similar question has been asked just recently. Please check the search function.

      A
      ayushimAuthor
      May 25, 2021

      Hi Stefan,

      It is not related to any test. I was learning about strings in Appian and this question strike in my mind.

      Thank you so much for your response. 

      davel001150
      davel001150
      May 20, 2021

      First, my favorite method of breaking a text into an array of texts: char(code(local!text))

      Then, remove duplicate values with union, then grab the length().

      local!splitText: char(code(local!text)),

      length(union(local!splitText, local!splitText))

      To do the second one, you need to have (or make) a split alphabet.  Then a!forEach:

      a!forEach(

      items: local!splitAlphabet,

      expression: fv!item & wherecontains(fv!item, local!splitText)

      That's how I'd do it, or at least how I'd start.

      A
      ayushimAuthor
      May 25, 2021

      Thank you

      ranjiths0003
      ranjiths0003
      May 20, 2021

      Hi Ayushimitaal,

      Use Below Code

      a!localVariables(
  local!word: "apple",
  local!letters: apply(
    charat(local!word, _),
    enumerate(len(local!word)) + 1
  ),
  local!unique: union(local!letters, local!letters),
  a!flatten(
    a!forEach(
      local!unique,
      {
        fv!item & ": " & count(wherecontains(fv!item, local!letters))
      }
    )
  )
)

      A
      ayushimAuthor
      May 25, 2021

      Thank you for your suggestion.

      Terms & ConditionsAccessibility statement