Finance | Project Operations, Human Resources, ...

Removing leading and ending spaces from a string field

(0) Share

Report

Posted on by skd

390

Hey team,

I have a scenario in which I have a simple list form with various fields like firstname,lastname etc. Now I want to just remove spaces from the start and end of the FirstName and LastName. Eg: The name of an employee is Amaia Scott Delany. So, the FirstName is "Amaia" and Last Name is "Scott Delany" if the user is entering the FirstName as " Amaia " and Last Name as " Scott Delany". In this case I just want to trim the spaces from the start and and the end so it should save it in this way, FirstName: "Amaia" and LastName: "Scott Delany". The space between "Scott" and "Delany" should be maintained. Please can you help me achieve this using x++.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!

Hi SKD,

Are all of your names delimited by the first space between the firstname and lastname？

Please check the strScan method:docs.microsoft.com/.../xpp-string-run-time-functions

It will return the first occurrence of the text string mentioned in the parameters.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use strLTrim and strRTrim functions: docs.microsoft.com/.../xpp-string-run-time-functions

Was this reply helpful? Yes No
Suggested answer

PA-22040759-0 6,194 on at

Like (0)

Report
Copy link

Link copied!

Or StrLRTrim from the Global class

Was this reply helpful? Yes No