topic RE: Convert Text to collection in University Forum

Convert Text to collection

RajsudhapriyaCN — Fri, 16 Jun 2023 06:51:00 GMT

Hi All,

Can anyone help me with developing a code stage with C# or VB to convert text to collection

sample Input:

1.The capital of India.

Moscow

#Delhi

Kabul

Tokiyo

2.The capital of Japan.

Moscow

Delhi

Kabul

#Tokiyo

3.The capital of Afganistan.

Moscow

Delhi

#Kabul

Tokiyo

4.The capital of Russia.

#Moscow

Delhi

Kabul

Tokiyo

Output

------------------------------
Rajsudhapriya CN
------------------------------

Athiban_Mahamathi — Fri, 16 Jun 2023 09:41:00 GMT

Hi,

The easiest way to achieve this without a code stage is by using the BP VBO's such as Strings & Collection Manipulation.

Steps:

Use split lines action from Utility - Strings to convert the text into collection.
Use Remove Empty Rows action from Utility - Collection Manipulation to remove any empty rows.
Loop the output collection obtained in the above stage.
Check if the incoming row has any numbers in the text using regex match (Assuming the question value has a number. Based on the input string you can modify the regular expression)
If matched, then add a new row to the output collection and set the incoming value as question in the output collection.
if not matched, then the set the incoming string as option in the output collection. Use the choice stage and set the options in the output collection accordingly.
Output Collection
Workflow

------------------------------
Athiban Mahamathi ,
SimplifyNext,
Technical Consultant
------------------------------

plnarayana777 — Sat, 17 Jun 2023 05:27:00 GMT

it is not code stage but another simple way

Here "Pattern" is regex pattern

(?<Question>\d+.*)[\r?\n]*(?<option1>.*)[\r?\n]*(?<option2>.*)[\r?\n]*(?<option3>.*)[\r?\n]*(?<option4>.*)

Initial string is your string

Output is just undefined collection

will get output collection

you can remove first column as below

Provide collection name and column name you want to delete

Regards

------------------------------
Lakshmi Narayana
------------------------------