Display a value as feet (') and inches (")

[DataKnight1]

Hi,

I'm assuming this will be relatively easy, and hopefully save me some time!  I'm wanting to change the way two separate values are displayed and want to do this in the load script.

I have a value, for example;

20

I want to display this as feet;

20'

I have another value, for example;

6

I want to display this as inches;

6"

Firstly, how would this be achieved?

My end result, after combining the two fields will be;

20' 6"

Thanks

[MayilVahanan]

Hi

Hope you have 2 fields like below

Load *, Feet&chr(39)&Inch&'"' as FeetInch Inline
[
Feet, Inch
20, 6
];

Feet&chr(39)&Inch&'"' as FeetInch <-- helps to achieve the expected results.

Regards,

Mayil Vahanan R

[DataKnight1]

Hi Mayil,

Thanks for your prompt response.

Whilst your solution would fix the specific values in question - what if there were thousands?  I don't want to key each one in an INLINE table...

Eg;

So may aim is to reformat the fields in script so they display as;

1'0"

2'0"

3'0"

4'0"

4'6"

etc...

[MayilVahanan · Accepted solution]

Hi,

Actually, I've provided the sample data & solution.

In your script, you can use like below

YourFeetFieldName&chr(39)&YourInchFieldName&'"' as FieldInch 

[DataKnight1]

Great - thanks very much!

Have a good day.

Simon