Ab initio to read comma delimited values

Question

What should be my DML for input file which has data like 1,2,34,43,66

The problem which i am facing when i put the below DML

record decimal(",") val; end;

is that the last number is not getting read properly.

Is there any way to read this by only using Input file component.

Welcome to Stack Overflow! Please read [what this site is about](https://stackoverflow.com/about) and "[How to ask](https://stackoverflow.com/questions/how-to-ask)" before asking a question. — tobsob, Dec 11 '19 at 06:48

score 0 · Answer 1 · answered Dec 22 '19 at 08:28

0

you have described only ONE numeric field, but you have 5 fields

"new line" (new record) also should be described

are you using BRE ? you could create DML in BRE

answered Dec 22 '19 at 08:28

Zam

2,880
1
18
33

score 0 · Answer 2 · answered Jan 14 '20 at 20:04

0

You can try the following DML I guess it should work:

record
decimal(",") val1;
decimal(",") val2;
decimal(",") val3;
decimal(",") val4;
decimal(",") val5;
string("\n") newline = NULL;
end

answered Jan 14 '20 at 20:04

Abhishek Lokare

11
2

score 0 · Answer 3 · answered Feb 19 '20 at 14:27

I presume you want to read each number as a record. The problem is: data is not compatible with your desire, last number is not delimited by a ",".

If you can't change the data, you could read all the input in a single record, using:

record
 string("\n") val;
end

then use a normalize component to split the record:

out :: length(in) =
begin
  out :: length_of(string_split(in.val, ","));
end;

out :: normalize(in, index) =
begin
   let string(";")[5] my_vec;
   my_vec =  string_split(in.val, ",");
   out.val :: decimal_lpad( my_vec[index], 5 );
end;

(there are probably better solutions, I am still not an expert, but there wasn't an answer yet)

Ab initio to read comma delimited values

3 Answers3