topic Read CSV file with space delimiter in Talend Studio

Read CSV file with space delimiter

housseinHTR — Sat, 16 Nov 2024 06:28:56 GMT

Hello,

I have a csv file like this:

11111111111 22222222222 33333333333333 xxxxxxxxxx

where the delimiter look like a single or multiple spaces.

In addition to that, the last column may contains spaces.

What is the best practice to read a similar file?

Thanks in advance.

akumar2301 — Wed, 27 Feb 2019 10:33:27 GMT

Does your schema is static or Dynamic ? Do you know many fields(Without space) your input can have ?

housseinHTR — Wed, 27 Feb 2019 10:39:59 GMT

Thanks Abhishek KUMAR for your reply.

The input file has always 4 columns, but the positions of the fields may change.i.e.:

11111111111 22222222222 333333333333 xxxxxxxxxxxxxx or

11111111111 22222222222 333333333333 xxxx or

11111111111 22222222222 333333333333 xxxxxxxxxx or ....

Regards

akumar2301 — Wed, 27 Feb 2019 11:02:14 GMT

try tFileInputregex

with regex expression

"^\\s*(\\w+)\\s+(\\w+)\\s+(\\w+)\\s+(\\w+)\\s*"

housseinHTR — Wed, 27 Feb 2019 12:23:43 GMT

Thank you again.

At first glance, it's works.

But when the last column contains space, it split the value and get only the first part.

Can you update the regex expression to resolve this issue?

Regards

akumar2301 — Wed, 27 Feb 2019 12:35:05 GMT

I am assuming that only last column can have space.

"^\\s*(\\w+)\\s+(\\w+)\\s+(\\w+)\\s+(.*)"

housseinHTR — Wed, 27 Feb 2019 12:48:18 GMT

Thanks a lot, its works fine now.

Regards