how to remove some part of row data?

[#1]

hi guys,

my input is like this,

col1 from source

---------------------

customer1 H1

H1 customer2

customer3 H1

i need output in dashboard level like this:

customer1

customer2

customer3

how we can control at edit script level?

Thanks in advance...

[#2 · Accepted solution]

Shiva,

You can do this with MapSubstring() function.

Have a look at the attached application.

- Sridhar

[#3]

gr8 help thank u...Sridhar.