LIKE or CONTAIN operator in calculation field to find part of a string

Answered

Follow

Edwin Martin

• April 09, 2015 12:55

I wish to filter a field (containing bank account numbers) based on (for example) the last four characters in order to group a list of bank account statements by bank accounts (since I import statements from more than 1 bank account in the same app). What operator do I need to use? I only know the equal (==); but not the LIKE operator. Thank you.

0

• 

  Rainer Grabowski (FVM)

  • April 09, 2015 13:32

  With this you can get the last 4 characters of the string, than you can compare it in an IF-Condition:

  var a = @fieldName
  var b = a.slice(-4)
  b == "4321" ? "than do this" : "or do that"
  

  Rainer
  rg@delos-consulting.com

  0

  Comment actions Permalink
• 

  Edwin Martin

  • April 09, 2015 14:12

  thank you!

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • April 13, 2015 13:48

  If you just need to check whether a string contains a aubstring ("4321", regardless of its position), you can use:

  var a = @Field.indexOf("4321")
  a > -1 ? "Action if true" : "Action if false"
  

  0

  Comment actions Permalink
• 

  Rikke Olesen

  • August 18, 2023 06:02

  hi,

  I need the samt only based on the two first of "4085500 PUV" in this case "40"
  What should I write?

   

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 20, 2023 15:53

  Hi RIkke,

  var text = @Name of the field where the id is in;
  var first2 = text.substr(0,2);
  first2 == "40" ? do this : do that

  0

  Comment actions Permalink
• 

  Rikke Olesen

  • October 05, 2023 06:47

  Hi,

  I can't get it to work. Can you help once again.

  Fieldname for collecting date filtrede on the two first words are "[(Ref Item no.) Artwork no.]" 
  Filer on "40", "41" and "42" ect.

  I nedd til pull tekst from "[(Ref Item no.) Tekst]"

  Thanks

  0

  Comment actions Permalink

Please sign in to leave a comment.