Manipulating Text Data Fields

[bsagal]

Hello,

I have 2 questions about manipulating text in data fields.

I have a field that contains records that are typical of the following:

FS32 T
NA5204 U
ZGT R

I wish to eliminate everything from after the first group of letters to the end, in other words i want

FS32
NA5204
ZGT

And my second question is how can i connect data from 2 fields and make them 1.

For example, if field 1 has

AZT3

and field 2 has

642

how can i get AZT3642?

Thanks for your help!

 

[sxschech]

Use instr to strip off information after spaces:
left(FIELD,instr(FIELD," &quot-1)

Use concatenation (& symbol )to join fields together:
FIELD1 & FIELD2

If you need a space or other character use quotes:
FIELD1 & " " & FIELD2
FIELD1 & "-" & FIELD2

 

[bsagal]

Thanks very much brother, i appreciate your help