Export first name initial only

psutulovich
Hobbyist

Export first name initial only

How would I export the student's initial of their first name?

2 Replies
jasonbengs
PowerSchool Mentor
PowerSchool Mentor

I usually export the first name then in the csv file I use a formula in excel/google sheets to get the first initial. 

In this example I get the first initial by typing =left(B2,1) in cell A2

This will grab the first letter on the left of cell B2

 

jasonbengs_0-1666710503619.png

 

Jason Bengs, M. Ed
SIS/Database Administrator

Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution. Thanks!

Mentors_badgeChampions_badge
CindyM8
Expert

This was asked/answered recently in another post:

 

https://help.powerschool.com/t5/Community-Forum/First-Name-Initial/td-p/429406

 

^(first_name;substring=1,1)


CM