Trim - Gridview Calculated Column - Adagio Accounting | Technical Support Forums

You are not logged in. [Log In] Adagio Home Page » Forums » General Discussion » Technical Support » Trim - Gridview Calculated Column

Topic Options

#22259 - 05/11/10 05:26 PM Trim - Gridview Calculated Column
SusanTennier Adagio Maestro Registered: 02/22/08 Posts: 1247 Loc: Ontario, Canada	Can I use Trim for a calculated column to accomplish this: When Trx Id is 123456N make it 123456. Also, when Trx ID is 123456I make it 123456. In other words, remove any letters from the transaction ID. Is this possible? What is the formula? Please advise. _________________________ Susan Tennier TDL Canada Trenton, Ontario
Top

#22260 - 05/11/10 05:53 PM Re: Trim - Gridview Calculated Column [Re: SusanTennier]
SusanTennier Adagio Maestro Registered: 02/22/08 Posts: 1247 Loc: Ontario, Canada	Wow.. I figured this out too. I used, Left(Trim({Trx Id}),6) and it worked! Amazing!! I love the Trim command! Sorry I would delete these posts, but don't see that as an option anywhere. _________________________ Susan Tennier TDL Canada Trenton, Ontario
Top

View All Topics

Moderator: Christa_Meissner

1 registered (1 invisible), 112 Guests and 0 Spiders online.

Key: Admin, Global Mod, Mod

Forum Stats

1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM

April
Su	M	Tu	W	Th	F	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30