# Select some record field

**URL:** <https://forum.cloverdx.com/t/select-some-record-field/126>\
**Category:** CloverDX Platform\
**Created:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/select-some-record-field/126 "2007-07-16T00:00:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/select-some-record-field/126/1 "2007-07-16T00:00:00Z")

</div>

Hello,

I’am a beginner with cloverETL, and as evaluation, I wanted to try some simple exemple.

This is my first problem : I have a csv file, say InputFile.csv. In that file, the lines have this format :

8\<-----------------  
field1;field2;field3;field4  
8\<-----------------

And I want to copy this file to OutputFile.csv but without the third field :

8\<-----------------  
field1;field2;field4  
8\<-----------------

I thougth than some standard component could solve this problem, so I search in doc and components Java API, but I didn’t find anything.

So I think I could use some kind of Reformat component, could I ?  
If this is the solution, which metadata have I to put, on which edge ?  
Is it something like that :  
8\<-----------------

 8\<----------------- 

Any help is appreciated.  
Thanks in advance (and excuse me for my ugly english)

Francois

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/select-some-record-field/126/2 "2007-07-16T08:23:44Z")

</div>

I tried something like that. In fact it was my first idea of what is a metadata and how I can use it, but the process stop after the first line… I will have another look at my xml to see where is my error.

Many thanks for your help,

François

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/select-some-record-field/126/3 "2007-07-16T08:23:45Z")

</div>

Hello!

In one minute i prepared in Clover.GUI easy schema for your purpose.

\<?xml version="1.0" encoding="UTF-8"?\> ${out.0.Field1} = ${in.0.Field1}; ${out.0.Field2} = ${in.0.Field2}; ${out.0.Field4} = ${in.0.Field4}; 

If you have any questions, i’m ready to answer you. GL, Martin.

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/select-some-record-field/126/4 "2007-07-16T08:23:46Z")

</div>

First mistake i see in the last field of your metadata. Delimiter is probably \r\n or \n.

OtaSanek