Removing Breaks Or Carriage Returns From Table.

[dexter8203 0]

Hi,

 

This is my first time posting a questions as I've usually been able to find what I'm looking for online. 

 

My bot is scraping a table.  When I scrape the table, I'm copying two of the columns to a list. 

 

Within each list item is an array of values that are line followed by line breaks.  Ideally I would like to replace the line breaks with a "," or a "SPACE"  . 

 

 

For example, a given field in the table or list item will contain

 

01CA

02DW

0319

0423

0431

 

 

I need it to be 01CA, 02DW, 0319, 0423, 0431.  

 

I'm hopeful someone here can point me in the right direction.

 

 

[deliter 203]

my regex sucks but this should work

set(#item,"01CA

 02DW

 0319

 0423

 0431","Global")
set(#newItems,$replace regular expression(#item,"\\s+|/n",","),"Global")

[Varo 28]

No need |/n  just \s+

set(#item,"01CA

 02DW

 0319

 0423

 0431","Global")
set(#newItems,$replace regular expression(#item,"\\s+",","),"Global")

[dexter8203 0]

thank you.  This is exactly what i needed.