Jump to content

Search the Community

Showing results for tags 'fyi'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 1 result

  1. Just wanted to share this workflow that I used to get a specific data from a field that uses ';' to separate inputs. Ex input: Manager;Donald Duck;Donald@gmail.com The formula below will show the 2nd input (Donald Duck) as an output if it detects at least 2 ';' are inside the string and if it only detect 1 or less ';' it will output a blank field. CASE WHEN Charindex(';',[@field:Original_value], 0) > 0 AND Charindex(';',[@field:Original_value], (Charindex(';',[@field:Original_value])+1)) > 0 THEN Substring([@field:Original_value], (Charindex(';',[@field:Original_value], 0)+1), (Charindex(';',[@field:Original_value], (Charindex(';',[@field:Original_value])+1))-Charindex(';',[@field:Original_value], 0)-1)) WHEN Charindex(';',[@field:Original_value], 0) = 0 THEN '' END table snippet: Just a note: You can edit this formula to check for other delimiters not just ';'
×
×
  • Create New...