Help Desk

Submit a ticket My Tickets

How to Incorporate Multiple "Find and Replace" into a Single Command.

How can I to incorporate multiple find and replace into a single Command?

By using a regular expression, you can search for multiple values and then replace any one value with another single value. Follow this steps and enter there the appropriate syntax:

  • Use the OneCloud Tabular Transformation BizApp and select the "Find and Replace Command".
  • Enter the following syntax in the Find parameter field:

    • Find any of the following values: (?:Variance|Variance %|All Periods|FY15|YTD)

    • Find any of the following values with an exact match: (?:\bVariance\b|\bVariance %\b|\bAll Periods\b|\bFY15\b|\bYTD\b)

If you need additional support, please contact

  • This is helpful, but is there a way to have multiple replaces that are dependent on what is found?

  • Hi Mike - this feature is not yet supported. This feature will be introduced shortly as a part of a new OneCloud product offering known as OneCloud Mapping Studio which will be available in Q2 2020. This capability, however, will not be a part of the Find & Replace Command in the Tabular Transformation. Thanks again for your interest and we appreciate your questions. 

Login to post a comment