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 (67.193.52.164)	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 (67.193.52.164)	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 (Brian_Shead), 223 Guests and 0 Spiders online.

Key: Admin, Global Mod, Mod

Forum Stats

1873 Members
5 Forums
14553 Topics
71030 Posts

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

October
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	31