Re: [MSAccessProfessionals] Parse text strings

Duane,

I work for a university and FERPA laws prevent me from showing data. I did find something late last night. It is a function that I could use in a query. I will let you know and share it with the group for others to use. 

Thank You 

Jim Wagner

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Duane Hookom via groups.io <duanehookom=hotmail.com@groups.io>
Sent: Tuesday, April 22, 2025 8:32 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Parse text strings

 

Hi Jim,

We would really need to see some sample data as well as what it looks like parsed. 

Duane

---

From:  Jim Wagner

 

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 

_