split field

[#1]

Hi,

I need to solve this:

In one field there arae Invoices  and Shipment dcuments:

---------------

   Document    |

---------------

I1

I2

I3

I4

..

Sh1

Sh2

Sh3

Sh4

-----------------

I need to split this field in 2 fields:

========                 =============

Invoice                      Shipment doc

========                 =============

I1                                sh1

I2                                sh2

I3                               sh3

I4                                sh4

..                        ....

========                 ==============

Is it posible?

many Thanks

regards

Kla

[jvitantonio]

temp:

LOAD Field as Invoice FROM yourfile.xls

WHERE left(Field,1)='I'

;

temp1:

LOAD Field as Shipment FROM yourfile.xls

WHERE left(Field,2)='Sh'

;

Then you can use the fields as you want. You can also concatenate boths tables.

Hope this helps.

[swuehl]

You can split your field f.e. like

INVOICETABLE:

LOAD

Document as Incoice

resident YOURTABLE where Document like 'I*';

SHIPMENTTABLE:

LOAD

Document as [Shipment doc]

resident YOURTABLE where Document like 'Sh*';

But this creates two tables, unlinked to each other. I assume you are having more than this one field, so you could probably use a key field to link these tables?

[#4]

Thanks but I think is not the correct solution. In my sample I used the

I and Sh to distinct the documents.  The documentNo. are the numbers I can't

filter the string. I need to know if there is the statement..

[#5]

There is also one field:

documentType

=========

Invoice

Shipment

==========

thanth group the documents...

[jvitantonio]

Ok, the same as before but use

.

.

.

WHERE documentType = 'Invoice'

and

WHERE documentType = 'Shipment'

for the second table.

[#7]

ok but may be I don't explain well rhat I need to solve:

In one tablthere are:

Document Type  shiipment and Invoice) , Document No

load

Document type, DocumentNo, Cust_No ....

In other table There is the field shipment (just shipment documentNO):

load

DocumentNo as Shipment, Cust_No ....

Now I need to create a new field in the second table: Invoice. I need to put the table in the "same row"

[jvitantonio]

you will need to join your data in same way to have the documentType, otherwise you need to do it manually if there's no patter in your invoice and shipment names. You can try joining by cust_no to the the document type. Is there any way you can attach your example? You can put some sample data if you want.

[#9]

Yes I  already  done what you suggest but the application" goes out of data"

There are many many data.

I tried also by mapping statement.

Now, I post the sample code...