Extract words from a sentence separated by comma

[blitzerox]

Hi there,

For example:
Given Sentence- "House, Building, Farm, Office"

How can I extract each words separated by comma and store them in my collection.

Cheers.

 

[rsingh40]

Hi Blitzerox,

Please give below solution a try:-

Input Data:- "House, Building, Farm, Office"
Step1:-
Use Utility - String
Action- Remove Non-Word Character
Output will be
House, Building, Farm, Office
Step 2:-
Use Utility - String
Action:- Split Text

The output will be in the collection
House
Building
Farm
Office

 

[blitzerox]

Hi Rsingh40,
I tried the above solution but it does'nt seem to do anything. it returns me the same text in a collection.

 

[blitzerox]

My bad. I wasn't passing the split character in action "split text". Now it works fine. Thanks a lot mate. Cheers