topic Re: Remove header white space delimited file in Talend Studio

Remove header white space delimited file

Anonymous — Fri, 01 Sep 2017 14:05:10 GMT

Hello all,

I have a csv file with headers such as "emp id", "location address" and so on. I need a way to remove these whiter spaces so that I can run the job through tMap. I am pretty new to Talend there is no one here who can help.

Also, the file name will continuously change with a timestamp appended to it.

Thanks

Re: Remove header white space delimited file

TRF — Fri, 01 Sep 2017 14:11:41 GMT

Do you plan to have dynamic schema?

Else, you don't have to worry about the fileds name in the header.

Just ignore the header where reading the file.

For the 2nd point, if you don't know the filename when the job starts, you need to use tFileList with a filemask to get the desired file (I suggest you to rename or move the file when the job finishes).

Re: Remove header white space delimited file

Anonymous — Fri, 01 Sep 2017 14:18:35 GMT

It will not be dynamic. How do I go about ignoring the included first-row header?

Re: Remove header white space delimited file

TRF — Fri, 01 Sep 2017 14:32:00 GMT

Set the header field to 1 in the basic settings tab for tFileInputDelimited component

Re: Remove header white space delimited file

Anonymous — Fri, 01 Sep 2017 14:34:26 GMT

When I did that, tMap was erroring.

Re: Remove header white space delimited file

TRF — Fri, 01 Sep 2017 14:35:24 GMT

share your job + tMap configuration + error

Re: Remove header white space delimited file

Anonymous — Fri, 01 Sep 2017 14:47:32 GMT

It is a simple tFileInputDelimited->tMap->tFileOutputDelimited where I am mixing around the columns.

Re: Remove header white space delimited file

TRF — Fri, 01 Sep 2017 14:49:24 GMT

Share the pictures else I can't help you anymore

Re: Remove header white space delimited file

Anonymous — Fri, 01 Sep 2017 14:54:30 GMT

Oaky. I will have to do this after my morning 2 meetings. I have to break these out of something bigger and do some renaming prior to posting. There is too much confidential info being displayed currently.

Re: Remove header white space delimited file

Anonymous — Mon, 04 Sep 2017 04:16:08 GMT

Hello,

Elaborating your case with an example with input and expected output values will be preferred.

Feel free to let us know if there is any problem for you to upload your job setting screenshots into forum.

Best regards

Sabrina

Re: Remove header white space delimited file

Anonymous — Mon, 04 Sep 2017 14:07:35 GMT

Well, I am not sure why, but this morning, things seem to be working as described.

Steve

Re: Remove header white space delimited file

TRF — Mon, 04 Sep 2017 14:13:34 GMT

Great! Feel free to come back in case of new troubles.

Re: Remove header white space delimited file

Anonymous — Mon, 04 Sep 2017 14:28:47 GMT

Before I start a new topic, is there any information already in existence about adding white space to a header on output?

Re: Remove header white space delimited file

TRF — Mon, 04 Sep 2017 14:34:49 GMT

Hi,

I suppose you want to retrieve your original header when writting to the output file.

If so, the simplest is to get just the heading line when the job starts (tFileInputDelimited with Header = 0 and Limit = 1), then reuse this record to initialize the output file (tFileOutputDelimited with Includ Header unchecked).

Following records will be written to the same output using an other tFileOutputDelimited with Append option checked.

Is that what you're looking for?

Re: Remove header white space delimited file

Anonymous — Tue, 05 Sep 2017 07:26:20 GMT

Hello,

Can we consider this topic as resolved?

Best regards

Sabrina

Re: Remove header white space delimited file

Anonymous — Tue, 05 Sep 2017 10:28:45 GMT

@xdshi wrote:

Hello,

@xdshi wrote:

Hello,

Can we consider this topic as resolved?

Best regards

Sabrina

I did set this post as solved yesterday. Thanks for asking/following up.