AnsweredAssumed Answered

how to process the below File format. Please note there are 3 different type of delimiters in the same file. What's the easiest way to do it in Boomi? PO1999-10-20 US        Alice Smith         123 Maple Street    Mill Valley    CA 90952 US        Robert

Question asked by amit_dhamane Employee on Sep 14, 2018
Latest reply on Sep 16, 2018 by Sjaak Overgaauw

How to process the below File format. Please note there are 3 different type of delimiters in the same file. What's the easiest way to do it in Boomi?


PO1999-10-20
US        Alice Smith         123 Maple Street    Mill Valley    CA 90952
US        Robert Smith        8 Oak Avenue        Old Town       PA 95819
ITEMS,ITEM872-AA|Lawnmower|1|148.95|Confirm this is electric,ITEM926-AA|Baby Monitor|1|39.98|Confirm this is electric

Outcomes