Microsoft Dynamics AX (Archived)

remove " " from the text when exporting into .TXT format in ax 2012 using x++

(0) Share

Report

Posted on by akshaykupra

516

Dear all,

i have to export data from ax to .txt form , everything is working but i want output like given screen without " "

static void askexportfile(Args _args)
{

CommaIO CommaIo;
FileName fileName;
;

fileName = @'D:\Support\akshay\' + custinvoicejour.InvoiceId + ".txt";//".csv";

CommaIo = new CommaIO(fileName,'W');
CommaIo.write('Name','ItemName,','Qty');

CommaIo.outRecordDelimiter(" ");

CommaIo.write("akshay","10001",6 );

}

WINAPI::shellExecute(fileName);
}

Output

28832.Capture.PNG

how do i get file without " " this. Like

28832.Capture.PNG

Please provide me solution on this how do i achieve this.

Thanks

Akshay

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (3)

Martin Dráb 237,978 Most Valuable Professional on at

Like (0)

Report

The picture looks the same. Can you upload the right one?

I assume you get quotation marks around text values, right? That's the usual way in CSV; it makes sure that the file isn't interpreted incorrectly if a text field contain a comma. Why is it a problem for you? All tools should understand it.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

It's cause by CommaIo.outRecordDelimiter(" "); so remove it and replace with #delimiterCRLF for example from [tag:File] macro

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

hi Martin,

actually i want Remove Double quote from string, client want that. generally it comes with string. but i want when data export it should be without double quotes

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

Hi ievgen,

could you please be more specific, i mean like code. please it would be helpful

Was this reply helpful? Yes No
Martin Dráb 237,978 Most Valuable Professional on at

Like (0)

Report

You should ask them why they want it. Maybe you would be merely hiding a bug in their processing of CSV format.

Also, you would have to decide what do if a string contains a comma and you would have to add code to handle this situation, if you explicitly reject the usual solution.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Sorry but now I'm not sure what do you want because you have 2 identical pictures in your original question, so it's hard to understand what do you want to change.

Was this reply helpful? Yes No
akshaykupra 516 on at

Like (0)

Report

hello ievgen,

this is my fault i have not notice

this actually image

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,978 Most Valuable Professional on at

Like (0)

Report

If I was, I would first find out why they want it. They may actually need help somewhere else and this requirement may be a result of a wrong decision.

But if you want, you can write any text you like through TextIo class.

Was this reply helpful? Yes No
Verified answer

akshaykupra 516 on at

Like (1)

Report

Hi Martin and ievgen,

Problem solved by TextIo Class as you suggest by Martin. they want to upload this file to there software where they want formate like this.

Now Output is : removed double quotes

i used in sample code, problem is solved thank you for your support

static void Job29(Args _args)

{

container c;

TextIO myfile;

FileIoPermission perm;

str message;

#define.ExampleFile(@"D:\myfile.txt")

#define.ExampleOpenMode("w")

// Set code access permission to help protect the use

// of CommaIO.new

perm = new FileIoPermission(#ExampleFile, #ExampleOpenMode);

perm.assert();

myfile = new TextIO(#ExampleFile, #ExampleOpenMode);

c = [1,"aks",1.324,"Last field"];

myfile.outFieldDelimiter(",");

myfile.writeExp(c);

// Close the code access permission.

CodeAccessPermission::revertAssert();

}

Was this reply helpful? Yes No