This depends on what the "|" character is separating.
The documentation for "load data" is located here and explains the different potential uses of a separator.
If "|" separates fields, use fields terminated by "|." If "|"separates rows, use lines terminated by "|."
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.