Tab as delimiter

(0) Share

Report

Posted on by Lakshmi Karambakkam

1,289

Hi,

I am generating a TextStreamIO file and saving it as a CSV file attachment. I am planning to use tab as delimiter. I cannot use comma as a delimiter as one of my table field values has commas in its data. I am inserting all table fields value in a container.

But the code I am writing is not populating the data properly. All the table fields info is getting populated in the first column of CSV file rather than each table field info getting displayed in each column.

public class xxxxxxxService
{
xxxxxxxContract contract;
CustTrans currentTrans;
container custTrans;
TextStreamIo io;
System.IO.Stream stream;

}

private void initIO()
{
io = TextStreamIo::constructForWrite(65001);
statementAsOfDate = contract.parmToDate();

io.outFieldDelimiter(///);
}

protected void populateStreamline()
{
CustTable custTable = CustTable::find(currentTrans.AccountNum);

custTrans = [
custTable.PaymTermId, //Payment terms
currentTrans.TransDate, //invoice date
currentTrans.Invoice, //Invoice #
currentTrans.Txt, //Description
];
recordCount++ ;
io.writeExp(custTrans);

}

All responses (2)

Answers (1)

Verified answer

Martin Dráb 230,056 Most Valuable Professional on at

Like (0)

Report

Tab as delimiter

Also note that it won't CSV (comma-separated values) anymore and that CSV does support values containing comma, which nullifies your reason for a different separator. It's done by putting quotation marks around the value.
Suggested answer

Layan Jwei 7,339 Super User 2024 Season 2 on at

Like (0)

Report

Tab as delimiter

Hi,

I think this is what represents tab:

outFieldDelimiter("\t")

So replace your delimiter with this and try it.

For more details, please check this link

https://community.dynamics.com/blogs/post/?postid=a99566c0-60b5-4e3a-b243-6303364a4d3f

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future