Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Adjusting File Names

Posted on by Microsoft Employee

In This Function. I am finding any files in that folder. I then need to add the File Names to a table. Then with these files names in the table I Need to trim the name down from WBTCH-001007 - 20160920_140517 to Just WBTCH-001007. 

Whats a good way to do this! thanks 

objFiles.RESET;
objFiles.SETFILTER(Path, '%1', recManufacturingSetup.AegisFolderPackoutRoot);
objFiles.SETFILTER(Name, '@*xml');
objFiles.SETRANGE("Is a file", TRUE);
// record files for processing to avoid delays in updating File System records
IF objFiles.FINDSET(FALSE, FALSE) THEN REPEAT
recAegisPackoutImport.Filename := objFiles.Name
UNTIL objFiles.NEXT =0;

PackoutFileName :=
//Get File Name and Shrink it to just WBTCH-001007

*This post is locked for comments

  • Verified answer
    RE: Adjusting File Names

    Hi,

    Use DELCHR or DELSTR function.

    Example would be like this:

    PackoutFileName := DELSTR('WBTCH-001007 - 20160920_140517', 12, 18);

    Reference:

    msdn.microsoft.com/.../dd354973.aspx

    https://msdn.microsoft.com/en-us/library/dd355198.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans