Creating a datatable from a string with spaces as delimiters

Help
, ,
8

Hi,

Have you tried to use the “Generate Data Table” Activity?

If you know the Columns in advance, I would recommend specifying the ColumnSizes properties.

For your extra spaces, are you sure those aren’t “tabs” (see below)?

If not, you could replace “more than one space” by “One space”. You can do it with the Replace Activity with the Pattern “\s+” ==> “”

Cheers

6 Likes