Search for string within a text fields

Follow

Ottar í Hjøllum

• April 18, 2016 19:33

I have a excel sheet that I want to import in to Podio. I then want to search and return within one of the column, if a particular ID number is there. 

Let me give an example: 

If the the fields says "Hello my registration number is XYZ123455", I want to write short PHP code that would search for the string "XYZ" and then return XYZ + the following 6 numbers. So that the end result in my calculation would be XYZ123455. 

Hopefully this makes sense and someone is able to help me.

Thank you in advance.

1

• 

  Rainer Grabowski

  • April 18, 2016 20:56
  • Edited

  Hi Ottar,

  Podio calculation fields use Javascript, not PHP. :)

  I assume, the text ""Hello my registration number is XYZ123455" is in a text field.

  This script should get what you want (even if there is text behind the number): 

  var text = @your text field name;
  text.indexOf("XYZ") > -1 ? text.substring(text.indexOf("XYZ"),text.indexOf("XYZ")+9) : ""

  If XYZ is in the text then show XYZ+number, else show nothing (calc fields stays empty).

  Rainer

  1

  Comment actions Permalink
• 

  Simon Midtgaard Guldberg

  • August 14, 2018 13:13

  Thank you Rainer!

  0

  Comment actions Permalink
• 

  Jose Antonio Moyano

  • October 18, 2019 10:50

  Hi rainer

  I need help you please.

   

  I need to get "1" if I find the string "Box" and "0" if I dont find.

  texto var: @All of Cód Tarifa.join ();

  text.indexOf ("Box")> -1? text.substring (text.indexOf ("XYZ"), text.indexOf ("XYZ") + 9): "" (I dont understand this sentence, please help Rainer)

  
  Thanks

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • October 18, 2019 15:39

  Hello Jose Antonio,

  var text = @All of Cód Tarifa.join ();
  text.indexOf ("Box") > -1 ? 1 : 0

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.