character will come after next line

[prma7799]

Dear All,

I have one dimension suppose brand in that i have too much lengthy characters so when am using it in charts then my chart is not looking nice.

for that I am using =left(Brand,10) & chr(13) & right(Brand,10)  but all character get meaning less.

So I want after space character into the next line.

e.g

Brand Name: ABC DEF GI IJ K LMN

OUTPUT:

ABC

DEF

GI

IJ

K

LMN

THANKS

[jagan]

Hi,

Try like this

LOAD

'ABC DEF GI IJ K LMN' AS [Brand Name],

SubField([Brand Name], ' ') AS Brand

INLINE [

Brand Name

ABC DEF GI IJ K LMN ];

Regards,

Jagan.

[PradeepReddy]

take a calculated dimension like  =replace(BrandName,' ',chr(13))

But it is not worth full, if the brand names have more spaces ' '

see the attachment, it might be helpful for you..

IF the entire Brand name is in one field, then use Subfield function

[prma7799]

Hi Jagan,

I want to take this in front end only.

[prma7799]

Hi Pradeep,

Your answer is coming properly but I want all character start from left to right.

Thanks

[prma7799]

And when i am taking this into send to excel then all space will hide from brand name.

[jagan]

Hi,

In that case use

=Replace(BrandName,' ', Chr(13))

Regards,

Jagan.

[prma7799]

Hi Jagan,

output is coming perfect but when i am taking this into excel then all space will hide from brand name.

Thanks

[PradeepReddy]

try dimension like this  : =replace(BrandName,' ',chr(13)&' ')

Even when u export the data to excel, spaces will appear..

[PradeepReddy · Accepted solution]

try this...

=replace(BrandName,' ',chr(13)&' ')