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

Did this answer your question?