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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extract test with special characters

Status
Not open for further replies.
Samalombo

Samalombo

Programmer
Mar 3, 2021
1
0
0
ZA

Dear, I am new to SSIS.

I have a column with certain data examples ds/dt/gsc4/dts / or dsxx/dsdt/xxxxc4/dtsss/

I need to know if it is possible to use the special character '/' and get all text before the third occurrence of the special character '/' for example.
 
Status
Not open for further replies.

Similar threads

TomaszB12
  • Locked
  • Question
Problem with package execution
Replies
1
Views
79
mark williams
mark williams
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
65
fredericofonseca
fredericofonseca
AMalhotra
  • Locked
  • Question
File generation by SSIS in UTF-8 without signature with french characters
Replies
1
Views
68
MakeItSo
MakeItSo
arunaramana
  • Locked
  • Question
what are the items in a collection that referred in foreach item type enumerator within foreach loop
Replies
1
Views
69
Igelchen
Igelchen
thorny00
  • Locked
  • Question
Extract data in blocks of 15,000 from outside server to my SQL database
Replies
2
Views
48
thorny00
thorny00

Part and Inventory Search

Sponsor

Back
Top