One line with two characteristics

[#1]

How can i do a treatment of table with two values like?

Header 1	Algoritmo	Header 3	Header 4
	KNN PARZEN
	KNN BAYES
	PARZEN BAYES

I want to work filtering just on Algoritmo in Column each time

[avinashelite]

Can you please elaborate your problem

[tresesco]

You have to use Subfield(). But for that, there has to be a separator between two values. Assuming that your Algoritmo field values are separated by a space (like: Value1 Value2), you could try something like:

Load

          Field1,

          ...,

          SubField(Algoritmo, ' ') as NewAlgoritmo

From <>;

Here, subfield() would generate one full record of input data for each substring that can be found in the original string.

Therefore, all you have to find is a separator.

[aveeeeeee7en]

Hi Alysson

Though your Requirement is not clear but as per my understanding, in your case

you can use chr(13)

eg. Field1&chr(13)&Field2

or you can use Subfield() function as Tresesco Sir said.

Regards
Aviral Nag