This content has been marked as final. Show 5 replies
you need at least a marker as | to make a delimited file.1 person found this helpful
In this case you will have
in this case you have to process file to insert a row delimiter by jython.
This is not fixed if it's not the same number of characters for each row.1 person found this helpful
So if there is no delimiter, there is no way to easily create a datastore. In addition you have null values.
Even regex is not possible because emp_name and dept_name are both composed of letters. Unless the emp_name is always on 3 characters as in your example. If it's not the case, I don't think it's possible.
How abt this one now i have only Name and Emp_Id
Name of 3 Char and Emp_Id of Number(3)
now i want to load this data in 3 rows
is it Possible
Hi, how many rows are expected?1 person found this helpful
I'd use a jython step before that every 6 char insert a new line. You could use this guide
if i find i'll post to you the solution
You could try this:1 person found this helpful
1. Define the file source as fixed
2. Select Other under the Record Separator, but do not enter any code
3. Define column names and length as needed.
4. Check how the data look using View Data
It worked for me.