Hi Team,
I want to Trim the starting characters from a field in acumatica. I tried using “Split” function, but it is not working as expected.
Please help me on this.
Sample code:
Regards,
Ramya
Best answer by NageswaraRaoAddanki60
View original
Hi
You need to split with a front slash (\) and get the list. Then You can eliminate the first record and use the second one. Adjust the code as per your requirement.
Sample:
string[] values = row.Name?.Split('\,');
string value = values.Length > 1 ? values[1] : string.Empty;
Userlevel 7
+17
Hi
Hope you are doing well!
You can use the normal C# code to substring based on the slash character. Please find the line below for reference.
https://stackoverflow.com/questions/1857513/get-substring-everything-before-certain-char
hope this helps!
Hi
You can use this in your solution, may be it will help you for splitting (\) slash.
string value = @"Report Log(7 RL-000007)\SPYTL FRD Timecard V03-signed";
value = value.Split('\\')[1];
Thank you..!
Hi
Thanks for the response. hope you are doing well!!
I’m facing one more problem escape character ‘\’. could you please help me yo rectify.
Thanks
after using “\\” it is working.
Regards,
Ramya
Userlevel 7
+17
Awesome
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.