topic RE: text as collection in Product Forum

text as collection

ShreeAbhi — Tue, 05 Sep 2023 02:34:00 GMT

I have text file with 200 above details about policy number account number etc. But in blueprism studio I would like to see the text file using text as collection in a proper format. For instance, when we upload something or copy something into excel it will be according to the column and contents. Samething I want to apply in collection but in collection the row and details all are not in allignment .Please help me regarding on this.

------------------------------
Shree Abhi
------------------------------

RE: text as collection

harish.mogulluri — Tue, 05 Sep 2023 03:29:00 GMT

Hi shree abhi,

IS It possible for you to share the screenshots related to what You are expecting and how it is showing in collection

You can take sample data and replicate the issue in case if you are unable 5o share the screenshot

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------

RE: text as collection

DevendranVenkatesh — Tue, 05 Sep 2023 12:23:00 GMT

If possible can you please share the screenshot of text file to get more clarity.

------------------------------
Best Regards,
Devendran Venkatesh
RPA - Technical Architect |
Riyadh 11413, Kingdom of Saudi Arabia
Phone. +966-556784162
------------------------------

RE: text as collection

LeonardoSQueiroz — Wed, 06 Sep 2023 02:28:00 GMT

Hi,

Check the delimiter you are using, and see if it makes sense to perform preprocessing on the input to standardize the data.

Best Regards,

RE: text as collection

Babjee24 — Wed, 06 Sep 2023 06:35:00 GMT

Hi Shree,

That's possible if there is a pattern followed in the text that you're reading. For instance, if every column is separated by comma(,)/space/tab space then use split text with the respective delimiter.

------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------