Hi Expert,
In my file one column is like
Id
A9874672
c6784647
h9778334
....
this way
8-lenght fixed data
first character is: A-Z,a-zonly
other 7 chracters are integers:0-9
i want to load this kind of data only to avoid all Irrespective data, how can it possible
Substring(id,0,1)=A-Z,a-z
Substring(id,2,8)=0-9
How to write this expression.............give me solution ?
Loading
Dipankar BiswasPosted Sep 5, 2014, 12:30 PM