Delimited text file with space separator except when the field is between quotes

1

I have a delimited text file with spaces as a separator (a log file) and I want every field to be splitted in a separated column except when the field is between double quotes. (As can be done with the CsvStyle.QuoteAlways argument in PowerQuery)

Is there a way?

2

Quoting is, by default, automatically supported in EasyMorph. So it works out of the box. See the example below.

load-log.morph (2.4 KB)
log.txt (16 Bytes)

image

1 Like
3

log.txt (144 Bytes)
Would you try this one in your .morph above?
Here is my result:
image

4

It works correctly - quotes are supposed to be around values, not inside them. Therefore, for instance, the value below isn't considered quoted because it doesn't start with a quote.

msg="New England"