web

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

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) get substring before a...

Microsoft Dynamics AX (Archived)

get substring before a character from a string?

(0) Share

Report

Report

Posted on by Long.Thai

130

For example, if I have

string test = 'Accounts receivable/Common/Customers/Customers past due';

and I want to extract everything before the firsts '/", and return Accounts receivable. What would be the way to go about doing this?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Long.Thai 130 on at

Like (0)

Report

RE: get substring before a character from a string?

I have found the way to do it.

string test = 'Accounts receivable/Common/Customers/Customers past due';

test = subStr(test, 1, strFind(test, '/', 1, strLen(test)));

test = strRem(test, '/');

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report
RE: get substring before a character from a string?

You should be using strSplit function to separate strings by a specific character.

Here you go:

str testStr = @'Accounts receivable/Common/Customers/Customers past due'; List elements = strSplit(testStr, @'/'); ListEnumerator listEnum = elements.getEnumerator(); listEnum.moveNext(); info(listEnum.current());

There is another solution, which requires less coding, with containerization of your string by a separator character, and pulling the first element:

info(conPeek(str2con(testStr, @'/'), 1));

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Tocauer 4

#2

Community Member 2

#2

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans