Load data from txt file with specific separator

there's some way to specify a character separator different from predefined (CSV, TAB) to load data from log-file separated by e.g. pipe "|" ?

thanks

giovanni