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)
- Find any of the following values: (?:Variance|Variance %|All Periods|FY15|YTD)
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.