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

627

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)

Sort by

Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 627 on at

Like (0)

Report
Copy link

Link copied!

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

{

recordContainer = importFile.read();

importFile is an AsciiIo Object

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

#2

Andrew Jones a1x 2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans