Split values from Data table and update it in another new columns

[Sathish_Kumar_S]

This is the input Data Table file:
InputDT.xlsx (10.3 KB)

Input dt Contains 3 columns, We need to create another Datable with 4 columns ( DocNo , Version , Language,Status) OR we can add this new four columns in same DT

1. Status Column: Filter and keep only the rows contains Approved in Col3 column and keep the text to Status column in new DT
2. DocNo Column: Split the text before | ( pipe symbol) from Col2 column from input DT and store into DocNo column in new DT
   Example: AA-015
3. Version Column: Split the text available between | ( pipe symbol) and (valid) text and store into version column in new DT.
   Example 2024.03
4. Language Column: Get the values from Col1 column from input DT
   A. Remove “Please Request or Approved “(only if it available )
   B. If both ED & EN or DE & EN text is available, then capture only “EN”
   C. If only ED or EN or DE text is available, then capture as it is
   And store into Language column in new DT.

Expected output

Please refer expected outputDT file:
expected_output_dt.xlsx (10.8 KB)

@ppr

[Nawazish_Ahmad]

Hi @Sathish_Kumar_S

Try this:

---

Forum.zip (2.5 KB)

---

Hope it’ll helps you
Cheers!!

[Sathish_Kumar_S]

Sure. I will try and update you… Thank you