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!

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

Remove domain

Status
Not open for further replies.
seal2b1

seal2b1

IS-IT--Management
Aug 27, 2008
10
US
I am using crystal reports XI. I am using data from a login field out of a database. It gives me the login "domain\userid". I want to just pull the userid out and eliminate the domain name in the report. Is this possible?
 
Sort by date Sort by votes
If I'm following you, you could create a formula:

split({table.login},"\")[2]

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

crytalbria
  • Locked
  • Question
Remove text between two points within a string
Replies
4
Views
176
crytalbria
crytalbria
socalvelo
  • Locked
  • Question
Remove Apartment Number from Address Field 1
Replies
2
Views
172
socalvelo
socalvelo
mart10
  • Locked
  • Question
Remove bracketed data inc the brackets
Replies
8
Views
74
mart10
mart10
jomeir
  • Locked
  • Question
Formula to remove bracketed text 2
Replies
6
Views
144
jomeir
jomeir
rwn
  • Locked
  • Question
CONCATENATE to remove duplicates NOT working
Replies
2
Views
155
rwn
rwn

Part and Inventory Search

Sponsor

Back
Top