

Partner - Specialist
2015-03-20
06:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Trim the right and keep the Characters of Left
Hi,
I want to trim from right side Month and Year and keep the all the words except month and year in a new field.
Plan for the Month Apr-2015
New field= Plan for the Month
MonthYear= Apr-2015.
Regards,
Mohammad
1 Solution
Accepted Solutions


Master III
2015-03-20
06:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LEFT('Plan for the Month Apr-2015',LEN('Plan for the Month Apr-2015')-9)
and for month year use Peter suggestion
3 Replies


Master II
2015-03-20
06:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you tried ordinary string-functions already?
RIGHT(YourFieldName, 😎 AS MonthYear
HTH Peter


Master III
2015-03-20
06:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LEFT('Plan for the Month Apr-2015',LEN('Plan for the Month Apr-2015')-9)
and for month year use Peter suggestion


Partner - Specialist
2015-03-20
06:50 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank You...........Robert...........
2,970 Views
