Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to be able to list strings in a Column on report

Status
Not open for further replies.

fcullari

IS-IT--Management
Oct 28, 2002
30
US
I have a string data field with numbers separated by comma's.

Example of data:
0470,08161,08845,28845,0458,08058,41319,41329,41330,44154,44450,44454,R00600,M0458,M00600,M02600,F00458,85264,83454,83444

I want to have these numbers listed in a column and sorted

expected output
0458
0470
08058
08161
08845
28845
etc

How to I code this, it's already a formula field.

 
Hi,
What formula created that field?



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 

It's a simple formula
{datFieldUser.Field_Value}
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top