Log in to AnswerLog in to Follow
Ali Maladwala
324Views
8Comments
Solved
[CSVUtil] FieldDelimiter
Question
Forge
CSVUtil
Forge component by Wei Zhu

Is there anyway to have no FieldDelimiter when setting up the CSV export config. I am trying to export a Recordlist to a file without any additional text formatting and setting the FieldDelimiter to "" still adds commas.


Thanks

0
0
26 Feb 2019
Wei Zhu
Solution

Hi Ali


You can find following code in MssExportRecordList2CSV

  sb.Append(config.Separator);

Just delete it.


Regards

Wei




See solution in context
1
0
27 Feb 2019
Craig St.Jean
mvp_badge
MVP

Hello Ali Maladwala,

In the extension's code, in MssExportRecordList2CSV, it only sets your delimiter if you provide one:

CsvConfig config = new CsvConfig();
if (!string.IsNullOrEmpty(ssConfig.ssSTCSVExportConfig.ssFieldDelimiter))
    config.Separator = ssConfig.ssSTCSVExportConfig.ssFieldDelimiter[0];

This is why it still adds the commas when you have an empty delimiter.  You could try updating the C# code to remove the empty check, though I am not sure if the included CSV library will override it or not.

The CSVUtil is probably not the best component for your use case, as your use case is not to produce a CSV.  Is it safe to assume your goal is simply to write a record to a flat file with a newline between items?

1
0
26 Feb 2019

Craig St. Jean wrote:

Hello Ali Maladwala,

In the extension's code, in MssExportRecordList2CSV, it only sets your delimiter if you provide one:

CsvConfig config = new CsvConfig();
if (!string.IsNullOrEmpty(ssConfig.ssSTCSVExportConfig.ssFieldDelimiter))
    config.Separator = ssConfig.ssSTCSVExportConfig.ssFieldDelimiter[0];

This is why it still adds the commas when you have an empty delimiter.  You could try updating the C# code to remove the empty check, though I am not sure if the included CSV library will override it or not.

The CSVUtil is probably not the best component for your use case, as your use case is not to produce a CSV.  Is it safe to assume your goal is simply to write a record to a flat file with a newline between items?

Hello Craig St. Jean,

My use case is writing a record list to a flat file with a new line between records. Each record is written without delimiters (the record fields have a known fixed character width and have to remain that way). Is there a generic way to flatten a record to a string in Outsystems(like a toString() override), or would I have to write an extension that will handle my specific Entity types?


Thanks,

Ali


0
0
26 Feb 2019
Wei Zhu
Solution

Hi Ali


You can find following code in MssExportRecordList2CSV

  sb.Append(config.Separator);

Just delete it.


Regards

Wei




1
0
27 Feb 2019

How about using tab character as FieldDelimiter? It doesn't work when I try this "\t" in FieldDelimeter.


PS: Both tried this "\t" and "/t", still doesn't work. </3

Thank you very much :D
Gerrick

0
0
29 May 2019

@Gerrick, try Chr(9) instead of "/t"

2
0
29 May 2019

@Jonathan Lui,


Thank you very much, it works perfectly! :D

0
0
29 May 2019

Hi for me data is coming in one cell with comma separated not in separate columns. can anyone help me on this?

0
0
09 Sep

Because you said one cell,  usually it is Excel not CSV.

So could you please provide your data ?
We can understand what's the problem.

0
0
11 days ago
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.