smtazulislam
Member
- Local time
- Today, 09:28
- Joined
- Mar 27, 2020
- Messages
- 806
Hello, peace be upon your
I have a textbox [short text] in continuous form where I added data like
I tried to USING, LTrim, REPLACE, SPLIT function but at last not success to enter the new Text in the report.
I would like to insert "Items Received" put in the report page separate textbox after COMMA,
I have a textbox [short text] in continuous form where I added data like
FacilityID | Date | Code | Items Received | Quantity | Total Quantity | Items Quality | Items Status |
1 | 01/11/2022 | 2022110001 | Laptop, Mobile Set, TV, | 1 | ????? | Used | Current |
2 | 12/12/2022 | 2022120024 | Sleeping Accessories, Refrigerator Family Size | 1 | ?????? | New | Current |
I tried to USING, LTrim, REPLACE, SPLIT function but at last not success to enter the new Text in the report.
I would like to insert "Items Received" put in the report page separate textbox after COMMA,
SL | Date | Code | Items Received | Quantity | Items Quality | Items Status | |
1 | 01/11/2022 | 2022110001 | Laptop | 1 | Used | Current | |
2 | Mobile Set | 1 | Used | Current | |||
3 | TV | 1 | Used | Current | |||
4 | Sleeping Accessories | 1 | New | Current | |||
5 | Refrigerator Family Size | 1 | Used | Current |