Please help me to understand and extract

Help Studio
, ,
1

PROD- potassium
DORD-Dubnium

input:
20203107PORD
20202101PORD
20200302DORD
20200502PORD
20200102DORD

how i can read each item and segregate if PORD is potassium and DORD is Dubnium?

2

Hi @Venu_V

1.Is the input present in datatable?
2.Do you need to write output in 2 sheets like Potassium and Dubnium sheets?

If that is the case then try like below

potassiumDT = (From row In InputDT.AsEnumerable()
               Where row("ColumnName").ToString.Contains("PORD")
               Select row).CopyToDataTable()
dubniumDT = (From row In InputDT.AsEnumerable()
             Where row("ColumnName").ToString.Contains("DORD")
             Select row).CopyToDataTable()

Regards,

3

@Venu_V,

What’s source of data and datatype?
What’s expected output?

4

input is of string type . And output it has to write string only .

5

@Venu_V

Try this

Potassium = String.Join(", ", Input.Split(Environment.NewLine.ToCharArray).Where(Function(x) x.Contains("PORD")))

Dubnium = String.Join(", ", Input.Split(Environment.NewLine.ToCharArray).Where(Function(x) x.Contains("DORD")))

This image shows a sequence of activities in a flowchart, where an input string "20203107PORD" is assigned and processed with String.Join, followed by Write Line activities outputting the processed values for "Potassium" and "Dubnium." (Captioned by AI)
This image shows a sequence of activities in a flowchart, where an input string "20203107PORD" is assigned and processed with String.Join, followed by Write Line activities outputting the processed values for "Potassium" and "Dubnium." (Captioned by AI)818×703 33.9 KB

Output:

An output log shows the execution process for file "Sequence18" with detailed information including the start and end of "BlankProcess23" and entries for Potassium and Dubnium with associated dates and codes. (Captioned by AI)

Regards,

6

Perfect. Thank you so much

7

@Venu_V

Glad it helped! Can you please mark it as solution to close the thread

Regards,

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.