DSXchange

Posted: **Wed Nov 17, 2010 3:02 pm**

Hi

I have a field (column) of type varchar and values like below

$60000 cash
$3835.50 MRY SINGLE.

I want to populate like below

$6000
$3835.50

can any one suggest me the solution

Thanks
Srini

Posted: **Wed Nov 17, 2010 3:03 pm**

Use the Field() function to take the first field from a space delimited string.

Posted: **Wed Nov 17, 2010 3:15 pm**

chulett wrote:Use the Field() function to take the first field from a space delimited string.

The length of the field may vary , because originally field type and length is varchar 254.

can you give me the function syntax

thanks

Srini

Posted: **Wed Nov 17, 2010 3:53 pm**

Field(columnname,' ',1)

DSXchange

trimming a field of type varchar

trimming a field of type varchar