[MSAccessProfessionals] Parse text strings

Hello all, 

We have moved to Workday where the reports are so limited and have columns with data that should be in columns. I am trying to get at least one column to be parsed into different columns, but the variances of the text strings has no clear delimited way of breaking out the strings. in fact the string is actually 10 columns merged into one column. It is separated by tabs and sometimes commas. some department names have spaces. 

is there a way to program a parsing of the string to get into the needed columns? 

 

Thank You

 

Jim Wagner 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116690) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_