I have newbie question...

I have a price file in a fixed format:

sku(6)descr(12)retprice(6)wholeprice(6)

as one text string...

"PD3456PRODDESCRIPT001899002499"

How do I import into the database? (I went the excel route) I'd rather import it directly into foxpro

And the other question is once I get the price as a text string of say "001899" how do I turn it into 18.99 number?

Do I divide the number by 100 is that a calcuated field area?

Thanks

I have newbie question...

I have a price file in a fixed format:

sku(6)descr(12)retprice(6)wholeprice(6)

as one text string...

"PD3456PRODDESCRIPT001899002499"

How do I import into the database? (I went the excel route) I'd rather import it directly into foxpro

And the other question is once I get the price as a text string of say "001899" how do I turn it into 18.99 number?

Do I divide the number by 100 is that a calcuated field area?

Thanks

I have newbie question...

I have a price file in a fixed format:

sku(6)descr(12)retprice(6)wholeprice(6)

as one text string...

"PD3456PRODDESCRIPT001899002499"

How do I import into the database? (I went the excel route) I'd rather import it directly into foxpro

And the other question is once I get the price as a text string of say "001899" how do I turn it into 18.99 number?

Do I divide the number by 100 is that a calcuated field area?

Thanks

I'm not sure how it works in foxpro, but in FileMaker Pro, you would import the string into one text field, then parse that into individual fields using the middle() function.

To convert that text number into a decimal number, dividing by 100 should work if the numbers always have a 2-digit decimal portion.

I'm not sure how it works in foxpro, but in FileMaker Pro, you would import the string into one text field, then parse that into individual fields using the middle() function.

To convert that text number into a decimal number, dividing by 100 should work if the numbers always have a 2-digit decimal portion.

I'm not sure how it works in foxpro, but in FileMaker Pro, you would import the string into one text field, then parse that into individual fields using the middle() function.

To convert that text number into a decimal number, dividing by 100 should work if the numbers always have a 2-digit decimal portion.

Thanks for the reply ... I meant FM Pro sorry for the slip.

I will try that thanks.

Thanks for the reply ... I meant FM Pro sorry for the slip.

I will try that thanks.

Thanks for the reply ... I meant FM Pro sorry for the slip.

I will try that thanks.

Adding to what Ender said:

The parsing formulas are:

sku = Left(ImportDataField;6)

Descr = Middle(ImportDataField;7;12)

retprice = Middle(ImportDataField;19;6)/100

wholeprice = Right(ImportDataField;6)/100

Adding to what Ender said:

The parsing formulas are:

sku = Left(ImportDataField;6)

Descr = Middle(ImportDataField;7;12)

retprice = Middle(ImportDataField;19;6)/100

wholeprice = Right(ImportDataField;6)/100

Adding to what Ender said:

The parsing formulas are:

sku = Left(ImportDataField;6)

Descr = Middle(ImportDataField;7;12)

retprice = Middle(ImportDataField;19;6)/100

wholeprice = Right(ImportDataField;6)/100