web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Remove quotes during f...

Microsoft Dynamics AX (Archived)

Remove quotes during file import

(0) Share

Report

Report

Posted on by CRSW

625

Hi

I created a class to import data from a csv file. The data is text-based so I create a record container holding all single Values as string

Now the text file provided from Paypal look like this

""04.09.2019"",""EUR"",""-37"",""ARGSHRT453F"",...

How can I remove the second quotes around the values?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

Could we see your code that populates this container? The appropriate moment to remove the extra quotation marks would be before you put the values into the container.

You can use strRem function to remove unwanted characters from your string variables.

Was this reply helpful? Yes No
CRSW 625 on at

Like (0)

Report

while(importFile.status() == IO_Status::Ok)

{

recordContainer = importFile.read();

importFile is an AsciiIo Object

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

Here's an example where we remove quotes from string variables inside a container:

    container myCon1 = ['"foo"', '"bar"'];
    container myCon2;
    str myValue;
    int i;

    info(con2Str(myCon1));
    for (i = 0; i <= conLen(myCon1); i++)
    {
        myValue = conPeek(myCon1, i);
        myValue = strRem(myValue, '"');
        myCon2 += strRem(myValue, '"');
    }

    info(con2Str(myCon2));

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans