SachAccess
Active member
- Local time
- Today, 05:16
- Joined
- Nov 22, 2021
- Messages
- 389
Hi,
I have a table. Value in the table is something like below.
Utilitatis|causa|amicitia|est|quaesita|Utilitatis|causa|amicitia|est|quaesita|Utilitatis|causa|amicitia|est|quaesita|Utilitatis|causa|amicitia|est|quaesita|
Separator is pipe character. I want to split this data in different fields.
At present, this entire text in one field. I wan to split it as per pipe separator. How do I do this.
Can anyone please help me in this.
I have a table. Value in the table is something like below.
Utilitatis|causa|amicitia|est|quaesita|Utilitatis|causa|amicitia|est|quaesita|Utilitatis|causa|amicitia|est|quaesita|Utilitatis|causa|amicitia|est|quaesita|
Separator is pipe character. I want to split this data in different fields.
At present, this entire text in one field. I wan to split it as per pipe separator. How do I do this.
Can anyone please help me in this.