Help Desk

Submit a ticket My Tickets
Welcome
Login
Answered

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

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

Answer
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 support@onecloud.io.

  • 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