topic Re: Export a number to csv or txt without any html tag in App Development

Export a number to csv or txt without any html tag

msirinaydinie — Thu, 09 Sep 2021 11:52:13 GMT

Dear community,

I'm trying to export a number to csv than I use Web Connector(FTP/sFTP Connector ) to upload this csv to the sFTP server.

When I open the csv there are a lot of code ( I guess it is HTML /Xml code) which you can see below screen shot.

I want to put only the revenue number to the csv not any code.

My code block:

------------------------------------------

Let TotalRevenue = '$(ForeCastRevenue)' + '$(AirRmRevenue)' + '$(AncillaryRevenue)' - 635000000;

sFTP:
Load '$(TotalRevenue)' as Revenue
AutoGenerate(1);

Store Revenue from sFTP Into [lib://FLD_CBI/BoostOurBusiness/$(vToday).txt];

FileTransferConnector_SFTPUploadFile:
LOAD
Status as SFTPUploadFile_Status
FROM
[https://..]
(qvx);

------------------------------------------

My csv output from sFTP server is below:

I just wanted to put the revenue number which I marked yellow to csv. How I can delete XML code except -118145051,67957 (Revenue) ?

Many thanks in advance.

Re: Export a number to csv or txt without any html tag

stevejoyce — Thu, 09 Sep 2021 12:04:08 GMT

What if you do

Store Revenue from sFTP Into [lib://FLD_CBI/BoostOurBusiness/$(vToday).txt] (txt) ;

Re: Export a number to csv or txt without any html tag

sunny_talwar — Thu, 09 Sep 2021 12:04:53 GMT

Try by adding (txt) at the end of the store statement.

Store Revenue from sFTP Into [lib://FLD_CBI/BoostOurBusiness/$(vToday).txt] (txt);

Re: Export a number to csv or txt without any html tag

msirinaydinie — Thu, 09 Sep 2021 12:13:30 GMT

Thank you very much, Steve, it worked!

Re: Export a number to csv or txt without any html tag

msirinaydinie — Thu, 09 Sep 2021 12:15:36 GMT

Thanks a lot, Sunny. I also learned a lot of things from your answers to other topics.

You are the best 🙂

Have a good day.

Re: Export a number to csv or txt without any html tag

sunny_talwar — Thu, 09 Sep 2021 12:29:05 GMT

I am glad I have been able to help you learn 🙂

Re: Export a number to csv or txt without any html tag

msirinaydinie — Thu, 09 Sep 2021 14:29:35 GMT

Sunny, I need help with one more step in this process.

How can I delete double quotes on the number that I put into txt file.

Many thanks.

My Code Block:

-------

Let TotalRevenue = num('$(ForeCastRevenue)') + num('$(AirRmRevenue)') + num('$(AncillaryRevenue)') - 635000000;

sFTP:
Load Null() as '$(TotalRevenue)'
AutoGenerate(0) ;

Store '$(TotalRevenue)' from sFTP Into [lib://FLD_CBI/BoostOurBusiness/$(vToday).txt](txt);

FileTransferConnector_SFTPUploadFile:
LOAD
Status as SFTPUploadFile_Status
FROM
[https://...]
(qvx);

-------

Re: Export a number to csv or txt without any html tag

sunny_talwar — Thu, 09 Sep 2021 14:57:49 GMT

Looks like the double quotes show up because of comma, can you store your number using a decimal instead of comma?

Re: Export a number to csv or txt without any html tag

msirinaydinie — Fri, 10 Sep 2021 07:39:09 GMT

Yes, it worked. Thanks a lot, Sunny.

Have a wonderful day.