Want to show the IPaddress

[Anonymous]

Hi,

I have field IPaddress under that field the data are storing in two ways one is IPAddress(10 Numeric value with Dot ) and Mac Address(25 characters with colon) now i want display only the IPAddress not the Macaddress.Can any one help on this.

Regards,

Sivakumar

[arulsettu]

can you post some sample source?

[robert_mika · Accepted solution]

In your load statement

if(LEN(Address)=10,Address)

where Address is your Column/Dimension

[Anonymous]

Thanks Robert

[robert_mika]

You are welcome