Data table filter wizard unable to filter column name that contain line breaks

[winnie_toh]

Dear all,
the column name contain line breaks, thus filter wizard seems unable to find.
any solution please?
i.e.:
Sep TTL
Allo

[Parvathy (PS Parvathy)]

Hi @winnie_toh

input= "Sep TTL
       Allo"
output= input.ReplaceLineEndings(" ")

After that you can use Filter Table wizard.

Hope it helps!!

[winnie_toh]

Thank you for responding!
may i ask which activity do i put this input and output?

[Parvathy (PS Parvathy)]

You can use that in assign activity @winnie_toh

Regards

[winnie_toh]

Thank you! do you mean to use a for each row loop then assign? (sorry noob here).

[Parvathy (PS Parvathy)]

Yes @winnie_toh . If possible share an sample excel and filter requirements I will help you out with that.

Regards,

[Yoichi]

Hi,

How about the following?

"Sep TTL"+vblf+"Allo"

OR

"Sep TTL"+vbcrlf+"Allo"

Sample workflow

Sample20230912-1L.zip (8.3 KB)

Regards,

[winnie_toh]

Thank you so much @Yoichi !! Yes it works now.

May i ask another question? i noticed the excel read range seems to be taking way too long. 15 columns, 1000 rows. Taking around 1.5 min for each read. is this normal? Using Use Excel function because i’m running on excel VSTO which requires to run the report (to read range) on the fly.

[Yoichi]

Hi,

It’s known that Modern ReadRangeX may be very slow in some sheet.
As workaround, can you try classic Read Range activity? It will also work in UseExcelFileActivity.

Regards,

[winnie_toh]

Thank you so much!! it literally went from 1.5mins to 5seconds. Grateful!!