Using Delimiter

[moizhlag]

Mostly in the CSV format, text to column are not always sorted and formatted completely. By using input data tool > Row 5 > Delimiter can easily format the report for you.

For Example, if report output comes is in below format:

DATE;SALES OFFICE;COUNTRY CODE;ETC

By entering delimiter ";" you can easily do the similar function of Text to column and data would come in this format:

DATE

SALES OFFICE

COUNTRY CODE

[BrandonB · Accepted solution]

Thanks for sharing @moizhlag and welcome to the Community!