Remove header white space delimited file

[Anonymous]

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

[Anonymous]

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

Steve

[TRF]

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

[Anonymous]

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

[TRF]

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?

[Anonymous]

Hello,

Can we consider this topic as resolved?

Best regards

Sabrina

[Anonymous]

@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.