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!

Loading a comlicated text file (text-splitting)

Status
Not open for further replies.
krisbee

krisbee

Programmer
Mar 31, 2006
1
0
0
DE
Hello,
I´m new in datastage and I want to import a normal textfile into a table definition.
The problem is the structure of the text file.
It´s something like that:

12101998mikemason2010200625102006

i want to split/load it into a table like with a format like this:

Born_Date | Pre_Name | Sur_Name | In_Date | Out_Date
12101998 | Mike | Mason | 20102006| 25102006

thaxx for helping *kris
 
Status
Not open for further replies.

Similar threads

Loanpro
  • Locked
  • Question
Passing + sign to .csv file
Replies
0
Views
37
Loanpro
Loanpro
gmoorthy
  • Locked
  • Question
Autosys file watcher names
Replies
0
Views
58
gmoorthy
gmoorthy
lgvalencia
  • Locked
  • Question
ACCESS VBA
Replies
0
Views
39
lgvalencia
lgvalencia
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
2
Views
51
rickeybj
rickeybj
rickeybj
  • Locked
  • Question
Is there a way to transfer files from and old Tandy word processor to a PC?
Replies
0
Views
43
rickeybj
rickeybj

Part and Inventory Search

Sponsor

Back
Top