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 Mike Lewis 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
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

Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
286
Cpreston
Cpreston
TomaszB12
  • Locked
  • Question
Problem with package execution
Replies
1
Views
229
mark williams
mark williams
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
220
fredericofonseca
fredericofonseca
AMalhotra
  • Locked
  • Question
File generation by SSIS in UTF-8 without signature with french characters
Replies
1
Views
177
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
209
Igelchen
Igelchen

Part and Inventory Search

Sponsor

Back
Top