Extracting value between two values

To achieve the desired output in Alteryx Designer, you can use the "Text to Columns" tool along with some text manipulation functions. Follow these steps:

Text to Columns:
- Use the "Text to Columns" tool to split the "Internal ID" column based on the "_" delimiter. This will create two new columns, and you can remove the original column if needed.
Formula Tool:
- Use the "Formula" tool to create a new column that removes the "ALT_" prefix and any characters after "CNYF" in the second part of the split.
- In the Formula tool, create a new field (let's call it "Cleaned ID") with the following expression:
  plaintextCopy code
  Trim(Replace([SecondPart], 'CNYF.*', ''))
This expression replaces everything after "CNYF" with an empty string.
Final Adjustment:
- Use another "Text to Columns" tool to split the "Cleaned ID" column based on "CNYF" to get the values you want.

Here's a workflow representation:

Input Data -> Text to Columns (Delimiter: "_") -> Formula Tool -> Text to Columns (Delimiter: "CNYF")

This workflow should give you the desired output. Make sure to adjust column names and field types as needed in your specific use case.

rohit782192

@Masond3 The Simple way to work is use a Data Cleansing Tool and Select Letter and Punctuation.

It will solve all your problem.

Qiu

@Masond3
I will do the same as @MilindG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703