How to find file type either .XLSX or .CSV AX 2012

static void fileType(Args _args)
{
    Filename filepath;
    Filename filename;
    Filename fileType;
    str fileNameString,fileNamePath;
 
    fileNamePath=@"D:\Sreekanth\3729\Hour rate2.csv";
    [filepath, filename, fileType] = fileNameSplit(fileNamePath);
    fileNameString= filename + fileType;
    info(strFmt("filename=%1 \nfileType=%2",filename,fileType));
}

Comments

Post a Comment

Popular posts from this blog

Create RFQ through X++

static void CreateRFQ(Args _args) {     AxPurchRFQCaseTable         axPurchRFQCaseTable;     AxPurchRFQCaseLine          axPurchRFQCaseLine;     PurchRFQCaseTable           purchRFQCaseTable;     PurchRFQCaseLine            purchRFQCaseLine;     str         RFQCaseId;     NumberSeq numberSeq;     ;     numberSeq = NumberSeq::newGetNum(purchParameters::numRefPurchRFQCaseId());     numberSeq.used();     RFQCaseId = numberSeq.num();     axPurchRFQCaseTable = new AxPurchRFQCaseTable();     axPurchRFQCaseTable.parmRFQCaseId(RFQCaseId);     axPurchRFQCaseTable.parmBidType(PurchRFQBidType::Open);     axPurchRFQCaseTable.parmCurrencyCode('INR');     axPurchRFQCaseTable.save();     axPurchRFQCaseLine =...
Read more

Base enum values in Dynamics 365

By writing the statement 1 we will get the basenum id. And then writing the second statement we will get the list of total values. BaseEnum - 'LogisticsAddressElement Stataement 1 : select * from ENUMIDTABLE where name = 'LogisticsAddressElement' Stataement 1 : select * from ENUMVALUETABLE where ENUMID = 4709
Read more

Project Id through X++ code

void clicked() {     ProjTable                   projTable;     ProjInvoiceTable            projInvoiceTable;     ProjFundingSource           projFundingSource;     ProjFundingRule             projFundingRule;     ProjFundingRuleAllocation   projFundingRuleAllocation;     NumberSeq                   numberSeq,numberSeqInv;     NumberSequenceFormat        _numberSequenceMask;     ProjParameters      projParameters  = ProjParameters::find();     super();     ttsBegin;     numberSeq = NumberSeq::newGetNum(ProjParameters::numRefProjId());     numberSeqInv = NumberSeq::newGetNum(ProjParameters::numRefProjInvoiceProjId());     proj...
Read more