LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ripleym

Hi,

I am trying to use the Delimited File node to import files that have a space as the field delimiter, specifically IIS logs. I have Log Parser, incidentally, I am just checking whether BRE can provide more insights, in a quicker way and allow me to productionise this more easily than using Powershell, for example.

The problem I have is that I cannot figure out what to put in the field delimiter in order to split the file into its relevant columns. I have tried the following:
\s
space
''
""
' '
" "

None of the above appear to work. I have specified the column names to output; this has the added benefit of not using the first row as column headers, which causes an error, and also allowing me to filter out the first 4 rows, which begin with #. However, all data continues to appear in the first column, which in my case is "date".

Thanks in advance.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

Try using \x20 as the field delimiter. That's the hex value for the ASCII character space.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ripleym

Thanks - that has done the trick. I'd have been banging my head forever..!